Re: [sqlite] FTS1 or FTS2

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 05/26/2010 07:22 PM, Sam Carleton wrote:
> I did this search:
> 
> http://www.google.com/search?q=sqlite+text+search

Thanks.  I have updated the relevant wiki pages to say the information is
old and to point to the current FTS3 implementation.

> maybe things should be configured so that
> CVS isn't crawled by search engines

It isn't CVS but rather cvstrac which is a web interface using CVS as a back
end and providing easy viewing of the source, changes, a wiki, bug tracking etc.

SQLite has since moved to a DVCS named fossil which has that stuff (wiki,
bug tracking, web interface etc) as a native part.  See
http://www.fossil-scm.org/

However the wiki for SQLite remains the old cvstrac based one.  There is
unfortunately a fair amount of cruft accumulated in it as you fell victim
to, especially documentation that is now part of the core SQLite.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkv95aEACgkQmOOfHg372QSH6gCgh6nQMN1zfArIJ6PP+EyBAHJ0
goEAoNtKK8/IRVH3ENBOdj/RhKKhOcgu
=DXMy
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FTS1 or FTS2

[P Kishor]

On Wed, May 26, 2010 at 9:22 PM, Sam Carleton
 wrote:
> Roger,
>
> I did this search:
>
> http://www.google.com/search?q=sqlite+text+search
>
> The top link points here:
>
> http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex
>
> Thus I learned of FTS1 and FTS2, maybe things should be configured so that
> CVS isn't crawled by search engines ;)


The latest version is FTS3 (higher numbers are later versions). FTS1
and FTS2 are deprecated. FTS3 source is included in the sqlite source
download. Check the build instructions for sqlite. You can set a
compile time flag and build FTS3 into sqlite3.


>
> Sam
>
> On Wed, May 26, 2010 at 2:47 PM, Roger Binns  wrote:
>
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> On 05/26/2010 10:24 AM, Sam Carleton wrote:
>> > If I do opt to use FTS, which one should I be using, FTS1 or FTS2?
>> > According to the web site, it should be FTS1, correct?
>>
>> Just as a matter of interest what part of the web site led you to those
>> conclusions?
>>
>> Roger
>> -BEGIN PGP SIGNATURE-
>> Version: GnuPG v1.4.10 (GNU/Linux)
>> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>>
>> iEYEARECAAYFAkv9bKcACgkQmOOfHg372QTINwCglr7//BHCgOt3vKApNZ8/EVYI
>> rcIAn1pYT57Rb/7zeyYGuEw+xyYVbxVG
>> =Imqe
>> -END PGP SIGNATURE-
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
---
Assertions are politics; backing up assertions with evidence is science
===
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FTS1 or FTS2

[Sam Carleton]

Roger,

I did this search:

http://www.google.com/search?q=sqlite+text+search

The top link points here:

http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex

Thus I learned of FTS1 and FTS2, maybe things should be configured so that
CVS isn't crawled by search engines ;)

Sam

On Wed, May 26, 2010 at 2:47 PM, Roger Binns  wrote:

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 05/26/2010 10:24 AM, Sam Carleton wrote:
> > If I do opt to use FTS, which one should I be using, FTS1 or FTS2?
> > According to the web site, it should be FTS1, correct?
>
> Just as a matter of interest what part of the web site led you to those
> conclusions?
>
> Roger
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.4.10 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iEYEARECAAYFAkv9bKcACgkQmOOfHg372QTINwCglr7//BHCgOt3vKApNZ8/EVYI
> rcIAn1pYT57Rb/7zeyYGuEw+xyYVbxVG
> =Imqe
> -END PGP SIGNATURE-
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FTS1 or FTS2

[P Kishor]

On Wed, May 26, 2010 at 1:47 PM, Roger Binns  wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 05/26/2010 10:24 AM, Sam Carleton wrote:
>> If I do opt to use FTS, which one should I be using, FTS1 or FTS2?
>> According to the web site, it should be FTS1, correct?
>
> Just as a matter of interest what part of the web site led you to those
> conclusions?


heh, heh... the waybackmachineforsqlite.org perhaps


>
> Roger




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

Re: [sqlite] FTS1 or FTS2

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 05/26/2010 10:24 AM, Sam Carleton wrote:
> If I do opt to use FTS, which one should I be using, FTS1 or FTS2?
> According to the web site, it should be FTS1, correct?

Just as a matter of interest what part of the web site led you to those
conclusions?

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkv9bKcACgkQmOOfHg372QTINwCglr7//BHCgOt3vKApNZ8/EVYI
rcIAn1pYT57Rb/7zeyYGuEw+xyYVbxVG
=Imqe
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] FTS1 or FTS2

[Black, Michael (IS)]

Or to more directly answer the question...
 
select * from phone where number like '%56%';
 
 
Michael D. Black
Senior Scientist
Northrop Grumman Mission Systems
 



From: sqlite-users-boun...@sqlite.org on behalf of Simon Slavin
Sent: Wed 5/26/2010 12:25 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] FTS1 or FTS2




On 26 May 2010, at 6:24pm, Sam Carleton wrote:

> 212-456-7890
> 212-789-1234
> 212-564-9875
> 212-357-8452
> 212-285-6100
> 560-851-5522
>
> If searching for a number with '56', I want to get back: 212-4*56*-7890,
> 212-*56*4-9875, and *56*0-851-5522, NOT 212-28*5-6*100.  Is FTS the right
> answer or is there a quicker faster way?

You don't need FTS3.  See LIKE and GLOB in

<http://www.sqlite.org/lang_expr.html>

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


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

Re: [sqlite] FTS1 or FTS2

[Simon Slavin]

On 26 May 2010, at 6:24pm, Sam Carleton wrote:

> 212-456-7890
> 212-789-1234
> 212-564-9875
> 212-357-8452
> 212-285-6100
> 560-851-5522
> 
> If searching for a number with '56', I want to get back: 212-4*56*-7890,
> 212-*56*4-9875, and *56*0-851-5522, NOT 212-28*5-6*100.  Is FTS the right
> answer or is there a quicker faster way?

You don't need FTS3.  See LIKE and GLOB in



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