Chapter 8. Databases and Loaders

In this chapter, we will create a SQLite database following a database contract and perform read/write operations using a database called DAO (Data Access Object). We will also explain the difference between a query and a raw query.

You will learn what a content provider is and how to create it, which will allow us to make this database accessible from CursorLoader. We will access the content provider through a content resolver and query different tables of the database at the same time, and you will learn how to use a join query in a content provider.

With CursorLoader , we'll be able to synchronize a list view with a database by creating a mechanism, where if we store or modify any data in the database, the changes will automatically be reflected in our view.

To finish, we will add the popular feature pull to refresh in order to update the content on demand. So, in this chapter, the following topics will be covered:

• Creating the database
  • Database...