Re: [sqlite] Strategies for checking the version of a database?

2012-09-21 Thread _ph_
> http://semver.org/ Yikes! A good example for how many words it takes to formalize somethign that "feels" obvious. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Strategies-for-checking-the-version-of-a-database-tp64330p64419.html Sent from the SQLite mailing list arc

Re: [sqlite] Strategies for checking the version of a database?

2012-09-21 Thread _ph_
I'm using SQLite as application data file format for our software product line, and being compatible in both directions is important for us (and honored by our users). I've only recently moved to SQLite, so the thoughts listed here haven't stood the test of time yet, but I'd assume they are helpful

Re: [sqlite] Strategies for checking the version of a database?

2012-09-19 Thread Rui Maciel
On 09/18/2012 12:05 PM, Marcus Ilgner wrote: You could use the user_version pragma (don't use schema_version) to store this information. Seehttp://www.sqlite.org/pragma.html#pragma_schema_version Nice. It looks like pragma user_version is exactly what I was looking for. Thanks for the help,

Re: [sqlite] Strategies for checking the version of a database?

2012-09-18 Thread Petite Abeille
On Sep 18, 2012, at 1:05 PM, Marcus Ilgner wrote: >> Considering this, and according to your experience, what's the best >> sqlite-friendly way to check for the version of a database schema? >> > > You could use the user_version pragma (don't use schema_version) to > store this information. >

Re: [sqlite] Strategies for checking the version of a database?

2012-09-18 Thread Richard Hipp
On Tue, Sep 18, 2012 at 6:38 AM, Rui Maciel wrote: > Say there is an application that relies on sqlite for its database needs, > and that from a version onward it starts to use a different database > schema. When faced with this type of change, it is always nice to have a > way to infer if the a

Re: [sqlite] Strategies for checking the version of a database?

2012-09-18 Thread Marcus Ilgner
On Dienstag, 18. September 2012 12:38:17, Rui Maciel wrote: > Say there is an application that relies on sqlite for its database > needs, and that from a version onward it starts to use a different > database schema. When faced with this type of change, it is always > nice to have a way to infer i

[sqlite] Strategies for checking the version of a database?

2012-09-18 Thread Rui Maciel
Say there is an application that relies on sqlite for its database needs, and that from a version onward it starts to use a different database schema. When faced with this type of change, it is always nice to have a way to infer if the application's database corresponds to the old schema in or