61
Looking Ahead to Postgres 19
Discover the top PostgreSQL 19 features, including built-in REPACK CONCURRENTLY, SQL property graph queries (SQL/PGQ), and logical replication updates.
New
The latest blog posts to take off on Hacker News. 2,337 posts.
62
Hunting a 16-year-old SQLite WAL bug with TLA+
This article was written by Marco Manino and Alberto Carretero, dqlite team at Canonical. 1. Anatomy of a SQLite bug Recently SQLite published a new version with a fix to a long-standing bug in the way that the Write Ahead Log (WAL) is checkpointed that leads to the corruption of the database. The important aspect […]
63
Asymmetric Quantization: Near-Lossless Retrieval with 97% Storage Reduction
Late interaction makes retrieval more precise but turns every document into many vectors. Asymmetric quantization keeps query vectors precise and stores…
64
WAL-RUS: a Rust Rewrite of WAL-G for PostgreSQL Backups
How we built WAL-RUS, an open-source Rust-based Postgres backup tool that reduces virtual memory usage by over 70% compared to WAL-G while maintaining full compatibility.
65
I rewrote PostHog's SQL parser, 70x faster, while barely looking at the code
After the success of using agents to improve query performance through autoresearch , I wanted to try something more ambitious. I rewrote PostHog's…
66
British Columbia, Time Zones, and Postgres
This year, British Column has moved to year-round Pacific Time. How does that affect date data?
67
Statistics that live in your SQL
A tour of the-stats-duck v0.6.0: a one-shot data profiler, regression and bootstrap CIs in plain SQL, ten new distributions, and SAS/XPT imports that got 52x faster — with live Bedevere demos you can poke at.
68
PostgresBench: A Reproducible Benchmark for Postgres Services
Discover how Postgres managed by ClickHouse compares to its peers in a reproducible, open benchmark.
69
Ubiquiti: Enterprise NAS, Built on ZFS
Discover ENAS, the license-free enterprise storage platform featuring native ZFS, secure UniFi management, scalable petabyte-class capacity, multi-site backups, and shared iSCSI storage for modern business infrastructure.
70
We built a persistent agent memory layer on Elasticsearch with 0.89 recall
Persistent agent memory on Elasticsearch: three-index architecture, hybrid retrieval, supersession and DLS isolation. R@10 0.89, zero cross-tenant leaks.
71
GLM-5.2 is the new leading open weights model on Artificial Analysis
Benchmarks and Analysis of GLM-5.2
72
DuckDB Internals Part 1
Walk through DuckDB's internals: how it skips serialization overhead, parses and optimizes SQL, and stores data in columnar row groups with zone maps.
73
Ten years of ClickHouse in open source
ClickHouse was released in open source on Jun 15 2016, ten years ago. Since then, it became the most popular open source analytical database with more than 2000 contributors.
74
Looking Forward to Postgres 19: It's About Time
Postgres 19 brings native temporal table support. Shaun Thomas covers WITHOUT OVERLAPS, FOR PORTION OF, and temporal foreign keys - and what's still missing.
75
The only scalable delete in Postgres is DROP TABLE
Large DELETEs add work instead of reclaiming it. Structure your database so deletion becomes DROP TABLE or TRUNCATE.
76
Looking Forward to Postgres 19: Query Hints
Postgres 19 brings plan advice: the query hints the Postgres community held off on for 15 years. Shaun Thomas covers the 15-year debate, pg_plan_advice, pg_stash_advice, and how to use them.
77
Redis 8.8: New array data structure, rate limiter, performance improvements
Redis 8.8 is now available in Open Source. Explore the new array data type, window counter rate limiter, streams NACK, and more performance-focused updates.
78
databow: a Rust CLI to query any database with an ADBC driver
One command-line tool to query them all, built with Rust and ADBC
79
How we index images for RAG
Reading the screenshots, diagrams and tables in technical documentation for LLMs
80
SQLite is all you need for durable workflows
DBOS recently argued that Postgres is all you need for durable execution: if you already trust your database, you do not need a separate orchestration tier. I a…
81
Building durable workflows on Postgres
Explaining the concept of a Postgres-backed durable execution system like DBOS and comparing it to external workflow orchestration systems like Temporal.
82
83
Quack: The DuckDB Client-Server Protocol
DuckDB instances can now talk to each other using the Quack remote protocol. This lets you run DuckDB in a client-server setup with multiple concurrent writers. In DuckDB's spirit, Quack is simple to set up and builds on proven technologies such as HTTP. It's also fast, which allows it to support workloads ranging…
84
Gemini API File Search is now multimodal
Updates to the Gemini API File Search tool makes building efficient, multimodal file retrieval systems easier for developers.
85
Lakebase architecture delivers faster Postgres writes
How Lakebase's storage architecture pushes down full page write generation to cut WAL traffic by 94% and boost Postgres write throughput by up to 5x.
86
SQLite Is a Library of Congress Recommended Storage Format
SQLite is a Recommended Storage Format for datasets according to the US Library of Congress . Further information:
87
88
Does Postgres Scale?
Benchmarking the workflow execution and workflow queueing scalability of a single Postgres server.
89
DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser
We are releasing DuckDB version 1.5.2, a patch release with bugfixes, performance improvements, and support for the DuckLake 1.0 lakehouse format.
90
A type-safe, realtime collaborative Graph Database in a CRDT
Open-source TypeScript property graph database from codemix.