Topics /

Databases & Data

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

Any year
2075

Fun with SQL: Window Functions in Postgres

Window functions in PostgreSQL are valuable when you want to compare & contrast data between rows. And window functions are key in analytics use cases. This post covers the basic structure of window functions as well as some of the more interesting things you can do with them.

2081

PostgreSQL is eating the database world

PostgreSQL isn’t just a simple relational database; it’s a data management framework with the potential to engulf the entire database realm. The trend of “Using Postgres for Everything” is no longer limited to a few elite teams but is becoming a mainstream best practice.

2092

Roshi: a CRDT system for timestamped events

Let’s talk about the stream. The SoundCloud stream represents stuff that’s relevant to you primarily via your social graph, arranged in time order, newest-first. The atom of that data model, an event, is a simple enough thing. Timestamp User who did the thing Identifier of the thing that was done For example, At…

2097

OpenTelemetry protocol with Apache Arrow

We are excited to announce the next phase of the OpenTelemetry Protocol with Apache Arrow project (OTel-Arrow). We began this project several years ago with the goal of bridging between OpenTelemetry data and the Apache Arrow ecosystem. Apache Arrow is a framework designed for zero-copy exchange of structured data…