121
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
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 134 posts.
122
123
Scaling NumPy on Free-Threaded Python
A recap on the work done in NumPy and CPython to make multi-threaded NumPy workloads scale on the free-threaded build of CPython.
124
125
PostgresBench: A Reproducible Benchmark for Postgres Services
Discover how Postgres managed by ClickHouse compares to its peers in a reproducible, open benchmark.
126
Zero downtime migrations at petabyte scale (2024)
Data migrations are a critical part of the database lifecycle, and are sometimes necessary for version upgrades, sharding, or moving to a new platform. In many cases, migrations are painful and error-prone. In this article, we walk through how migrations are performed at PlanetScale, and offer advice on how to improve…
127
Message Queues: A Simple Guide with Analogies (2024)
This guide explains message queues with analogies: databases, warehouses and post offices.
128
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…
129
ANN v3: 200ms p99 query latency over 100B vectors
Our latest ANN release supports scales of 100+ billion vectors in a single search index, with 200ms p99 query latency at 1k QPS and 92% recall.
130
We're Building Postgres in Rust. Using the LLVM of Databases
Turso is becoming the LLVM of databases: one modern, reliable Rust core with many SQL frontends. After rewriting SQLite, we are now building Postgres.
131
Postgres SELECT DISTINCT Does Not Scale
Postgres SELECT DISTINCT performs surprisingly poorly. We explain why and how we mitigated it.
132
Algorithmic rent-pricing litigation expands under new state and local laws
A new wave of litigation focused on violations of municipal regulations is emerging against multifamily housing landlords, many of whom are facing antitrust litigation targeting their use of certain revenue management products. The new regulations may potentially provide a simpler path to liability and the possibility…
133
118M Queries per Second on Neki
We ran a massive, sharded Postgres database at 118.5 million queries per second, with 200k queries per second on each shard across 512 shards.
134
How Swiss tables work in Go built-in map
Go 1.24 replaced the built-in map’s bucket-based runtime with Swiss Tables. This article explains groups, control bytes, H1 and H2, probing, table growth, directories, deletion, load factor, and the experimental split-group layout.