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
[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
Re: [sqlite] FTS Example Fails (matchinfo arguments)
Is there a way I can obtain documentation that matches my version? Online documentation is for the most current version. I have found that both my hosting provider and debian stable are a bit behind, so I have to work with what I've got. Thanks On Thu, Jun 14, 2012 at 1:16 AM, Dan Kennedy wrote: > On 06/14/2012 01:27 PM, Sergei G wrote: > >> I am running sqlite3 version 3.7.3 on debian. >> >> I run the following commands from fts3.html documentation page: >> >> CREATE VIRTUAL TABLE t1 USING fts4(a, b); >> INSERT INTO t1 VALUES('transaction default models default', 'Non >> transaction reads'); >> INSERT INTO t1 VALUES('the default transaction', 'these semantics >> present'); >> INSERT INTO t1 VALUES('single request', 'default data'); >> >> SELECT matchinfo(t1) FROM t1 WHERE t1 MATCH 'default transaction >> "these semantics"'; >> >> SELECT matchinfo(t1, 'ns') FROM t1 WHERE t1 MATCH 'default transaction'; >> >> The last line with match info(t1, 'ns') fails with the following error >> message: >> >> Error: wrong number of arguments to function matchinfo() >> >> I have originally worked on my own table, but found the same error. So, I >> have tried example above and it failed for me in the same way. >> > > I think the two argument version of matchinfo() is only in 3.7.4 and > newer. Prior to that it only accepted one argument. > __**_ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] FTS Example Fails (matchinfo arguments)
I am running sqlite3 version 3.7.3 on debian. I run the following commands from fts3.html documentation page: CREATE VIRTUAL TABLE t1 USING fts4(a, b); INSERT INTO t1 VALUES('transaction default models default', 'Non transaction reads'); INSERT INTO t1 VALUES('the default transaction', 'these semantics present'); INSERT INTO t1 VALUES('single request', 'default data'); SELECT matchinfo(t1) FROM t1 WHERE t1 MATCH 'default transaction "these semantics"'; SELECT matchinfo(t1, 'ns') FROM t1 WHERE t1 MATCH 'default transaction'; The last line with match info(t1, 'ns') fails with the following error message: Error: wrong number of arguments to function matchinfo() I have originally worked on my own table, but found the same error. So, I have tried example above and it failed for me in the same way. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users