Persisting data with SQLite Database and Content Provider by Margaret Maynard-Reid

AnDevCon talk on 12/03/2015

Have you been avoiding SQLite DB and Content Provider because they look complicated? This class will teach you how to persist data with SQLite Database, why write a Content Provider, as well as how to access a Content Provider with a CursorLoader. From the class you will learn:

– How to create the classes to define your database schema, tables and columns
– How to exam your database schema and tables, query the data with SQLite3 (command line) and SQLite Browser (GUI).
– Concepts related to the Content Provider such as Content Authority, Uri, Content Type, and ContentResolver etc.
– How to write your own Content Provider and access a Content Provider
– Some libraries that make it easier to work with SQLite & Content Provider

Slides
– http://bit.ly/1m2J2Au

SQLite Tools
– sqlite3 command line tool – part of Android sdk/platform tools
– SQLite Browser – http://sqlitebrowser.org/
– Stetho – http://facebook.github.io/stetho/

Libraries
– SQLiteAssetHelper – http://jgilfelt.github.io/android-sqlite-asset-helper/
– SQLBrite (by Square) – https://github.com/square/sqlbritez
– Cupboard for Android – https://bitbucket.org/littlerobots/cupboard
– greenDao – http://greendao-orm.com/
– OrmLite – http://ormlite.com/

Tutorial – http://www.vogella.com/tutorials/AndroidSQLite/article.html
Udacity Class – https://www.udacity.com/course/developing-android-apps–ud853

Sample Code
– Google I/O schedule Android app – https://github.com/google/iosched
– Sample code for this talk – https://github.com/margaretmz/andevcon

Margaret Maynard-Reid
https://twitter.com/margaretmz
https://plus.google.com/+MargaretMaynardReid/posts