301
B-Trees and Database Indexes
B-trees are used by many modern DBMSs. Learn how they work, how databases use them, and how your choice of primary key can affect index performance.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 2,337 posts.
302
How SQLite Helps You Do ACID
Let's take a peek at how the rollback journal works.
303
Function pipelines: Building functional programming into PostgreSQL
Function pipelines allow you to analyze data by composing multiple functions in SQL and express complex logic in PostgreSQL in a cleaner way.
304
Scaling PostgreSQL to power 800M ChatGPT users
An inside look at how OpenAI scaled PostgreSQL to millions of queries per second using replicas, caching, rate limiting, and workload isolation.
305
306
307
The Great Migration from MongoDB to PostgreSQL
How Infisical migrated from MongoDB to PostgreSQL.
308
We replaced Redis with MySQL for inventory reservations and it scaled
How we used SKIP LOCKED, composite primary keys, and connection visibility to hit our scale targets.
309
Grok 4.6 scores 61 on the Artificial Analysis Intelligence Index
SpaceXAI returns to the intelligence frontier with strengths in agentic performance and cost efficiency
310
How does database sharding work?
Learn what database sharding is, how sharding works, and some common sharding frameworks and tools.
311
312
Amazon Aurora Now Available
We announced Amazon Aurora last year at AWS re:Invent (see Amazon Aurora – New Cost-Effective MySQL-Compatible Database Engine for Amazon for more info). With storage replicated both within and across three Availability Zones, along with an update model driven by quorum writes, Amazon Aurora is designed to deliver…
313
314
Internet Archive Scholar: Search Millions of Research Papers
Looking for a research paper but can’t find a copy in your library’s catalog or popular search engines? Give Internet Archive Scholar a try! We might have a PDF from a “vanished” Open Access publisher in our web archive, an author’s pre-publication manuscript from their archived faculty webpage, or a digitized…
315
Andy Pavlo joins ClickHouse to establish ClickHouse Labs
I am excited to announce that I am joining ClickHouse, Inc. to establish and lead a new research team at ClickHouse Labs.
316
Gemini 4 Carbon is the new #1 on the Artificial Analysis Intelligence Index v5
Google’s Gemini 4 Carbon is the new #1 on the Artificial Analysis Intelligence Index v5, and second only to Claude Opus 5.5 on the Artificial Analysis Coding Agent Index
317
318
Average color of each country (using satellite imagery)
*Couple of weeks ago we have noticed the article getting attention around twitter. As it is using our WMS EOxMaps endpoint we have asked Erin Davis if we could host her idea here. At EOX we endorse brilliant and unique ideas that utilize our tools and data. Thank you for this most interesting contri ...
319
Codeq
The free database designed for immutable values and a time-aware information model.
320
Download responsibly
This month we’ve ramped up the infrastructure behind the download server, and downloads should now be available earlier and faster. There’s also a small technical change in that requests for a “…latest” file will now be answered with a HTTP redirect to the specific latest version (see previous blog post).
321
322
The data model behind Notion's flexibility
Notion’s data model enables the product’s most foundational component: blocks. Through blocks, we allow users more flexibility over their information.
323
Postgres Full Text Search vs. the Rest
Comparing one of the most popular Postgres features against alternatives
324
How Discord Indexes Billions of Messages Using Elasticsearch
Discover the latest news and app updates, stories, company insights, and plenty more about Discord, all in one place.
325
Backblaze Hard Drive Stats for 2020
The AFR for 2020 dropped below 1% down to 0.93%. In 2019, it stood at 1.89%. That’s over a 50% drop year over year.
326
327
328
30% of Google's Emotions Dataset Is Mislabeled
Last year, Google released their “GoEmotions” dataset: a human-labeled dataset of 58K Reddit comments categorized according to 27 emotions. The problem? A whopping 30% of the dataset is mislabeled! Check out some of the egregious errors, and learn how to build better datasets.30% of Google's Emotions Dataset is…
329
Making SQL Server run on Linux
This post was authored by Scott Konersmann, Partner Engineering Manager, SQL Server, Slava Oks, Partner Group Engineering Manager, SQL Server, and Tobias Ternstrom, Principal Program Manager, SQL Server. Introduction We first announced SQL Server on Linux in March, and recently released the first public preview of SQL…
330