Android SQLite essentials : develop android applications with one of the most widely used database engines, SQLite /
This is an ideal book for Android programmers who want to explore SQLite databases based on Android applications. The general competency level expected of the reader is prior knowledge of developing applications and basic knowledge of Android and SQL.
Clasificación: | Libro Electrónico |
---|---|
Autores principales: | , |
Otros Autores: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Birmingham, England :
Packt Publishing Ltd,
2014.
|
Colección: | Community experience distilled.
|
Temas: | |
Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 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; The 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.
- Chapter 2: Connecting the DotsBuilding blocks; 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; Chapter 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() methodUpdating records through the update() method; Deleting records through the delete() method; Getting the return type of the data through the getType() method; Adding a provider to a manifest; Using a content provider; Summary; Chapter 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.