September 05, 2017

095 : Room Databases with Florina Muntenescu

56 minutes

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 them map to tables, using DAOs to access data and even observe them

Listen on for the details!

Show Notes

Official docs

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 posts

Florina's Medium blog posts

Room & RxJava

7 steps to Room

Understanding migrations with Room

Testing Room migrations

360|AnDev talks

Room - Behind the scenes (Yigit Boyar)

Data Persistence in Android: Room for Improvement

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.