Is there an app that will update the sqlite version my app uses (a database full of records)?
I recognize I could just create a new database and import, but I’d rather not mess with it if someone has already invented that wheel. It seems like an obvious feature but I couldn’t find it in SQLite Manager, SQLite Pro, or the Valentina Studio.
In a related question, what version does Xojo use by default?
the sqlite version you are using is based on what version that is compiled into your application. The database file doesn’t have the database engine inside of it. You won’t need to upgrade that file unless you change major (the first digit of the version) version of the sqlite engine. so all SQLite 3.x.y versions use the same file format and can use/edit/update/modify/etc the same file.
hopefully this helps.
Yes, what Scott said.
You can always call the SQLiteDatabase.LibraryVersion method to see the version of SQLite used by the Xojo version you are using. Currently it is 3.8.8:
Dim db As New SQLiteDatabase
MsgBox(Str(db.LibraryVersion))
[quote=218715:@scott boss]the sqlite version you are using is based on what version that is compiled into your application. The database file doesn’t have the database engine inside of it. You won’t need to upgrade that file unless you change major (the first digit of the version) version of the sqlite engine. so all SQLite 3.x.y versions use the same file format and can use/edit/update/modify/etc the same file.
hopefully this helps.[/quote]
It does. I was under the impression that there might be file format changes. The part about the database engine I had a sketchy understanding of.
Yes, there was one after SQLite 2 version to SQLite 3 version, but sometimes ago.
Internet sometimes is a bit slow to talk about current. (Or forgot to put a note for the changes date).
per Dr. Hipp (author, designer, head guru of SQLite), he will only make file format changes between major versions. This way customers (anyone that uses SQLite) can continue using SQLite and upgrading without breaking stuff. Since SQLite is used in places that breaking databases just upgrading the SQLite engine, would be bad (like in aircraft, medical equipment, etc), he makes sure he doesn’t do that.
next time there will be a file format change is when we go to SQLite 4 and that is not even on the road map.
oh and if you ever get a chance to meet Dr Hipp, please do so. He is a very smart and friendly guy.
Dare I say it: “Is he hip and cool?”