Topic
Everything filed under Databases, newest first.
RSS · JSON · All topics
Drew DeVault announces that Redict, the copyleft Redis fork, is officially deprecated with 7.3.6 as its final release, citing Valkey's success and Redis's return to a copyleft license, and recommends users switch to Valkey with simple migration steps.
1 min · 189 words
How Antfly learned to stop worrying and love Apache 2.0
Antfly CEO James McDermott explains why the retrieval database moved from the Elastic License 2.0 to Apache 2.0, why the team originally hedged with a source-available license, and why that hedge stopped making sense, alongside the Antfly 0.3 release.
2 min · 517 words
Quality IMAP, Part 1: Your Mailbox Is A Database
The first post in Aerogramme's series on implementing IMAP correctly, explaining why fine-grained email retrieval and querying make a mailbox behave like a database and how the server handles it.
15 min · 3,563 words
Please Implement A Quorum Database
Transcript of an HPTS 2026 talk arguing that leaderless, quorum-based replication is practical for production databases today and deserves more use than Raft-style leader replication, walking through the design space, prior systems, and the techniques that make quorums work.
16 min · 3,776 words
PostgreSQL 18.7, 17.12, 16.16, 15.20, 14.25, and 19 RC 2 Released!
The PostgreSQL Global Development Group released updates to all supported versions plus PostgreSQL 19 RC 2, fixing 52 security vulnerabilities and over 140 bugs; it is also the final release of PostgreSQL 14, which is now end-of-life.
11 min · 2,516 words
Rows vs Columns: How different are they, really?
Connor Tsui of Spiral explains how storing structured data in columns rather than rows changes how a database system works, covering row versus column stores, vectorized execution and lightweight compression, using a bike-share rides dataset as a running example.
22 min · 5,116 words
EventSourcingDB 1.3.0 is Available
EventSourcingDB 1.3.0 makes writes and EventQL queries considerably faster, speeds up reads, bounds every request in time, ships more than sixty fixes, and adds a new API that reports each request's outcome with named error codes.
6 min · 1,350 words
How I Ended Up Turning a 22-Year-Old PostgreSQL Type-Confusion Primitive into RCE (CVE-2026-6460)Part 3/6 of Systemic Risks in the Managed PostgreSQL Industry
Security researcher Mehmet Ince recounts how a question about managed PostgreSQL led him to a 22-year-old type-confusion bug class in PostgreSQL core, and how he turned the primitive into remote code execution (CVE-2026-6460).
23 min · 5,301 words
Xata announces it is joining ClickHouse to bring instant copy-on-write branching, scale-to-zero and anonymized production data to ClickHouse Managed Postgres, aimed at AI agents and per-PR databases; existing Xata customers keep running as usual.
6 min · 1,392 words
json vs jsonb in PostgreSQL: size and speed, measured
json vs jsonb in PostgreSQL 17 and 18, measured on six document shapes: when jsonb is 23% smaller or 41% larger, read speed, GIN indexes, and what jsonb changes in your data.
14 min · 3,132 words
Next-Level Benchmarking Overfitting
Thomas Neumann follows up on the database benchmarking crisis, showing how AI-driven tuning can overfit a single benchmark so aggressively that results become useless and would fall off a cliff in a real production system.
3 min · 629 words
Introducing pg_pinecone: Open-Source Search for Your Postgres Data
pg_pinecone is an open source (Apache 2.0) Postgres extension for search on the data you already store, built on the search engine Pinecone runs at scale.
8 min · 1,897 words
Redis vs Valkey vs Dragonfly vs KiviDB
warefeats benchmarks Redis, Valkey, Dragonfly, and KiviDB 1.2.0 on a 64-core Graviton3, comparing throughput and RSS memory per key after a KiviDB storage rewrite.
9 min · 2,141 words
An Aggregate Is a Function, Not a Sum
Alexander Novikov explains why treating a streaming report aggregate as a function of its source documents, rather than a running sum of inserts, makes duplicates and late-arriving documents in a Kafka-to-ClickHouse pipeline stop needing manual corrections.
17 min · 3,851 words
Postgres 19 REPACK: Built-In Online Table Bloat Cleanup
Craig Kerstiens explains Postgres 19's new REPACK command and REPACK (CONCURRENTLY), which bring online table and index rebuilds into core, compares them with VACUUM FULL, CLUSTER and pg_repack, and shows how to use them to reclaim bloat without downtime.
9 min · 2,182 words
Why we're moving our warehouse off DuckDB
PostHog explains why, five months after rebuilding its data warehouse on DuckDB, it re-architected it again: single-node sizing in the cloud, DuckLake catalog limits at ~1 trillion rows, and the pain of scaling Postgres wire connections led it to rebuild on Trino with its own open table format, HogLake.
4 min · 962 words
FastBCP 1.6: Export Tables from SQL Server Backups
ARPEIO's FastBCP 1.6 exports a table straight from a SQL Server full backup (.bak) to Parquet with no restore or SQL Server instance, with benchmarks on a 320 GB backup and notes on loading results via FastTransfer.
12 min · 2,669 words
Kyle Kingsbury's Jepsen analysis of ParticleDB, a multi-model database for AI workloads, reports 96 issues across versions 1.1.4 to 1.1.18.11.rc-22, from crashes and data loss to Lost Update under serializable, and finds its "Full ACID" claims premature. The work was funded by Orkes.
75 min · 17,232 words
Postgres 19 is late, and it's AI's fault
PostgreSQL committer Robert Haas explains why PostgreSQL 19 will likely slip to November or later: LLM-driven code review and bug hunting surfaced an unusual volume of defects in new features, forcing reverts and fixes, and he argues every developer will now need to raise their game.
4 min · 897 words
Coding Agents, Starter Kits and pgledger
Paul Gross explains why pgledger, his double-entry ledger in pure PostgreSQL, is a starter kit of tables and SQL functions rather than a library, and how coding agents make it easy to adapt such hardened components into any stack, making thoroughly tested building blocks more important than ever.
4 min · 979 words