Android App Development: Data Persistence Libraries

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.

Introduction

• Welcome
• What you should know
• Using the exercise files
• Review the starting app

1. SQLite Basics

• 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

2. SQLite Beyond the Basics

• 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

3. Working with Room

• 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

4. Working with Cupboard

• 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

5. Realm Basics

• Introduction to Realm
• Configure a Realm instance
• Create a Realm object class
• Insert data into Realm
• View your data with the Realm browser

6. Realm Beyond the Basics

• 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

Conclusion

• Next steps