SQL (The Return): Demystifying Preconceptions and Using the DB Effectively
summary
This talk argues that SQL remains modern: NoSQL systems adopt SQL features and new distributed SQL engines (Google Spanner, Yugabyte, and derivatives like CockroachDB, Postgres forks, Oracle, MySQL/MariaDB) provide horizontal scalability with ACID. It gives practical advice for efficient, correct DB use: declare foreign keys and constraints, use prepared statements to avoid recompilation and injection, avoid SELECT * in favor of index-only access or materialized views, prefer idempotent inserts (unique transaction IDs) over blind updates, consider serializable isolation and retry handling, and debug complex queries with WITH clauses and execution plans.
AI-written summary · about
chapters (10)
- 0:00Introduction
- 1:03SQL and relational basics
- 21:52Normalization vs denormalization
- 45:03Primary and foreign keys
- 1:03:20SQL language and queries
- 1:33:23ACID transactions
- 2:00:29Replication and high availability
- 2:15:39Query optimization
- 2:31:40Debugging SQL queries
- 2:40:41Q&A
related talks
26mNewSQL: concepts, realities and when you should embrace it
57mHow modern SQL databases arrive at algorithms you never dreamed of
41mModern SQL: Evolution of a dinosaur
43mSQL vs Prejudice
01h 00mModern SQL: Evolution of a Dinosaur
47mModern SQL: Evolution of a Dinosaur
31mSQL to NoSQL to NewSQL and the rise of polyglot persistence Paul Dix
44mNonrelational SQL