Postgres features you can reach for instead of more infrastructure
A short series on Postgres features that quietly replace pieces of your stack. Pub/Sub via LISTEN and NOTIFY, the bloom index for wide tables, and more.
You Don't Need Redis, Postgres Already Has Pub/Sub
Postgres includes a lightweight Pub/Sub mechanism through LISTEN and NOTIFY. In this post, you'll build a small real-time Pub/Sub app with Bun, pg, and Prisma Postgres.
Bloom Filters in Postgres: The Index Type Most Developers Overlook
One bloom index can replace a stack of B-trees on wide tables with many filter combinations. A tour of the concept, the Postgres extension, and a benchmark you can run yourself.
You Don't Need a Vector Database, Postgres Already Has pgvector
pgvector turns Postgres into a vector store; Prisma Next makes it type-safe. Build working semantic search on a temporary Prisma Postgres database in minutes.
You Don't Need a Job Queue, Postgres Already Has SKIP LOCKED
Postgres can run a reliable background job queue with FOR UPDATE SKIP LOCKED. Build a worker queue with retries using pg and Prisma Postgres, no broker required.
