Index

A

• Activeandroid
  • about / Database minus SQL statements
  • URL / Database minus SQL statements
  • global settings, configuring / Database minus SQL statements
• addRow() method / Building the Insert query
• addURI() method
  • about / Creating UriMatcher definitions
• affinity / Building blocks
• Ahead of Time (AOT)
  • about / SQLite in Android
• Android
  • storage / SQLite in Android
• android.database.SQLite package
  • about / Database packages
• Android developer website
  • URL / Loaders
• APIs
  • about / APIs
• Application A
  • about / What is a content provider?
• Application B
  • about / What is a content provider?
• application not responding (ANR) / Loaders
• architecture, SQLite
  • interface / The SQLite interface
  • SQL compiler / The SQL compiler
  • virtual machine / The virtual machine
  • backend / The SQLite backend
• ART
  • about / SQLite in Android
• AUTO INCREMENT keyword / Building blocks

B

• B-trees
  • about / The SQLite backend
• backend, SQLite
  • about / The SQLite backend
  • B-trees / The SQLite backend
  • Pager / The SQLite backend
  • OS Interface / The SQLite backend
• BLOB class
  • about / Storage classes
• Boolean datatype
  • about / The Boolean datatype
• branch test coverage
  • reference link / Why SQLite?
• building blocks, Android / Building blocks

C

• case-insensitive
  • about / The SQLite syntax
• close() method
  • about / The SQLiteOpenHelper class
• column constraint
  • about / Building blocks
  • URL / Building blocks
• column constraint, SQLite
  • NOT NULL constraint / Building blocks
  • DEFAULT constraint / Building blocks
  • UNIQUE constraint / Building blocks
  • PRIMARY key / Building blocks
  • CHECK constraint / Building blocks
  • AUTO INCREMENT keyword / Building blocks
• constraint
  • about / What is an SQLite statement?
• content$// URI
  • about / Understanding content URIs
• content provider
  • about / What is a content provider?
  • using / Using existing content providers, Using a content provider
  • ContentResolver object / What is a content resolver?
  • creating / Creating a content provider
  • content URI / Understanding content URIs
  • contract class, declaring / Declaring our contract class
  • URIMatcher, creating / Creating UriMatcher definitions
  • initializing, onCreate() method used / Initializing the provider through the onCreate() method
  • adding, to manifest / Adding a provider to a manifest
  / ContentProvider and permissions
• ContentResolver object
  • about / What is a content resolver?
• content URI
  • about / Understanding content URIs
• ContentValues
  • about / ContentValues
• context
  • about / The SQLiteOpenHelper class
• contract class
  • declaring / Declaring our contract class
• create query
  • building / Building the Create query
• CREATE TABLE command
  • about / What is an SQLite statement?
  • attributes / What is an SQLite statement?
• critical data, data security
  • encrypting / Encrypting critical data
• CursorLoader
  • used, for loading data / Loading data with CursorLoader
  • using / Using CursorLoader
  • started state / Using CursorLoader
  • stopped state / Using CursorLoader
  • reset state / Using CursorLoader
  • implementing / Using CursorLoader
• Cursor object
  • about / Cursor
• Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) method / Creating a content provider

D

• Dalvik virtual machine (DVM)
  • about / SQLite in Android
• data
  • loading, with CursorLoader / Loading data with CursorLoader
• data, loading
  • CursorLoader, using / Using CursorLoader
• data, loading with CursorLoader
  • loaders, using / Loaders
  • loader API / Loader API's summary
• database
  • about / A quick review of database fundamentals
  • SQLite statement / What is an SQLite statement?
  • SQLite syntax / The SQLite syntax
  • UI, connecting with / Connecting the UI and database
  • upgrading / Upgrading a database
  • prepopulated database, creating / Shipping with a prepopulated database
• database handler / A database handler and queries
• database packages
  • about / Database packages
  • APIs / APIs
  • SQLiteOpenHelper class / The SQLiteOpenHelper class
  • SQLiteDatabase class / The SQLiteDatabase class
  • ContentValues / ContentValues
  • Cursor object / Cursor
• data security
  • about / Data security
  • content provider / ContentProvider and permissions
  • permissions / ContentProvider and permissions
  • critical data, encrypting / Encrypting critical data
• datatypes, SQLite
  • about / Datatypes in SQLite
  • storage classes / Storage classes
  • Boolean datatype / The Boolean datatype
  • Date datatype / The Date and Time datatype
  • Time datatype / The Date and Time datatype
• Date datatype
  • about / The Date and Time datatype
• DEFAULT constraint / Building blocks
• delete() method / The SQLiteDatabase class
  • used, for deleting records / Deleting records through the delete() method
• delete() method, SQLiteDatabase / Building the Delete query
• DELETE command
  • about / A quick review of database fundamentals
• delete query
  • building / Building the Delete query
• deleteRow() method / Connecting the UI and database
• delRow method / Connecting the UI and database
• dynamic typing / Building blocks

E

• Eclipse
  • emulator, setting up / Building blocks
• emulator
  • about / Building blocks
• emulator, Eclipse
  • setting up, steps / Building blocks
• external storage
  • about / SQLite in Android

F

• features, SQLite
  • zero-configuration / Why SQLite?
  • no-copyright / Why SQLite?
  • cross-platform / Why SQLite?
  • compact / Why SQLite?
  • fool proof / Why SQLite?

G

• Genymotion
  • URL / Building blocks
• get*() methods
  • about / Cursor
• getBlob() method / Connecting the UI and database
• getCount() method
  • about / Cursor
• getRandomName() method / Using a content provider
• getRandomNumber() method / Using a content provider
• getReadableDatabase() method
  • about / The SQLiteOpenHelper class
• getType() method
  • used, for getting return type of content / Getting the return type of data through the getType() method
