SQL vs Prejudice
summary
Compares common prejudices about SQL with how SQL actually works, discussing concrete misconceptions and demonstrating correct usage and best practices for relational databases. Covers SQL features, query behavior, and practical examples to dispel myths and improve developers’ confidence when designing and querying databases.
AI-written summary · about
chapters (13)
- 0:00Introduction
- 1:15SQL accused
- 2:40Case against SQL
- 6:5750 000 updates
- 8:44CTI and readability
- 11:33RETURNING clause
- 15:48Window functions performance
- 20:47Lateral joins and N+1
- 27:12SQL innocence defense
- 30:04SQL resistance reasons
- 33:34When to use SQL
- 35:20Conclusion
- 37:30Q&A
related talks
43mSQL vs Prejudice
02h 42mSQL (The Return): Demystifying Preconceptions and Using the DB Effectively
32mBecause SQL is everywhere but you don't want to use it
57mHow modern SQL databases arrive at algorithms you never dreamed of
46mMore Than a Query Language: SQL in the 21st Century
41mModern SQL: Evolution of a dinosaur
58mThe Mother of All Query Languages: SQL in the 21st Century
47mModern SQL: Evolution of a Dinosaur