Topics /

Databases & Data

The most popular blog posts about databases & data on Hacker News. 2,337 posts.

Any year
159

My Favorite PostgreSQL Queries and Why They Matter

In today's data-driven world, data is valuable. Extracting insight, answering questions, and meaningful metrics from data by way of querying and data manipulation is an integral component of SQL in general. This blog presents a combination of 8 interesting, differing PostgreSQL queries or types of queries to explore…

175

Jepsen: NATS 2.12.1

NATS is a popular streaming system. Producers publish messages to streams , and consumers subscribe to those streams, fetching messages from them. Regular NATS streams are allowed to drop messages. However, NATS has a subsystem called JetStream , which uses the Raft consensus algorithm to replicate data among nodes…

180

Postgres 15 improves UNIQUE and NULL

Postgres 15 beta 2 was released recently! I enjoy Beta season... reviewing and testing new features is a fun diversion from daily tasks. This post takes a look at an improvement to UNIQUE constraints on columns with NULL values . While the nuances of unique constraints are not as flashy as making sorts faster (that's…