• getView() method / Connecting the UI and database
• getWriteableDatabase() method
  • about / The SQLiteOpenHelper class

I

• IllegalArgumentException / Querying records through the query() method
• insert() method
  • used, for adding records / Adding records through the insert() method
  • url parameter / Using a content provider
  • values parameter / Using a content provider
• INSERT command
  • about / A quick review of database fundamentals
• insert query
  • building / Building the Insert query
• int delete(Uri uri, String selection, String[] selectionArgs) method / Creating a content provider
• INTEGER class
  • about / Storage classes
• interface, SQLite
  • about / The SQLite interface
• internal storage
  • about / SQLite in Android
• int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) method / Creating a content provider
• isAfterLast() method
  • about / Cursor
• isReadOnly() method
  • about / The SQLiteOpenHelper class

J

• Just in Time (JIT)
  • about / SQLite in Android

L

• Lemon parser generator
  • URL / The SQL compiler
• Loader API
  • classes/interfaces / Loader API's summary
• loaders
  • about / Loaders
• loadInBackground method / Using CursorLoader

M

• moveToFirst() method
  • about / Cursor
• moveToNext() method
  • about / Cursor

N

• NOT NULL constraint / Building blocks
• NULL class
  • about / Storage classes
• NullPointerException / Querying records through the query() method

O

• OAuth
  • URL / Encrypting critical data
• onContextItemSelected() method / Connecting the UI and database
• onCreate() method / Building the Create query
  • about / The SQLiteOpenHelper class
  • used, for initializing content provider / Initializing the provider through the onCreate() method
• onOpen() method
  • about / The SQLiteOpenHelper class
• onUpgrade() method
  • about / The SQLiteOpenHelper class
  / Building the Create query
• OS Interface
  • about / The SQLite backend

P

• Pager
  • about / The SQLite backend
• path
  • about / Understanding content URIs
• permissions / Adding a provider to a manifest, ContentProvider and permissions
• prepareData() method / Building the Insert query
• prepareSendData() method / Connecting the UI and database
• prepopulated database
  • shipping / Shipping with a prepopulated database
  • creating / Shipping with a prepopulated database
• PRIMARY key / Building blocks

Q

• query
  • about / A quick review of database fundamentals, A database handler and queries
  • create query, building / Building the Create query
  • insert query, building / Building the Insert query
  • delete query, building / Building the Delete query
  • update query, building / Building the Update query
• query() method
  • used, for querying records / Querying records through the query() method
  • uri parameter / Using a content provider
  • projection parameter / Using a content provider
  • selection parameter / Using a content provider
  • selectionArgs parameter / Using a content provider
  • sortOrder parameter / Using a content provider

R

• REAL class
  • about / Storage classes
• reset state, CursorLoader / Using CursorLoader

S

• SELECT command
  • about / A quick review of database fundamentals
• shared preference
  • about / SQLite in Android
• SQLCipher
  • about / Encrypting critical data
  • URL / Encrypting critical data
  • sample application, steps / Encrypting critical data
• SQL compiler
  • about / The SQL compiler
• SQLite
  • about / Why SQLite?
  • using / Why SQLite?
  • features / Why SQLite?
  • architecture / The SQLite architecture
  • datatypes / Datatypes in SQLite
• SQLite3
  • about / SQLite version
• SQLite3 command
  • .dump / SQLite version
  • .schema / SQLite version
  • .help / SQLite version
• SQLiteDatabase() query method / Building the Insert query
• SQLiteDatabase class
  • about / The SQLiteDatabase class
  • URL, for documentation / The SQLiteDatabase class
• SQLite in Android
  • about / SQLite in Android
  • version / SQLite version
  • database packages / Database packages
• SQLite Manager tool
  • URL / Building the Create query
• SQLiteOpenHelper class
  • about / The SQLiteOpenHelper class
• SQLite statement
  • about / What is an SQLite statement?
  • INSERT / What is an SQLite statement?
  • SELECT / What is an SQLite statement?
  • UPDATE / What is an SQLite statement?
  • DELETE / What is an SQLite statement?
  • ALTER / What is an SQLite statement?
  • DROP / What is an SQLite statement?
• SQL statements
  • tips / Database minus SQL statements
• started state, CursorLoader / Using CursorLoader
• stopped state, CursorLoader / Using CursorLoader
• storage, Android
  • shared preference / SQLite in Android
  • external storage / SQLite in Android
  • internal storage / SQLite in Android
• storage classes
  • about / Storage classes
  • NULL / Storage classes
  • INTEGER / Storage classes
  • REAL / Storage classes
  • TEXT / Storage classes
  • BLOB / Storage classes
• String getType(Uri) method / Creating a content provider
• synchronized keyword
  • about / The SQLiteOpenHelper class
• syntax, SQLite
  • about / The SQLite syntax

T

• TEXT class
  • about / Storage classes
• TextUtils.isEmpty() method / Connecting the UI and database
• Time datatype
  • about / The Date and Time datatype
• tips, prepopulated database / General tips and libraries

U

• UI
  • connecting, with database / Connecting the UI and database
• UNIQUE constraint / Building blocks
• update() method / The SQLiteDatabase class
  • used, for updating records / Updating records through the update() method
  • uri parameter / Using a content provider
  • values parameter / Using a content provider
  • WHERE clause / Using a content provider
• update() method, SQLiteDatabase / Building the Update query
• UPDATE command
  • about / A quick review of database fundamentals
• update query
  • building / Building the Update query
• URI
  • about / Understanding content URIs
• Uri insert(Uri uri, ContentValues values) method / Creating a content provider

V

• VDBE
  • about / The virtual machine
• version, SQLite
  • about / SQLite version
• virtual machine
  • about / The virtual machine
• void onCreate() method / Creating a content provider