A Preview of DuckDB v2.0(duckdb.org)
684 points by ibotty | 120 comments
DuckDB blog post previewing v2.0 features including server mode, triggers, VARIANT type, async I/O, a new SQL parser and storage format.
First screen, captured .
Looks similar
Show HN: We open sourced our entire text-to-SQL product(github.com)
437 points by aazo11 | 140 comments
GitHub repository for Dataherald, an open-sourced natural-language-to-SQL engine using LLM agents, with admin console, enterprise backend, and Slackbot services.
Related stories
Unconventional PostgreSQL Optimizations(hakibenita.com)
398 points by haki | 63 comments
Blog post by Haki Benita presenting unconventional, creative techniques for speeding up queries in PostgreSQL beyond standard indexing and query rewrites.
Postgres SELECT DISTINCT Does Not Scale(dbos.dev)
83 points by KraftyOne | 26 comments
A DBOS blog post by Peter Kraft explaining why Postgres SELECT DISTINCT queries perform poorly at scale.
Postgres isn't slow, your storage is(clickhouse.com)
146 points by saisrirampur | 148 comments
ClickHouse blog recap of a POSETTE 2026 talk arguing PostgreSQL performance at scale is limited by storage, with benchmarks and a local-NVMe production architecture.
Postgres LISTEN/NOTIFY does not scale(recall.ai)
547 points by davidgu | 283 comments
A Recall.ai engineering blog deep dive explaining why Postgres LISTEN/NOTIFY caused scaling problems in their production system.
SSDs have become fast, except in the cloud(databasearchitects.blogspot.com)
550 points by greghn | 370 comments
Database Architects blog post arguing that local SSD throughput has exploded with PCIe 5.0 while cloud instance storage performance has stagnated.
Making Postgres slower(byteofdev.com)
320 points by AsyncBanana | 35 comments
A ByteofDev blog post humorously exploring how to tune PostgreSQL configuration settings to make the database as slow as possible.