Public list by ~postgresweekly

Issue 661 - A gofmt-style formatter for SQL

Introducing sqlfmt: an SQL gofmt-style formatter

https://tapoueh.org/blog/2026/08/introducing-sqlfmt-an-sql-gofmt-style-formatter/

Introducing sqlfmt: An SQL gofmt-Style Formatter — Postgres contributor Dimitri has developed his own way to style SQL over time (as used in his book, The Art of PostgreSQL) and built a Go tool to apply it automatically. Better still, you can use it on the Web, so if you're prepping a presentation or blog post, give it a try on your queries.

8 days ago

ParadeDB Cloud — Join the waitlist

https://paradedb.com/cloud

Coming Soon: ParadeDB Cloud — We're building a fully managed ParadeDB: one Postgres for your application data, full-text search, vector retrieval, and aggregations. Our early access waitlist is open now.

#postgres #search #analytics #etl #elasticsearch #olap

8 days ago

The dangers of Postgres subtransactions — PlanetScale

https://planetscale.com/blog/the-dangers-of-postgres-subtransactions

The Dangers of Postgres Subtransactions — A transaction with more than 64 subtransactions can bring a cluster to a crawl. A pgbench run shows throughput falling from 7,200 TPS to 160 TPS, and it gets worse: a new read replica can refuse connections entirely.

8 days ago

Introducing pg-java, a new PostgreSQL driver for the JVM

https://launchbylunch.com/posts/2026/Jul/29/introducing-pg-java/

Introducing pg-java: A New Postgres Driver for the JVM — A long-time pgjdbc maintainer explains why he created a from-scratch, Postgres-first JVM driver built on virtual threads: pg-java. It's still considered pre-release though.

8 days ago