Best practices for SQLite DB and ContentProvider

We have been tuning ORMLite on Android for a while now and it is working well. ORMLite supports Android with native database calls and also supports other databases via JDBC. You annotate your classes/fields and use base DAO classes to persist to SQLite.

• CREATE TABLE statements are handled my ORMLite’s utility classes. Most SQL is taken care of by the DAO classes.
• The Android section of the online documentation explains the class hierarchy. You implement a DatabaseHelper which helps create an update your database. Your activities extend OrmLiteBaseActivity (or service or tab) which gives access to helper and DAOs.
• ORMLite does not provide a solution for merging with remote REST servers.

Hope this is somewhat helpful.