Databases
Databases: queries, schema and the patterns that keep data safe, from atomic queues on any table to encryption at rest.
A queue on any table in PHP and MySQL
How to make any table into an atomic queue without adding extra columns.
14 October 2025Synthesizing
Long-form music made ten seconds at a time, with control along the whole timeline.
29 January 2025Fast log counters in PHP
Counting things and timing things in a busy PHP application, with atomic counters in shared memory so the database gets one write a minute instead of one per request.
20 January 2025Modular monoliths in PHP
One PHP application built from small modules with strict edges, each ready to become a service.
14 December 2021