This article addresses a common PostgreSQL optimization challenge: partition pruning normally only works when filtering by the...

Technical essay exploring how functional programming concepts and modern language design could improve relational database query languages, featuring practical examples of pattern matching, sum types, and discriminated unions for SQL.

An educational puzzle game that teaches SQL querying through solving fictional crimes. A creative approach to learning database fundamentals through gameplay.

ClickHouse is an open-source analytical database that reached its 10-year milestone in June 2026. The project has grown to...