Hi
I'm writing an app which uses the Foreign Key Constraints which support was only just brought in for on version 2.2, and my phone is 2.1 Is there any way to upgrade the version of sqlite3 on the htc desire or any other android phone when your application installs?
short answer, no.
Longer answer. Yes, but you would have to have root because the sqlite binary is in /system/xbin. you would need root access to be able to overwrite that file. you would not be able to upgrade any other device unless they too had root, and a recovery image that supported update.zips that can be signed using the "test keys". then you would have to manually distribute the update zip file, that the user would have to reboot in to recovery mode, flash the update.zip to apply your "patch".