[sqlite] Problem with DETACH on 2.8.16

: xHash!=0, file hash.c, line 299 Abnormal program termination This error will occur using the command line (under Windows) or the DLL. Could you please check. Thanks in advance. Laurent.

Re: [sqlite] Problem with DETACH on 2.8.16

.txtI get this error on Windows XP and Windows W2K.Best regards,Laurent.=== attach 'x1.dbx' as d1; attach 'x2.dbx' as d2; detach d1; create table documents (a); create index i on documents(a);

Re: [sqlite] sqlite syntax auto suggest

. Could you perhaps explain what pos means and what the [isTerminal] = 0 rows mean. If you have not time for these things I completely understand, thanks anyway! Laurent On 28.11.19 23:54, Richard Hipp wrote: On 11/28/19, Laurent Dhont wrote: is there an API to get this information

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

This 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?

9a81.2010...@bauerapps.com> Content-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

[sqlite] how to use fts5 ?

I miss some documentation ? Or is it not ready yet for use ? Thanks in advance, Laurent Dami

[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

[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] Problem installing sw-sso package based on sqlite because of schema version

Hello, I'm trying to install sw-sso package on my Debian server and this package use sqlite. The installation fails because of the schema version : DB file already exists. Let's check for upgrade DB update failed (Downgrade is not supported (8 -> 7).). See log file for detailed output. Whe I

[sqlite] Cross-platform Intel <-> ARM sqlite file issue...

;' 1.2|1.3 -9.25596534178523e+61|-2.35343828009147e-185 Did I miss something ? Thank you very much, Laurent ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Cross-platform Intel <-> ARM sqlite file issue...

Hi, My proc is an ARM920T, but yes, it did solve the problem. Thank you very much !! L. Kees Nuyt writes: > On Fri, 25 Nov 2011 12:30:10 +0100, Laurent PERROTON > <l.perro...@esiee.fr> wrote: > > > I am having a cross-platform Intel/ARM sqlite file issue. > &g

[sqlite] Raise not working.

I have a problem to get < RAISE > function working. When the trigger is triggered by an insert, i only want to execute the < update > and skip the first insert. So i tried this with sqlite version 3.3.8 : -- create table

Re: [sqlite] using sqlitejdbc-v056 with ant build file

>>>> sqlite-users mailing list >>>> sqlite-users@sqlite.org >>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>>> >>> ___ >>> sqli

Re: [sqlite] using SQLite with mod_perl

rent 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] accessing a sqlite db with multiple java processes.

he same db with several jobs ? If so (and maybe this is not the right place to ask), what are the best practices using sqlitejdbc ? (or any other jdbc driver)... thanks -- Laurent ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:80

Re: [sqlite] accessing a sqlite db with multiple java processes.

to be released and then write... On Wed, May 27, 2009 at 10:19 AM, Martin.Engelschalk < engelsch...@codeswift.com> wrote: > http://www.sqlite.org/faq.html#q5 -- Laurent ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:808

[sqlite] SQLite to MySQL

if there is a way to convert easily an SQLite database into a MySQL one ? (I'm especially thinking about the escapestring and other "create table [myTable] {" issues...) Thanks, Laurent

Re: [sqlite] SQLite to MySQL

I don't know, I suppose my queries are not as optimized as I thought (even if this optimization was my leitmotiv for all the development part), or perhaps it's an apache2+php5 issue on my windows computer... But the fact is since the database has grown (like my traffic : 6000 visitors/day and

Re: [sqlite] SQLite to MySQL

Ho, thank you Herbet ! But, hmmm, is there a chance you know an opensource or free solution instead of this expensive one ? 2006/2/6, Laurent Goussard <[EMAIL PROTECTED]>: > I don't know, I suppose my queries are not as optimized as I thought > (even if this optimization was my leitm

Re: [sqlite] DLLs containing user-defined SQL functions

red environment is then initialized; functions funA,funB ... are callable from the DLL.. Best regards, Laurent Blanquet. == - Original Message - From: <[EMAIL PROTECTED]> To: "Sqlite-users" <sqlite-users@sqlite.org> Sent: Wednesday, June 07, 2006 4:30 PM Subject: [sqlite] DLL

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

;.open 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 Windows7 mach

Re: [sqlite] sqlite syntax auto suggest

get a list of all words that can be used in the next word the user is going to type. I hope I am making sense. Thanks! Kind regards, Laurent On 29.11.19 14:09, Richard Hipp wrote: On 11/29/19, Laurent wrote: Could you perhaps explain what pos means and what the [isTerminal] = 0 rows

[sqlite] sqlite syntax auto suggest

Please do not feel obligated to answer this question, if you do this is much appreciated! Thanks in advance. Kind regards, Laurent Dhont ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Disambiguation of Latin accent characters for FTS3

rl binding for SQLite has a general-purpose "unaccent" tokenizer, see http://search.cpan.org/dist/DBD-SQLite/lib/DBD/SQLite.pm#FULLTEXT_SEARCH and http://search.cpan.org/~dami/Search-Tokenizer-1.00/lib/Search/Tokenizer.pm Or you can write your own tokenizer in C ... Best regards, Laurent

Re: [sqlite] FTS Question

tokenizer and hook it to FTS3. The doc explains how to do this. Best regards, Laurent Dami >-Message d'origine- >De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] De la part de Black, Michael (IS) >Envoyé : vendredi, 1. octobre 2010 16:54 >À : Gen

Re: [sqlite] EXTERNAL:Re: FTS Question (hyphenated words).

ay-off" as a single word, then probably the query analyzer will receive one single token and will not interpret the hyphen as NOT. Laurent Dami ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] using SQLite with mod_perl

>-Message d'origine- >De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] De la part de Clark Christensen >Envoyé : lundi, 11. octobre 2010 17:26 >À : General Discussion of SQLite Database >Objet : Re: [sqlite] using SQLite with mod_perl > >>So, I want all the

Re: [sqlite] Full text search FTS3 of files

>Is it possible to use FTS3 for search without storing the actual file >contents/search terms/keywords in a row. In other words, create a FTS3 >tables with rows that only contains an ID and populate the B-Tree with >keywords for search. > Each FTS3 table t is stored internally within three

[sqlite] experiencing SQLite crash (Apache/mod_perl/Catalyst)

Apache 2.2.8 Solaris / mod_perl 2.04 / Perl 5.7.8 / Catalyst 5.7007 / DBD::SQlite 1.13. Thanks in advance, Laurent Dami ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] experiencing SQLite crash (Apache/mod_perl/Catalyst)

, etc. would be welcome. > >The production server is running Apache 2.2.8 Solaris / mod_perl 2.04 / >Perl 5.7.8 / Catalyst 5.7007 / DBD::SQlite 1.13. > >Thanks in advance, > > Laurent Dami > For info : we partially understood the problem. The production server use

Re: [sqlite] Implementing Regular Expression Support...?

>-Message d'origine- >De : sqlite-users-boun...@sqlite.org >[mailto:sqlite-users-boun...@sqlite.org] De la part de J. King >Envoyé : mardi, 8. décembre 2009 18:24 >À : General Discussion of SQLite Database >Objet : Re: [sqlite] Implementing Regular Expression Support...? > >On Tue, 08