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

Hi Travis, You need to define a "tokenizer" to be used by FTS3; something somehow similar to user-defined collating sequences. See http://www.sqlite.org/fts3.html#section_5_1 The ICU library has language-specific library functions for ignoring accents while tokenizing. The Perl binding

Re: [sqlite] FTS Question

Hi Michael, While indexing, the standard tokenizer treats 'play-off' as two different words, so the indexing is exactly the same as for 'play off' or 'play, off'. Now when querying, the query analyzer treats the hyphen as 'AND NOT', so your query really becomes 'play AND NOT off', which

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

>-Message d'origine- >De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] De la part de Black, Michael (IS) >Envoyé : dimanche, 3. octobre 2010 14:02 >À : General Discussion of SQLite Database >Objet : Re: [sqlite] EXTERNAL:Re: FTS Question > >OK...that make

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)

Hi all, I have a Perl Catalyst app using SQLite as storage. It has been running for several months without any problem. Now in the last few days we had several crashes of SQLite (file gets corrupted). This is just incomprehensible because all development and production engineers claim that

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

>Hi all, > >I have a Perl Catalyst app using SQLite as storage. It has been running >for several months without any problem. >Now in the last few days we had several crashes of SQLite (file gets >corrupted). This is just incomprehensible because all development and >production engineers claim

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