Topics /

Databases & Data

The most popular blog posts about databases & data on Hacker News. 239 posts.

2026
8

A Preview of DuckDB v2.0

DuckDB 2.0 is coming this fall. In this post, we preview its headline features: DuckDB as a server, triggers, the VARIANT type, asynchronous I/O, a new SQL parser, a new storage format, and much more.

9

New accounts on HN more likely to use em-dashes

I’ve had this sense that HN has gotten absolutely innundated with bots last few months. First most obvious giveaway is the frequency with which you see accounts posting brilliant insights like 13 60 well and t6ctctfuvuh7hguhuig8h88gd to f6gug7h8j8h6fzbuvubt GB I be cugttc fav uhz cb ibub8vgxgvzdrc to bubuvtxfh tf d…

12

A graph that should be front-page news

Every so often the Earth produces a signal that is impossible to ignore. This graph is one of them. It shows sea-surface temperatures in the Niño 3.4 region of the equatorial Pacific, one of the most important parts of the Earth's climate system. Each blue line represents a different year since 1982. The red line is…

15

Executable Is a SQLite Database

I have been probably obsessed with two things in the last few years: Nix as a tool to explore innovative ideas that require the capability to rebuild the world and replacing ELF with SQLite as an executable format. You might have noticed that these two ideas are well suited to each other.

23

Cosmologically Unique IDs

We are an exploratory species, just past the solar system now, but perhaps one day we will look back and call our galaxy merely the first. There are many problems to solve along the way, and today we will look at one very small one. How do we assign IDs to devices (or any object) so the IDs are guaranteed to always be…

24

DuckDB 2.0.0 LTS “Cinnamon Teal”

The DuckDB team is happy to announce that today we're releasing DuckDB version 2.0.0 LTS, codenamed “Cinnamon Teal” (Spatula cyanoptera). This is our biggest feature release so far, and it ships a polished version of the Quack protocol, asynchronous I/O, a first-class VARIANT type, agent mode, triggers, an extensible…