pg_ivm keeps a Postgres materialized view current without cron refreshes. What the README says about indexes, aggregates, locks and pg_dump, and what I'd test first.
PostgreSQL never indexes foreign keys and Laravel's constrained() won't either. Vacuum 1.2 lints the schema in CI, with a baseline for legacy apps. What I…
I moved some production caches to Valkey and kept Redis on others. Here's what actually changed, what stayed identical, and when I'd still pick Redis.
After running PgBouncer for years, I moved one workload to PgCat. Here's what it gave me, where PgBouncer is still better, and the migration steps…
My one-line rule for SQLite vs Postgres, the four PRAGMAs that made SQLite production-ready for me, and the cases where I still pick Postgres without…
I shipped sqlx in a Rust production service for 8 months. Here's the patterns I keep, the footguns that bit me, and what I'd do…