The Resurgence of SQL
summary
SQL moves heavy filtering from Kotlin into the database, demonstrated with a Swarm-style check‑in example where doing filters in Kotlin takes ~30 seconds on 50,000 rows but the SQL version runs in milliseconds — about 100x faster. Practical tools: use explain query plan and add indexes (creates searches instead of scans), export DB with Stetho, and choose between Room (easier onboarding, DAOs, paging) and SQL Delight (pure SQL, stronger compile‑time checks, Kotlin improvements underway).
AI-written summary · about
chapters (9)
- 0:00Introduction to SQL
- 1:29Non-SQL persistence options
- 10:58SQLite fundamentals
- 13:26SQL vs Kotlin filtering
- 18:40Query optimization with indexes
- 25:37Challenges of raw SQLite
- 32:03Room vs SQLDelight
- 39:02Future of SQL on Android
- 41:26Q&A and summary
related talks
39mSELECT * FROM Kotlin
42mSEQUEL SQL for Android Developers
44mNonrelational SQL
02h 42mSQL (The Return): Demystifying Preconceptions and Using the DB Effectively
34mDon’t fear SQL: A better way to store and handle data with SQLBrite & SQLDelight
32mBecause SQL is everywhere but you don't want to use it
32mUnlearning SQL
39mMore Than a Query Language: SQL in the 21st Century