PostgreSQL 17 in production: the features we actually use
Since 17 hit LTS we ran it on our largest projects. What the upgrade was worth and what stayed on paper.
PostgreSQL 17 in production: three features we liked
Postgres 17 shipped in September 2024. Six months after upgrading our projects, three things that really matter.
pgAdmin alternatives in 2025: TablePlus, Beekeeper, DataGrip
pgAdmin gets the job done. But for those who work with databases daily, much more pleasant alternatives exist.
Postgres zero-downtime migrations: the patterns we actually use
Adding columns, renaming, changing types: all without service interruption. Four techniques we apply.
pgvector and RAG: our first client project with AI on internal data
Semantic document search across 8,000 internal documents. Postgres + pgvector + embeddings: lessons learned.
Prisma 5.10 and relationLoadStrategy: a join in the right place
Prisma 5.10 brings relationLoadStrategy, a preview flag that lets you pick between subquery and join for relations. For anyone fighting hidden N+1, it is fresh air.
PostgreSQL 15 in production: the verdict after six months
MERGE, faster logical decoding, better sort performance. What we actually used and what stayed on paper.
