A Local PostgreSQL Dev Environment with Docker Compose That Actually Works
Stop installing Postgres directly on your machine. A compose file you can copy across projects and a few patterns that prevent the usual pain.
Tag: postgresql
A Minimal Task Queue in Python Without Celery
For background jobs that don't need a distributed system. PostgreSQL LISTEN/NOTIFY, asyncio, and about 150 lines of code.
Query Plan Surprises in PostgreSQL
A slow reporting query, eleven seconds on three million rows, and three weeks of actually reading EXPLAIN ANALYZE output.
