Re: [sqlite] New sqlite version update tool based on pragma
I can certainly add a transaction. I did not know "Android's SQLiteOpenHelper" exists. On Sat, Oct 1, 2016 at 1:01 AM, Clemens Ladisch wrote: > 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 > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] New sqlite version update tool based on pragma
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
[sqlite] New sqlite version update tool based on pragma
Hi, I am a passive subscriber to this list at best and I use SQLite on small projects. 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. I used GO language to write the library and application for it. Reusable library and detailed documentation of algorithm: https://github.com/Kulak/sqlitemaint Console executable front end: https://github.com/Kulak/sqlitemaintainer It is just my small contribution back to an excellent SQLite library. I am not sure if there is a good reference repository to get tool listed. Thank you ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users