Less Code, Faster Apps- Rediscovering SQL for Modern ORM Developers
summary
A weekend app that logs every score, jump and lap shows how SQL replaces app-side work: one query with ROLLUP returns player×quarter totals plus quarter totals plus a grand total instead of three separate trips to the database; a partition data join forces four quarters per player; hypothetical analytics ranks a 13‑ppg newcomer as fourth; the KEEP clause returns the wind reading for the max 716 jump; CTEs and a recursive CTE handle median filtering and the rolling “dirt” fuel calculation, cutting code and improving performance.
AI-written summary · about
chapters (9)
- 0:00Introduction to SQL vs ORM
- 2:05Basketball data aggregation
- 5:56Handling sparse data with outer joins
- 9:28Long jump analytics
- 14:24Common Table Expressions explained
- 16:49Swimming lap analysis
- 19:18Shopping bag weight distribution
- 21:27Fuel impurity recursive calculation
- 24:18Conclusion and call to action
related talks
31mFuturistic SQL: Making the impossible possible
46mAwesome SQL – tips and tricks for application developers
41mModern SQL: Evolution of a dinosaur
40mLevel-up Your ActiveRecord Skills: Learn SQL!
31m"Optimizing SQL Queries"
21mA Hands-on Experience with Complex SQL
41mUsing Databases to Pull Your Application Weight
39mMore Than a Query Language: SQL in the 21st Century