Surviving Legacy Code: Renegotiating Old Contracts
Refactoring old code often requires careful attention to the contracts previously put in place
by
Jordi·
Why Spark joins are expensive - and what to do about it
Spark joins are often considered expensive - leading users to prefer highly denormalised data models on Spark. Let us fact check this!
by
Database Doctor·
Lakehouse statistics and why query engines get lost
Statistical metadata is to SQL Engines as maps are to delivery drivers. Without maps, drivers get lost; without statistics, SQL Engines also get lost.
by
Neil·
Predicate pushdown, a planner perspective
A deep dive into pushdown logic in query planners
by
Maxence·
Why bother with Data Modelling - Part 4: Composite Keys
Composite keys are sometimes necessary - but they have downsides. Digging into the tradeoffs for using composite keys.
by
Database Doctor·
How Variant will Replace JSONB in Lakehouses
A deep dive into the variant data type in lakehouses
by
Jin·