Re: [sqlite] using SQLite with mod_perl

by a different process or thread than the one that served the initial request. Good luck, Laurent Dami ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] last_insert_rowid() returns wrong value after insert in a fts5 virtual table.

en FILENAME" to reopen on a persistent database. sqlite> create virtual table f5 using fts5(c); sqlite> insert into f5(c) values('foobar'); sqlite> select last_insert_rowid(); 10 sqlite> select rowid, c from f5; 1|foobar [run on a Win

[sqlite] a few documentation bugs

Hi all, Thanks for sqlite. I noticed a couple of documentation bugs. In compile.html: -DSQLITE_DISABLE_FTS3_UNICODE is documented but obsolete -DSQLITE_ENABLE_FTS4_UNICODE61 is not documented In vtab.html - typo "must should" in "The xCreate must should return SQLITE_OK if ..." ___

[sqlite] missing doc for FTS feature "^"

Hi, I accidentally found the following interesting feature in the Change history : 2011-11-01 (3.7.9) If a search token (on the right-hand side of the MATCH operator) in FTS4 begins with "^" then that token must be the first in its field of the document. ** Potentially Incompatible Chan

[sqlite] documentation bugs

* In http://www.sqlite.org/src/wiki?name=Bug+Reports , the href to the bug list is http://www.sqlite.org/src/report; should be http://www.sqlite.org/src/reportlist * In vtab.hml: the description of sqlite3_index_info is not up to date (missing estimatedRows) * In compile.html : the compile

[sqlite] new support for virtual tables written in Perl

program and a sqlite database, or for joining data from various sources. The stable release should be published in next September or October. Comments / remarks are welcome. Cheers, Laurent Dami ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] virtual tables (was : SQLite as a meta database)

means that you can implement virtual tables through Perl classes instead of writing C code, which (at least in my view) is much easier to write and to debug. Laurent Dami ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:80

Re: [sqlite] Possible to get list of terms in the Full Text Index?

t-Type: text/plain; charset=ISO-8859-1; format=flowed Hi, Is it at all possible to get a listing of all terms in the Full Text Index and which rowid's they were found in? Yes it is possible, look at http://www.sqlite.org/fts3.html#fts4aux L

[sqlite] how to use fts5 ?

acc/bison. Did I miss some documentation ? Or is it not ready yet for use ? Thanks in advance, Laurent Dami