Logo Icon Logo
A Crowd-sourced Cookbook on Writing Great Android® Apps
GitHub logo Twitter logo OReilly Book Cover Art
Easy Data Persistence with RoomBack to Android Cookbook Home | Up to Chapter: Data Persistence

Author: Ian Darwin ('idarwin')
In Published Edition? Yes
FormatLanguage: AsciiDoc

Easy Data Persistence with Room


You want a useful data storage mechanism.


Room is the ORM (Object-Relational Mapper) that has been missing from Android for a decade, but it's here now. Add it as a dependency and start coding:

More details follow.


On the Java side we've had Hibernate since the early 2000's and JPA for many years. We've also had even higher-level tools like DeltaSpike Data, which let you write a DAO interface and have it generated/implemented for you.

We've had a few attempts at making ORMs for Android, some of which I investigate in an online project (https://github.com/IanDarwin/AndroidORM).

But Room is the first officially-supported ORM; in fact, Google now advise people to use Room instead of using the underlying SQLite API directly. And you should - it's just better!

Configure Your Project

Add the following entries in `app/build.gradle` (of course, the version number will change over time):

Annotate your Entities

Use Room's @Entity on your data object class, @PrimaryKey on the pkey, and @ColumnInfo on each column that you want persisted.

public class Expense {

@PrimaryKey(autoGenerate = true) long id;

@ColumnInfo() String date;

@ColumnInfo() String description;

@ColumnInfo() double amount;

public Expense() { // empty }

// Other constructors, toString(), trivial accessors, omitted for brevity. }

Compose your DAO

Your DAO is just an interface; pick the operations you need, write them in terms of Java methods, and add the @Query annotation to describe the matching SQL command. Here is my ExpenseDao interface:

public interface ExpenseDao {

@Query("SELECT * FROM expense") List getAll();

@Query("SELECT * FROM expense WHERE id IN (:expenseIds)") List findByIds(int[] expenseIds);

@Query("SELECT * FROM expense WHERE description LIKE :descr Limit 1") Expense findByDescription(String descr);

@Insert void insert(Expense... expenses);

@Delete void delete(Expense expense); }

Note that because of the way it's written, insert() will work for either one entity or several or an array of them.

Create a tiny Database Setup Class

Here you list the entity classes, the SQLite version, and the name of the method to use to fetch your DAO:

@Database(entities = {Expense.class}, version = 1)
public abstract class AppDatabase extends RoomDatabase {
    public abstract ExpenseDao expenseDao();

Do It.

Assuming your Gradle setup has run the APT provided by Room, you can now load your database, fetch its DAO, and call the CRUD (Create, Read, Update, Delete) methods you defined in your DAO interface.

mDatabase = Room.databaseBuilder(this,
                AppDatabase.class, "expenses.db").build();
mDao = mDatabase.expenseDao();

Expense x = new Expense(today, description, amount); mDao.insert(x); // in background thread

While this will work, the documentation recommends keeping at least the Database object in a Singleton, which I do in the code directory shown for this example.

And, of course, database accessing must be done in a background thread.

See Also

The Room documentation is at https://developer.android.com/training/data-storage/room/


The source code for this project is in the Android Cookbook repository, http://github.com/IanDarwin/Android-Cookbook-Examples/tree/master/RoomDemo