Re: [sqlite] Does SQLite have a fulltext search like MySQL?

2005-07-12 Thread Siddharth Vijayakrishnan
On 7/11/05, Henry Miller [EMAIL PROTECTED] wrote: For full text search I find the lucene/clucene http://lucene.apache.org/ http://sourceforge.net/projects/clucene/ to be good solutions. The licenses isn't quite as easy as sqlite, but they should be good enough for everyone. Clucene is

Re: [sqlite] Does SQLite have a fulltext search like MySQL?

2005-07-12 Thread Lothar Märkle
On Tue, Jul 12, 2005 at 01:26:19PM +0530, Siddharth Vijayakrishnan wrote: On 7/11/05, Henry Miller [EMAIL PROTECTED] wrote: For full text search I find the lucene/clucene http://lucene.apache.org/ http://sourceforge.net/projects/clucene/ to be good solutions. The licenses isn't quite

Re: [sqlite] Does SQLite have a fulltext search like MySQL?

2005-07-11 Thread Henry Miller
On 7/5/2005 at 17:48 Michael Grice wrote: If not, are there plans to add this? I'm just a NOOB, looking to see what all SQLite can do for me, before I go too far down this road. I was on vacation last week... For full text search I find the lucene/clucene http://lucene.apache.org/

RE: [sqlite] Does SQLite have a fulltext search like MySQL?

2005-07-06 Thread Steve O'Hara
SQLite have a fulltext search like MySQL? look at the glob command it works like like except uses the unix file name globbing style of matching not quite a grep select * from table where a glob '[abc]foobar*'; At 06:47 PM 7/5/2005, you wrote: like this? select * from table where a like '%abc

Re: [sqlite] Does SQLite have a fulltext search like MySQL?

2005-07-06 Thread Jay Sprenkle
On 7/6/05, Steve O'Hara [EMAIL PROTECTED] wrote: SQLite doesn't have a free text search capability - the Like and Glob functions are not free text just simple pattern matching on the scanned text. Performance is very poor because there is no suitable index. It's not a simple task to

RE: [sqlite] Does SQLite have a fulltext search like MySQL?

2005-07-06 Thread Steve O'Hara
It's written in C already... MS VS 6 Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] rg]On Behalf Of Jay Sprenkle Sent: 06 July 2005 16:31 To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: Re: [sqlite] Does SQLite have a fulltext search like MySQL

Re: [sqlite] Does SQLite have a fulltext search like MySQL?

2005-07-06 Thread Matt Sergeant
On 5 Jul 2005, at 17:48, Michael Grice wrote: If not, are there plans to add this? What language are you planning to use? Perl has a bunch of full text search modules that implement FTS on top of any DB. Matt. __ This

Re: [sqlite] Does SQLite have a fulltext search like MySQL?

2005-07-05 Thread Stephen Leaf
On Tuesday 05 July 2005 04:48 pm, Michael Grice wrote: If not, are there plans to add this? I'm just a NOOB, looking to see what all SQLite can do for me, before I go too far down this road. Thx. like this? select * from table where a like '%abc%';

Re: [sqlite] Does SQLite have a fulltext search like MySQL?

2005-07-05 Thread Kurt Welgehausen
From: Stephen Leaf [EMAIL PROTECTED] Organization: SMiLeaf To: sqlite-users@sqlite.org Date: Tue, 5 Jul 2005 18:06:39 -0500 Subject: Re: [sqlite] Does SQLite have a fulltext search like MySQL? On Tuesday 05 July 2005 04:48 pm, Michael Grice wrote: If not, are there plans to add

Re: [sqlite] Does SQLite have a fulltext search like MySQL?

2005-07-05 Thread Roger Binns
like this? select * from table where a like '%abc%'; SQLite also makes it easy to write your own functions. That way you can define other matching algorithms (eg Jaro-Winkler). Roger

Re: [sqlite] Does SQLite have a fulltext search like MySQL?

2005-07-05 Thread Jim Dodgen
look at the glob command it works like like except uses the unix file name globbing style of matching not quite a grep select * from table where a glob '[abc]foobar*'; At 06:47 PM 7/5/2005, you wrote: like this? select * from table where a like '%abc%'; SQLite also makes it easy to write