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

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