The Fragmented Podcast is a podcast for Android Developers hosted by Donn Felker and Kaushik Gopal. Our goal is to help you become a better Android Developer. We chat about topics such as Testing, Dependency Injection, Patterns and Practices, useful libraries, and much more. We will also be interviewing some of the top developers out there. Subscribe now and join us on the journey of becoming a better Android Developer.
http://www.fragmentedpodcast.com
episode 95: 095 : Room Databases with Florina Muntenescu
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 Medium blog posts
- Room & RxJava
- 7 steps to Room
- Understanding migrations with Room
- Testing Room migrations
- Room - Behind the scenes (Yigit Boyar)
- Data Persistence in Android: Room for Improvement
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 checksA: 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.
Sponsors- Rollbar - special offer: Bootstrap plan free for 90 days
- @fmuntenescu [twitter.com]
- @fragmentedcast [twitter.com]
- @donnfelker and +DonnFelker
- @kaushikgopal and +KaushikGopalIsMe