Sqlite

Case study: the Paul Newman Cup

A full walk-through of a small production Flask app: the operational problem, the architecture, the identity-versus-permission model, the database and deployment decisions, the failure scenarios, and what shipping it taught me.

Friday, July 24, 2026 | 11 min read Read

The SQLite trap caught me the same day I wrote about it

I published a post warning that SQLite on an ephemeral filesystem silently loses your database. Hours later, my own app turned out to have been doing exactly that on every deploy.

Thursday, July 23, 2026 | 4 min read Read

Running SQLite in production (yes, really)

I deployed a Flask app to Railway with SQLite as the only database. Here is why that was the right call, and the five things that actually bite when you do it.

Wednesday, July 22, 2026 | 5 min read Read