Re: [sqlite] small sqlite fts snippet function or Fts Bug!

2015-01-27 Thread boscowitch
it worked I would have manually substracted the offset and put the markers in myself... so it wasn't part of the bug report just a test how it behaves in that case. Good to know for the future that its already fixed, thx for taking care of it so fast! boscowitch Am Mittwoch, den 28.01.2015, 02:04

[sqlite] small sqlite fts snippet function or Fts Bug!

2015-01-27 Thread boscowitch
] #a# b c regards boscowitch PS: please excuse the german ;) and all English spelling errors ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FTS3

2010-12-03 Thread boscowitch
the index anew for alel these entrys. boscowitch Am Freitag, den 03.12.2010, 21:12 +0100 schrieb Ralf Jantschek: Hello, I've got a question: Is it correct, that using FTS3 with virtual tables that these tables need to be build everytime from scratch? Or are they persisted in one way

Re: [sqlite] searching with like on FTS3

2010-11-30 Thread boscowitch
It does but as you can see the like is only performed on a normal table and the match you find only entrys like sql or maby selserver but not blablalbasqlstatic Am Dienstag, den 30.11.2010, 11:50 -0800 schrieb Sam Roberts: On Mon, Nov 29, 2010 at 9:08 AM, Pascal Schnurr

[sqlite] searching with like on FTS3

2010-11-29 Thread boscowitch
together would be over 100MB when loading completely into memory and with basically the same data twice. regards boscowitch ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] searching with like on FTS3

2010-11-29 Thread boscowitch
of conjugated words liek 感じます polite to 感じる or simmilar). here you can see the app in a gif animation in action http://www.boscowitch.de/projects/wadoku-notify regards boscowitch Am Dienstag, den 30.11.2010, 00:22 +0700 schrieb Dan Kennedy: On 11/30/2010 12:09 AM, boscowitch wrote: Hi recently I

Re: [sqlite] virtual tables

2010-11-22 Thread boscowitch
Am Montag, den 22.11.2010, 21:59 -0500 schrieb dcharno: What are some of the things that people use virtual tables for? Are there any good example usages? ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Loading a FTS3 table into ram without reindexing

2010-11-21 Thread boscowitch
function http://github.com/boscowitch/wadoku-notify/blob/master/src/db.c ) now i wanted to ask if i precreate the indexed table into the db file how i can load/copy this table into a :memory: db without regeneratig the whole index. or can i advise sqlite to load at least the whole pre generated index

Re: [sqlite] Loading a FTS3 table into ram without reindexing

2010-11-21 Thread boscowitch
Am Montag, den 22.11.2010, 01:24 + schrieb Simon Slavin: On 22 Nov 2010, at 12:49am, boscowitch wrote: now i switched to an Fulltext search table FTS3 which improved speed drastically but it now need over ~15s on my 3Ghrz to load all entrys into the ram FTS3 table (with simple