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

Reply via email to