Room allows you to have extensive control over the structure of your underlying SQLite database. In this video, learn how you can take advantage of @Entity, @ColumnInfo, and more to control how your database tables are designed.
- [Instructor] We're going to add a database…to our sample application.…Previously, we used Vanilla SQLite,…but this time, we're going to use Room…as our abstraction layer.…The first thing we need is to make sure…we have Google's Maven Repository…in our top-level build.gradle file,…just as you see here on line 18.…This is where we get the latest version…of the room library dependencies.…Next if we switch over to our applications build.gradle file…we need to have the compile time dependencies,…which is here on line 35,…as well as the annotation processor dependency scope…that you see here on line 36.…
This is going to allow us to have…the annotation processor applied at compile time,…but not be included in our APK.…And this is all we need in order…to get access to the core room classes.…Now the next thing we want to do is update our model objects…to adhere to the structure required by room.…So let's open them up now.…First we're gonna open up the recipe class.…And at the beginning of the file…we're going to use the @Entity annotation.…
To begin, Annyce Davis reviews using the de facto data persistence solution available on Android: SQLite. She takes you through basic SQLite concepts—such as how to create a database wrapper and insert data into a table—as well as a few more advanced topics. Next, she covers working with Cupboard, an open-source project dedicated to simplifying your SQLite interactions. To wrap up, she dives into working with Realm, an object database solution designed with mobile devices in mind. Throughout the course, Annyce discusses establishing relationships between database tables, creating and running queries, as well as performing data migrations.
- Overview of SQLite
- Defining a database table's schema
- Exploring SQLite create table syntax
- Executing create table statements
- Inserting data with a foreign key relation
- Inspecting the database using a terminal
- Updating and deleting records
- Working with Cupboard
- Working with Realm
Skill Level Intermediate
Q: This course was updated on 05/24/2018. What changed?
A: New videos were added that cover working with Room.
Android App Development: Unit Testingwith James P White2h 58m Intermediate
Learning Firebase Cloud Messaging for Androidwith Joe Marini52m 49s Intermediate
1. SQLite Basics
2. SQLite Beyond the Basics
3. Working with Room
4. Working with Cupboard
5. Realm Basics
6. Realm Beyond the Basics
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.