Get a Room or have a Delight
summary
Compares Google Room and Square SQLDelight by implementing a GitHub repo JSON mapping and measuring setup, tooling and runtime tradeoffs. Room uses @Entity/@Embedded, DAO annotations, generated RoomDatabase, supports in‑memory tests and takes about 15 minutes to wire up; it lacks views/indexes/triggers and starts to slow or force Java workarounds once queries span many tables or >1,000 rows. SQLDelight uses .sq files, generates models, requires a factory/mapper and needs SQLBrite for Rx support, gives full SQL features and superior refactoring but has more bootstrapping and limited Kotlin/autovalue support.
AI-written summary · about
chapters (6)
- 0:00Introduction and motivation
- 3:54Room implementation basics
- 13:54SQLDelight implementation steps
- 21:32Comparing Room and SQLDelight
- 28:20Choosing the right tool
- 35:52Q&A session
