SQLite Provider: A simplification of database access David Gonzalez

Content Providers Managers of structured data Abstract underlying data storage Allow external access to data

Manage connection to data source

Easy access to data

Implicit intents

Loader callbacks

Provide data to external apps

PROBLEMS — And we had to fix them

Boilerplate code

DB versioning

JSON to SQL mapping

Create the database public ExampleDatabase(Context context, CursorFactory factory, int version) { super(context, DATABASE_NAME, factory, version); } @Override public void onCreate(SQLiteDatabase db) { createDatabase(db); }

protected void createDatabase(SQLiteDatabase db) { final String articleTable = "CREATE TABLE articles" // + " ('" // + _id + "' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, '" // + title + "' TEXT, '" // + content + "' TEXT, '" // + timestamp + "' TIMESTAMP NOT NULL );"; db.execSQL(articleTable); @Override public void onCreate(SQLiteDatabase db) { createDatabase(db); }

Upgrade it @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { if (oldVersion == 0) { db.execSQL("DROP TABLE article"); createDatabase(db); } }

Upgrade it ContentResolver resolver = getContentResolver(); String[] projection = new String[] {UserDictionary.Words._ID, UserDictionary.Words.WORD}; String selectionClause = UserDictionary.Words.WORD + " = ?"; String[] selectionArgs = new String[] {"Android"}; String sortOrder = UserDictionary.Words.WORD + " ASC”; Cursor cursor = resolver.query(UserDictionary.Words.CONTENT_URI, projection, selectionClause, selectionArgs, sortOrder);

Our solution https://github.com/novoda/SQLiteProvider