https://postgresisenough.dev/
Postgres is Enough: How Postgres Can Replace Other Things — A perennial topic in the Postgres world is figuring out just how many other systems (like Redis, Elasticsearch and Kafka, say) Postgres can step in for. This directory rounds up 89 extensions and tools that help Postgres do just that.
about 1 month ago
https://paradedb.com/
Search Without a Second System — One Postgres for your application data, full-text search, vector retrieval, and aggregations. ParadeDB is an open-source Postgres extension that keeps pace with Elasticsearch.
#postgres
#search
#analytics
#etl
#elasticsearch
#olap
about 1 month ago
https://www.dbos.dev/blog/co-locating-workflow-state-with-your-data
Postgres Transactions are a Distributed Systems Superpower —
Should workflow state live in a separate orchestrator, or in Postgres alongside your data? DBOS argues the latter: each step's checkpoint and database updates commit in one transaction, giving exactly-once semantics for those updates with no idempotency bookkeeping.
about 1 month ago
https://pgdog.dev/blog/why-yet-another-connection-pooler
Why PgDog Built Yet Another Postgres Connection Pooler — Reducing user tradeoffs and providing a seamless experience, largely. For example, unlike PgBouncer, it keeps SET and LISTEN/NOTIFY working in transaction mode.
about 1 month ago
https://www.credativ.de/en/blog/postgresql-en/replication-deadlock-bug-in-current-postgres-releases-14-16/
🚨 A Replication Deadlock Bug in Current Postgres 14-16 Releases — A report that v14.23, v15.18, and v16.14 introduced a regression that can lead to a MultiXactOffsetSLRU deadlock during transaction log replay in some circumstances.
about 1 month ago
https://www.depesz.com/2026/07/06/waiting-for-postgresql-20-add-backend-level-lock-statistics/
Waiting for Postgres 20: Add Backend-Level Lock Statistics — Postgres 19 isn't here yet, but Hubert's looking forward to v20 and its forthcoming per-backend lock statistics, which will show which connections are stuck waiting on locks, and for how long.
about 1 month ago
https://github.com/prest/prest
pREST 2.0: Serve a RESTful API From a Postgres Database — Turn a Postgres database into a RESTful API. Covers similar ground to PostgREST but built in Go rather than Haskell. v2.0 adds support for multiple databases.
about 1 month ago
https://github.com/commandprompt/plruby
PL/Ruby 2.5: Ruby as a Procedural Language for Postgres — Lets you write functions, triggers, event triggers, and procedures for Postgres in Ruby.
about 1 month ago
https://thombrown.blogspot.com/2026/07/load-plcbmbasic81-commodore-64-basic.html
PL/CBMBASIC: Commodore 64 BASIC for Postgres — I like to slip a fun item in every now and then, and it doesn't get more fun than writing Postgres functions in a 44-year-old programming language.. does it? 😅
about 1 month ago
https://github.com/tinbase/tinbase
Tinbase: A Supabase-Compatible Backend in a Single Binary — An experiment that provides a local Supabase-like dev experience without Docker using a pure-JS backend built on PGlite and pg-mem. A sort of mini, local-only Postgres wrapped in the same APIs as Supabase proper, so supabase-js works unchanged.
about 1 month ago
https://pglayers.github.io/
pglayers: Postgres Extensions as Docker Layers — The official Postgres Docker images ship with few extensions and adding more can become tricky. pglayers tries to make this easier by layering extensions atop the official image.
about 1 month ago