Interview of Lætitia Avrot
summary
Solves Advent of Code puzzles using pure SQL, claiming it’s feasible and educational while noting some queries run for three days before returning results. Uses advanced techniques like recursive CTEs and the FILTER clause on aggregates, and even implements a Tetris simulation in SQL. Reports completing more than half the 2022 stars, hits practical limits from performance and complexity, and frames the effort as a fun way to deepen SQL skills.
AI-written summary · about
related talks
47mLearning advanced SQL the weird (and hard) way
27mBuilding Tetris in a SQL Query!
13mWriting an Interpreter in SQL for Fun and No Profit!
31mFuturistic SQL: Making the impossible possible
26mLess Code, Faster Apps- Rediscovering SQL for Modern ORM Developers
21mA Hands-on Experience with Complex SQL
39mMore Than a Query Language: SQL in the 21st Century
46mAwesome SQL – tips and tricks for application developers