Re: [sqlite] Formatted text with fts3

2009-03-10 Thread Paul Perry
Scott, Thanks so much for your thoughtful response. Things can get complicated (especially with full text searching) when using formatted text. What I really want to do is retain the formatting, to display in a HTML file. The text out of the database would be wrapped by a basic HTML outter docu

Re: [sqlite] Formatted text with fts3

2009-03-10 Thread Scott Hess
The fts module doesn't do anything "interesting" with embedded meta-data in the interests of simplicity. Stripping the info out before inserting is probably easiest, but has the downsides of duplication (assuming you need to keep the raw data elsewhere), and it means that queries involving snippet

Re: [sqlite] Formatted text with fts3

2009-03-10 Thread Paul Perry
Thank you for the pointers Alexandre and Alexey. I spent about 30 minutes looking into the parser, and it looks like it is a possibility. I'll require a more in-depth understanding in order to do this. I would probably start with the simple parser, and go from there. > I think to prepare html b

Re: [sqlite] Formatted text with fts3

2009-03-10 Thread Alexey Pechnikov
Hello! On Tuesday 10 March 2009 06:16:16 Alexandre Courbot wrote: > Never did this myself, but I think you can do what you need by writing > your own tokenizer: > > http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/fts3/README.tokenizers It's not good advice for a few documented module. I thin

Re: [sqlite] Formatted text with fts3

2009-03-09 Thread Alexandre Courbot
Never did this myself, but I think you can do what you need by writing your own tokenizer: http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/fts3/README.tokenizers Alex. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-

[sqlite] Formatted text with fts3

2009-03-09 Thread Paul Perry
I've been looking into the full text search capabilities of SQLite and it looks like exactly what I need. Cool stuff, especially in the confines of all the other great features of SQLite. The question is if I could put formatted text in a text field, and not have that show up in a full text searc