Re: [sqlite] fts2 (full-text search v2) checked into CVS.
Cesar David Rodas Maldonado wrote: Ok. I have another question. I compile SQLite (the last version 3.3.8) with this fts2 extension. So how can i index something (i mean with the SQL). A good reference for using fts1 or fts2 is available at URL: http://www.sqlite.org/cvstrac/wiki?p=FtsOne Thanks. And I think this ext is very useful I heartily echo both of the above comments. Gerry - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] fts2 (full-text search v2) checked into CVS.
Ok. I have another question. I compile SQLite (the last version 3.3.8) with this fts2 extension. So how can i index something (i mean with the SQL). Thanks. And I think this ext is very useful On 10/13/06, Scott Hess <[EMAIL PROTECTED]> wrote: You'll want (from the bottom of http://www.sqlite.org/download.html): cvs -d :pserver:[EMAIL PROTECTED]:/sqlite login cvs -d :pserver:[EMAIL PROTECTED]:/sqlite checkout sqlite or perhaps cvs -d :pserver:[EMAIL PROTECTED]:/sqlite login cvs -d :pserver:[EMAIL PROTECTED]:/sqlite checkout sqlite/ext/fts2 though I wouldn't recommend checking out just the module. If there's a core API change, the module will follow that change and get out-of-sync with whatever tarball you're using. This code is certainly a week or two from being ready to enter a tarball. -scott On 10/12/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > That's very cool... What i am wondering is if is there any way to > download the complete tarball of that folder... > > thanks. > > On 10/13/06, Scott Hess <[EMAIL PROTECTED]> wrote: > > I've checked a new version of the full-text search module into > > ext/fts2 under CVS. fts2 uses a very different style of storage from > > fts1, and is much much faster for insertions (25x faster inserting the > > Enron email database, for instance). The interface is identical, you > > just refer to fts2 instead of fts1. > > > > Caveats: It uses a new storage format, and there is currently no > > support for "upgrading" a table from fts1 to fts2. Additionally, I > > have a number of follow-on changes which will be going in over the > > next couple weeks, some of which are likely to break data > > compatibility. I'm just tossing this out here in case people are > > interested in experimenting with it. > > > > Thanks, > > scott > > > > - > > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > > > > > > -- > Cesar Rodas > http://www.phpclasses.org/grank > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > - To unsubscribe, send email to [EMAIL PROTECTED] - -- Cesar Rodas http://www.phpclasses.org/grank
Re: [sqlite] fts2 (full-text search v2) checked into CVS.
You'll want (from the bottom of http://www.sqlite.org/download.html): cvs -d :pserver:[EMAIL PROTECTED]:/sqlite login cvs -d :pserver:[EMAIL PROTECTED]:/sqlite checkout sqlite or perhaps cvs -d :pserver:[EMAIL PROTECTED]:/sqlite login cvs -d :pserver:[EMAIL PROTECTED]:/sqlite checkout sqlite/ext/fts2 though I wouldn't recommend checking out just the module. If there's a core API change, the module will follow that change and get out-of-sync with whatever tarball you're using. This code is certainly a week or two from being ready to enter a tarball. -scott On 10/12/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: That's very cool... What i am wondering is if is there any way to download the complete tarball of that folder... thanks. On 10/13/06, Scott Hess <[EMAIL PROTECTED]> wrote: > I've checked a new version of the full-text search module into > ext/fts2 under CVS. fts2 uses a very different style of storage from > fts1, and is much much faster for insertions (25x faster inserting the > Enron email database, for instance). The interface is identical, you > just refer to fts2 instead of fts1. > > Caveats: It uses a new storage format, and there is currently no > support for "upgrading" a table from fts1 to fts2. Additionally, I > have a number of follow-on changes which will be going in over the > next couple weeks, some of which are likely to break data > compatibility. I'm just tossing this out here in case people are > interested in experimenting with it. > > Thanks, > scott > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > -- Cesar Rodas http://www.phpclasses.org/grank - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] fts2 (full-text search v2) checked into CVS.
That's very cool... What i am wondering is if is there any way to download the complete tarball of that folder... thanks. On 10/13/06, Scott Hess <[EMAIL PROTECTED]> wrote: I've checked a new version of the full-text search module into ext/fts2 under CVS. fts2 uses a very different style of storage from fts1, and is much much faster for insertions (25x faster inserting the Enron email database, for instance). The interface is identical, you just refer to fts2 instead of fts1. Caveats: It uses a new storage format, and there is currently no support for "upgrading" a table from fts1 to fts2. Additionally, I have a number of follow-on changes which will be going in over the next couple weeks, some of which are likely to break data compatibility. I'm just tossing this out here in case people are interested in experimenting with it. Thanks, scott - To unsubscribe, send email to [EMAIL PROTECTED] - -- Cesar Rodas http://www.phpclasses.org/grank - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] fts2 (full-text search v2) checked into CVS.
I've checked a new version of the full-text search module into ext/fts2 under CVS. fts2 uses a very different style of storage from fts1, and is much much faster for insertions (25x faster inserting the Enron email database, for instance). The interface is identical, you just refer to fts2 instead of fts1. Caveats: It uses a new storage format, and there is currently no support for "upgrading" a table from fts1 to fts2. Additionally, I have a number of follow-on changes which will be going in over the next couple weeks, some of which are likely to break data compatibility. I'm just tossing this out here in case people are interested in experimenting with it. Thanks, scott - To unsubscribe, send email to [EMAIL PROTECTED] -