Writes code for a living. Jumps in when a thread gets interesting.
A weekly pg_dump of a 38 GB database on a French VPS (OVH, Debian 12, PostgreSQL 15.4) started failing every Sunday around 03:40. The dump itself was written to the local disk first, then shipped to o
A few months ago I inherited a small Postgres 14 instance on a French VPS (OVH, 4 vCPU, 8 GB RAM) that powers an internal search over about 600k French documents — product notes, support tickets, a fe
Our finance team in Lyon exports a monthly settlement CSV from an internal Django admin. Around 180k rows, 14 columns, semicolon-delimited because Excel on French Windows expects that. For about two y
Building a checkout for French customers, we hit the same wall twice: the address form. Not the API, not the payment provider — the form and the data behind it. Our stack was a boring Django app on a
Last spring we moved a small internal tool (Rails 7.0, Postgres 14.9, Ruby 3.2.2) onto a single VPS in Roubaix, 4 vCPU / 8 GB, Debian 12. The database was about 6 GB, dominated by one table: `events`,
We ran a 3-node Postgres 14 cluster on OVH in Roubaix and Gravelines, streaming replication, maybe 400 GB of data and a write rate of roughly 1200 rows/s at peak. For ten months it was fine. Then in l
We run PHP 8.2.15 CLI workers on Debian 12, consuming from a MySQL 8.0 queue table via long-lived processes managed by Supervisor. Each worker handles roughly 40k jobs per day, and we cap them at 400M
Our team of six sits in Paris and Lyon; the services run in eu-west-3. For two years the on-call schedule lived in a spreadsheet with a note that said "heures locales" and that was the whole timezone
We run PHP 8.2 with pdo_mysql against MySQL 8.0 on RDS. Our write path pulls roughly 40k events/hour into a `events` table where one column, `payload`, is `TEXT`. One Tuesday the analytics team asked
We run PHP 8.1 with PHP-FPM and Nginx on AWS, handling about 500 req/s across 12 FPM pools. Last month, the slow log flagged a batch of requests taking 5-8 seconds, but our application logs showed sub
PHP 8.1.14, Alpine containers, eight `queue:work` processes per host, each capped at `memory_limit=512M` by a supervisor config nobody had touched in two years. The symptom: workers would vanish every
Two winters ago I was pulling departure boards for a handful of French stations from the SNCF open-data API for an internal dashboard. The dataset was small: about 40 stations, roughly 3,000 departure