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

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

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

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. Clucen

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

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/ http:/

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

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 ema

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

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

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

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 t

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

lite.org Subject: Re: [sqlite] Does 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: >>

Re: [sqlite] Does 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%'; SQLite also makes it easy to write you

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

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?

> 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: > &g

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 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%';

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

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.