Rad - Redesigned Relational DatabaseRad reimagines how relational databases integrate with application code. It eliminates the friction between schema definitions...
PostgreSQL Partition Pruning for Non-Partition Key QueriesThis article addresses a common PostgreSQL optimization challenge: partition pruning normally only works when filtering by the...
VLDB Volume 16: Pedreira Research PaperResearch paper from the VLDB Endowment proceedings. VLDB (Very Large Data Bases) publishes peer-reviewed research in data management and systems.
Things I want in a modern relational query languageTechnical 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.
PostgreSQL for EverythingComprehensive technical article examining how PostgreSQL can replace specialized systems like Kafka, Redis, Elasticsearch, and ClickHouse for most production use cases, emphasizing simplicity and operational efficiency.