301
Build your own database
A step-by-step guide to building a key-value database from scratch.
New
The latest blog posts to take off on Hacker News. 4,224 posts.
302
Production RAG: what I learned from processing 5M+ documents
Lessons learned from building RAG systems for Usul AI and enterprise clients, processing over 13 million pages.
303
304
305
Is Postgres read heavy or write heavy?
A query to find out if Postgres is read heavy or write heavy and tips for optimizing Postgres for both read and write workloads.
306
Are hard drives getting better?
After 13 years, the data is clear—the bathtub curve does not apply to hard drives. And, more importantly, hard drives are failing less and lasting longer.
307
Exploring PostgreSQL 18's new UUIDv7 support
Exploring what's interesting about UUIDv7 support using a demo crab store.
308
Your data model is your destiny
Your product's core abstractions determine whether new features compound into a moat or just add to a feature list. Here's how to get it right.
309
Benchmarking Postgres 17 vs. 18
Postgres 18 brings a significant improvement to read performance via async I/O and I/O worker threads. Here we compare its performance to Postgres 17.
310
American solar farms
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
311
Pipelining in psql (PostgreSQL 18)
the psql client version 18 comes with pipelining, which can speed up client-server communication. In this post, let's see how it works and how much can be g...
312
Scaling request logging with ClickHouse, Kafka, and Vector
How we solved request logging at scale by moving from MariaDB to ClickHouse, Kafka, and Vector after our deprecated database engine couldn't keep up with billions of monthly requests.
313
The World's 2.75B Buildings
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
314
What GPT-OSS leaks about OpenAI's training data
OpenAI recently released their open-weights model. Here we'll discuss how that inevitably leaks some information about their model training stack, and, on the way, show that GPT-5 was trained on phrases from adult websites....
315
Personal data storage is an idea whose time has come
Data Ownership as a conversation changes when data resides primarily with people-governed institutions rather than corporations.
316
Which table format do LLMs understand best?
We benchmarked 11 data formats, including markdown tables, JSON, CSV, YAML, XML, and more, to see which LLMs understand best. We found surprising accuracy and token cost trade-offs.
317
Litestream v0.5.0
Same Litestream goodness but better, faster, stronger
318
The RAG Obituary: Killed by agents, buried by context windows
I’ve been working in AI and search for a decade. First, I built Doctrine, the largest European legal search engine, and now I am building Fintool , an AI-powered financial research platform that helps institutional investors analyze companies, screen stocks, and make investment decisions.
319
TigerBeetle is a most interesting database
This read goes behind the scenes of how TigerBeetle came to be, the incredibly novel software they’ve built, and all of the wacky, wonderful things that make them so special.
320
Subtleties of SQLite Indexes
Understanding query planner quirks yielded a ~35% speedup.
321
A SQL Heuristic: ORs Are Expensive
But this is slow! With 1,000,000 applications and 1000 users uniformly distributed on both columns, it takes over 100ms. 1
322
What’s New in PostgreSQL 18 – a Developer’s Perspective
PostgreSQL 18 features that change how application developers write and ship code.
323
Redis is fast – I'll cache in Postgres
There are books & many articles online, like this one arguing for using Postgres for everything. I thought I’d take a look at one use case - using Postgres instead of Redis for caching. I work with APIs quite a bit, so I’d build a super simple HTTP server that responds with data from that cache. I’d start from Redis…
324
Windows ML is generally available
The future of AI is hybrid, utilizing the respective strengths of cloud and client while harnessing every Windows device to achieve more. At Microsoft, we are reimagining what’s possible by bringing powerful AI compute directly to Windows devices,
325
PostgreSQL 18 Released
The [PostgreSQL Global Development Group](https://www.postgresql.org) today announced the release of [PostgreSQL 18](https://www.postgresql.org/docs/18/release-18.html), the latest version of the world's most advanced …
326
SedonaDB: A new geospatial DataFrame library written in Rust
Apache Sedona is a cluster computing system for processing large-scale spatial data. Sedona extends existing cluster computing systems, such as Apache Spark, Apache Flink, and Snowflake, with a set of out-of-the-box distributed Spatial Datasets and Spatial SQL that efficiently load, process, and analyze large-scale…
327
How AWS S3 serves 1 petabyte per second on top of slow HDDs
Learn how Amazon built the backbone of the modern web that scales to 1 PB/s and 150M QPS on commodity hard drives
328
329
Ultra efficient vector extension for SQLite
Making vector search fast, memory-efficient, and natural in SQLite.
330
