Overview
-
Get started with data persistence for Android apps. Learn about various options for storing your app's data in a database, including working with SQLite, Cupboard, and Realm.
Syllabus
-
Introduction
- Welcome
- What you should know
- Using the exercise files
- Review the starting app
- Overview of SQLite
- Define a database table's schema
- Define a Database SQLite open helper
- Explore SQLite create table syntax
- Execute create table statements
- Create a database wrapper
- Explore the ContentValues class
- Insert data into a table
- Insert data with a foreign key relation
- Inspect the database using a terminal
- Inspect the database using GUI tools
- Explore SQLite queries
- Query data using a raw query
- Parse cursors and display data in the UI
- Update records in a table
- Delete records from a table
- Overview of Room
- Defining database entities
- Defining a Room database
- Create a data access object
- Working with the @Insert annotation
- Insert data into a table
- Explore Room queries
- Query data and display in a RecyclerView
- Create observable queries
- Create a schema migration
- Overview of Cupboard
- Define a database schema
- Insert data into a table
- Introduction to converters
- Store lists as JSON using converters
- Query data and display in a RecyclerView
- Update records in a table
- Delete records from a table
- Create a schema migration
- Introduction to Realm
- Configure a Realm instance
- Create a Realm object class
- Insert data into Realm
- View your data with the Realm browser
- Create relationships between objects
- Explore Realm queries
- Query Realm objects
- Display data in a RecyclerView
- Explore Realm updates
- Update Realm objects
- Delete Realm objects
- Explore Realm migrations
- Create a schema migration
- Next steps
