Embracing SQL Without Abstraction
summary
Square builds two tools: SQL Brite is a reactive wrapper that emits query results as Observables but currently uses table-name-based notifications so it can produce false positives. SQL Delight parses CREATE TABLE and SELECT statements to generate Java mappers per query, remove string constants, verify column names at compile time, provide IDE autocomplete and refactoring, and eliminate much of the mapping boilerplate. Next steps include generated bind-arg methods, migration verification, test previews and Kotlin data class support.
AI-written summary · about
chapters (5)
- 0:00Introduction to SQL journey
- 6:50Problems with existing libraries
- 13:30Flaws in Scaffold library
- 21:33Evolution to SQL Delight
- 33:11Future of SQL tools
related talks
34mDon’t fear SQL: A better way to store and handle data with SQLBrite & SQLDelight
42mSEQUEL SQL for Android Developers
35mMultiplatform Persistence
02h 42mSQL (The Return): Demystifying Preconceptions and Using the DB Effectively
32mBecause SQL is everywhere but you don't want to use it
19mSQLite - The most overlooked database
42mThe Resurgence of SQL
47mA Multiplatform Delight