Great migration to SQLDelight

on YouTube ↗16m

" summary

Shows a concrete path to replace existing Android databases with SQLDelight: Kotlin Multiplatform common module, SQLDelight Gradle plugin, .sq schema files, Android driver, then repository rewrites—presented as a five-step migration with commit-hashed examples. Demonstrates migrations from SQLite, Room, Realm using an Emoji Books app; SQLite/Room migrate cleanly with generated type-safe Kotlin APIs and compile-time checks, while Realm requires programmatic export (demo wipes data). Includes a sample app on GitHub with in-memory and per-database commits to follow.

AI-written summary · about

" chapters (13)

1. 0:00Introduction to talk
2. 1:18Kotlin multiplatform overview
3. 2:20SQLDelight features explained
4. 4:04Sample app Emoji Books
5. 5:30Migrating from SQLite
6. 7:18SQLDelight migration steps
7. 9:47Generated APIs in use
8. 10:08Migrating from Room
9. 11:30Migrating from Realm
10. 12:55Migration summary
11. 13:36Reusing code on iOS
12. 13:58Useful resources
13. 15:21Closing and Q&A

" related talks

• 47mA Multiplatform DelightJake Wharton, Alec Strong · KotlinConf 2018
• 39mSELECT * FROM KotlinSam Edwards · droidcon NYC 2019
• 35mMultiplatform PersistenceAlec Strong · droidCon NYC 2018
• 34mDon’t fear SQL: A better way to store and handle data with SQLBrite & SQLDelightLeandro Favarin · 360|AnDev 2017
• 42mThe Resurgence of SQLJake Wharton, Alec Strong · droidcon NYC 2017
• 48mDevOps Discovery: Navigating the Database LandscapeHuxley Kendell, David Ong · SQLBits 2022
• 42mSEQUEL SQL for Android DevelopersKai Koenig · droidcon Berlin 2024
• 48mDevOps Discovery: Navigating the Database LandscapeHuxley Kendell, David Ong · SQLBits 2024