You are missing the whole point. Mark is saying that you can read a version of SQLite database created by a newer version SQLite in an older version of SQLite since the format hasn't changed. I am saying that is not true and you cannot and I proved it on my test envorinment. And I am saying that this a serious issue as a user cannot go back to a device running an older version of Android (thus, an older version SQLite) and that they cannot move their database from Cyogenmod to a non-Cyogenmod phone.
What you are doing is creating a DB on 3.6.11 and read it on 3.7.7 -- that will of course work as SQLite is backwards compatible. On Aug 4, 9:43 am, Miguel Morales <[email protected]> wrote: > I just compiled two versions of sqlite lite. > 3.7.7.1 2011-06-28 17:39:05 af0d91adf497f5f36ec3813f04235a6e195a605f > and 3.6.11 > > Created a table called test.db using 3.6.11 and it worked just fine > when reading the data using the latest version. > If I can find a version for the source of the versions you tried I can > try those out as well. > > I suspect the error has to do with your funky file name. > > > > > > On Wed, Aug 3, 2011 at 6:24 PM, Miguel Morales <[email protected]> > wrote: > > Your app should support older versions of the sdk without the user > > having the revert to an old (outdated) version of your app. > > If you are going to support older versions, you should do so by > > keeping your latest versions backward-compatible. > > However, sqlite should be fine for this job. > > This sounds like some weird bug. > > > Anyway, what's "My Book #4" ? > > Is that the name of the file of your database? > > > On Wed, Aug 3, 2011 at 6:16 PM, Zsolt Vasvari <[email protected]> wrote: > >>> If you are going to make claims about widespread fragmentation, it is > >>> up to you to provide proof in the form of a reproducible test case. > > >>> If you don't want to take the time to supply such proof, that's fine, > >>> but then please expect us to be dubious of your claims, until somebody > >>> else supplies such a reproducible test case. > > >> Fair enough. I created a database on SQLite 3.7.2 (Cyognemod) and > >> tried loading it into V3.6.22. > > >> This is the error I am getting: > > >> sqlite3 "My Book #4" > >> SQLite version 3.6.22 > >> Enter ".help" for instructions > >> Enter SQL statements terminated with a ";" > >> sqlite> .tables > >> .tables > >> Error: database disk image is malformed > > >> I am sending you the database in a private e-mail. > > >>> -- > >>> Mark Murphy (a Commons > >>> Guy)http://commonsware.com|http://github.com/commonsguyhttp://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 [email protected] > >> To unsubscribe from this group, send email to > >> [email protected] > >> For more options, visit this group at > >>http://groups.google.com/group/android-developers?hl=en > > > -- > > ~ Jeremiah:9:23-24 > > Android 2D MMORPG:http://solrpg.com/, http://www.youtube.com/user/revoltingx > > -- > ~ Jeremiah:9:23-24 > Android 2D MMORPG:http://solrpg.com/, http://www.youtube.com/user/revoltingx- > Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
