Advanced SQL: A Look at Window Frames — A deep dive into advanced uses of window functions (an earlier article covers those if you need it). Window frames are an SQL feature (in which Postgres is leading in support) that take window functions to a deeper level to perform complex and selective aggregations. Some great examples in here and a must-read.
Hacker News Discusses.. PostgreSQL or MySQL? — There’s little more that can provoke a discussion on Hacker News than asking readers to choose between two technologies. Perhaps unsurprisingly, Postgres seems to be strongly preferred.
Building a Relational Database Using Kafka? — Kafka is best known for its stream processing and data pipeline management capabilities, but if it’s possible to build a key/value store with it, you can go a step further and create a relational database too. An interesting experiment!