Android Question What happen if SQLite Library on Dev diff with SQLite on Device?

[incendio]

Hi guys,

I am using SQLite Library ver 3.8.4.3 to create database on my cpu.
But I think, SQLite on devices may not the same ver.

I have a few questions about SQLite in the device :
1) Can my app deploy without an error to any device if SQLite ver is diff?
2) Are SQLite in all device has same version?
3) SQLite ver in the device, is it depend on device or depend on OS(ICS/JB/Kit kat) the device using?

Thanks in advance.

 

[Erel]

The SQLite version depends on the Android version: http://stackoverflow.com/questions/2421189/version-of-sqlite-used-in-android

You should make sure that you are not using any feature of the new version that will break the compatibility of older versions. In most cases you will not encounter any problem.

 

[incendio]

Ok, thanks for the answer.

I have already use all sql features, such as foreign key, integrity constraint, etc. No wonder got strange result when running on device.

I guest, i have to redesign the database again!