Don’t fear SQL: A better way to store and handle data with SQLBrite & SQLDelight
summary
Square’s SQLDelight generates type-safe generated models and Java row mappers from .sq files, gives compile-time SQL validation, autocompletion, precompiled statements and column adapters for enums and Date/Time; migrations remain manual. SQLBrite provides reactive table notifications over SQLite (and ContentResolver) with RxJava observables, transactions to batch emissions, and lightweight logging. Combined they produce precompiled statements, automated marshaling between cursor and model, about 160+ methods of runtime code added, and noticeably fewer runtime crashes and boilerplate.
AI-written summary · about
chapters (16)
- 0:00Start
- 0:18Outline
- 1:26SQLite in Android - pros
- 3:46SQLite in Android - example
- 5:15What is ORM?
- 12:21SQLDelight - ... generates
- 16:50SQLDelight - types
- 17:44SQLDelight - custom classes
- 20:08SQLDelight - migrations
- 22:33SQLBrite - usage
- 24:22SQLBrite - content resolvers
- 24:57SQLBrite - powerful logging
- 26:28SQLBrite - transactions
- 29:53Traditional Android APIs
- 31:28Room
- 32:02Review
