Re: [android-developers] Proper documentation for SQLite usage missing - I need guidance

On Tue, Aug 2, 2011 at 11:42 AM, Jan Skarvall <jan.skarvall@telia.com> wrote:
> I assume that to be on the safe side I should go for SQLite 3.4.0, as this is stated here: http://developer.android.com/reference/android/database/sqlite/package-summary.html

The version of SQLite varies by Android version. Android 2.2, for
example, appears to use 3.6.22.

> I really wonder how developers do when they create apps using SQLite. How on earth do they know what to (not) use?

~99% of the supported SQL syntax has not varied during the Android
project lifetime. If you want to use a cutting-edge feature, you will
need to experiment. You can detect the version at runtime if needed:

http://blog.js-development.com/2011/01/android-howto-detect-installed-sqlite.html

http://stackoverflow.com/questions/2421189/version-of-sqlite-used-in-android/3613043#3613043

--
Mark Murphy (a Commons Guy)
http://commonsware.com | http://github.com/commonsguy
http://commonsware.com/blog | http://twitter.com/commonsguy

Android Training in NYC: http://marakana.com/training/android/

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en