In this episode, we talk to Florina from Google about the recently released Database library Room. Room was introduced as part of the Android Architecture components and has been picking up a lot of steam in the community.
Room focuses on being a beautiful api layer to Sqlite. Florina explains to us how we can use Room to create a database, creating entities and how they map to tables using DAOs to access data and even “observe” them. Listen on for more of the details!
- Android Architecture Components
- Room migration docs
- runInTransaction api (which Florina recommended if you’re executing more than one SQL statement and don’t want multiple event fired)
- Google Samples – Android Architecutre Components
- Florina’s Medium blog posts
Micellaneous questions about Room (that we chopped off for lack of time)
Q: Does Room use reflection?
A: There’s only 1 reflection call (at the time of finding the database implementation, when you call Room.builder). Most of the other stuff is generated code (with compile time verification!).
Q: Does Room provide compile-time SQL checks
A: Yes, Room was designed to provide compile-time checks.
Q: Does Room handle SQL injection attacks (security)
Yes … for all practical purposes. See this post for times when it doesn’t.
Q: Do we have tools to access the sqlite database file directly?
Nope, at the moment, adb is your friend. Use that to download the file manually from your device.