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 if the application's database corresponds > to the old schema in order to migrate it to the current format. > > 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. See http://www.sqlite.org/pragma.html#pragma_schema_version All the best Marcus Ilgner _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
