SQL vs Prejudice

on YouTube ↗43m

" summary

A PostgreSQL expert challenges common prejudices about SQL—claims that it is obsolete, overly complex, or unsuitable for modern data—and defends SQL by showing concrete code demonstrations, real-world use cases, and practical examples of advanced features. The talk focuses on pragmatic solutions using PostgreSQL to solve everyday data problems and aims to convince developers that SQL can be an elegant, effective tool rather than an outdated burden.

AI-written summary · about

" chapters (13)

1. 0:00Introduction
2. 2:50SQL accusations
3. 6:2050k useless updates
4. 8:26CTEs for natural reads
5. 11:39App ping-pong and RETURNING
6. 16:16Top 3 per category
7. 22:06Lateral joins benefits
8. 26:25SQL performance and elegance
9. 30:19SQL misunderstood
10. 33:31Declarative vs imperative
11. 36:22When to use SQL
12. 38:06SQL is innocent
13. 40:34Summary

" related talks

• 40mSQL vs PrejudiceLætitia Avrot · Forum PHP 2025
• 02h 42mSQL (The Return): Demystifying Preconceptions and Using the DB EffectivelyFranck Pachot · Devoxx France 2023
• 44mPostgreSQL for DevelopersDimitri Fontaine · PostgresOpen 2014
• 48mTricky SQL: Special Features of PostgreSQL's SQL DialectIvan Frolkov · HighLoad++ 2012
• 51mPostgreSQL: Practical Examples of SQL Query OptimizationIvan Frolkov · HighLoad++ 2016
• 44mSELECT 'amazing_features' FROM "posgresql"Kevin Davin · Devfest Strasbourg 2024
• 47mLearning advanced SQL the weird (and hard) wayLætitia Avrot · PostgreSQL Conference Europe 2023
• 41mModern SQL: Evolution of a dinosaurMarkus Winand · WebCamp Zagreb 2018