Sergei G wrote: > I wrote a tool that I am using to maintain SQLite DB schema. It is very > simple and it is based on user_version pragma, which makes it SQLite > specific. I have no plans to make it more complicated than it is today.
This makes it quite similar to Android's SQLiteOpenHelper. > https://github.com/Kulak/sqlitemaint | Known Issues | | There is no wrapping of script file in a transaction. If script fails | it may leave datbase in an inconsistent state. Workaround: apply | transaction in the script file itself. The checking of the version and the actual update must be done atomically, so it is your tool that must create a transaction. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users