Android SQLite Essentials by Aditya, Sunny Kumar -- Read -- Imperial Library of Trantor

Index

Android SQLite Essentials

Table of Contents Android SQLite Essentials Credits About the Authors About the Reviewers www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe? Free Access for Packt account holders

Preface

What this book covers What you need for this book Who this book is for Conventions Reader feedback Customer support

Downloading the example code Errata Piracy Questions

1. Enter SQLite

Why SQLite? The SQLite architecture

The SQLite interface The SQL compiler The virtual machine The SQLite backend

A quick review of database fundamentals

What is an SQLite statement? The SQLite syntax Datatypes in SQLite

Storage classes The Boolean datatype The Date and Time datatype

SQLite in Android

SQLite version Database packages

APIs The SQLiteOpenHelper class The SQLiteDatabase class ContentValues Cursor

Summary

2. Connecting the Dots

Building blocks A database handler and queries

Building the Create query Building the Insert query Building the Delete query Building the Update query

Connecting the UI and database Summary

3. Sharing is Caring

What is a content provider?

Using existing content providers

What is a content resolver?

Creating a content provider

Understanding content URIs Declaring our contract class Creating UriMatcher definitions

Implementing the core methods

Initializing the provider through the onCreate() method Querying records through the query() method Adding records through the insert() method Updating records through the update() method Deleting records through the delete() method Getting the return type of data through the getType() method Adding a provider to a manifest

Using a content provider Summary

4. Thread Carefully

Loading data with CursorLoader

Loaders Loader API's summary Using CursorLoader

Data security

ContentProvider and permissions Encrypting critical data

General tips and libraries

Upgrading a database Database minus SQL statements Shipping with a prepopulated database

Summary

Index