Re: [sqlite] Full text search without full phrase matches

2012-06-14 Thread Philip Bennefall
s that are similar. Kind regards, Philip Bennefall - Original Message - From: Black, Michael (IS) To: phi...@blastbay.com Sent: Thursday, June 14, 2012 9:34 PM Subject: Re: [sqlite] Full text search without full phrase matches Apache license is about as liberal as you can ge

Re: [sqlite] Full text search without full phrase matches

2012-06-14 Thread Philip Bennefall
From: Black, Michael (IS) To: phi...@blastbay.com ; General Discussion of SQLite Database Sent: Thursday, June 14, 2012 9:03 PM Subject: Re: [sqlite] Full text search without full phrase matches Sounds to me like you want Lucene instead of SQLite http://lucene.apache.org/core/ Mi

Re: [sqlite] Full text search without full phrase matches

2012-06-14 Thread Black, Michael (IS)
...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Philip Bennefall [phi...@blastbay.com] Sent: Thursday, June 14, 2012 1:32 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Full text search without full phrase matches Hi Simon, The ordering is not really the issue I am

Re: [sqlite] Full text search without full phrase matches

2012-06-14 Thread Simon Slavin
On 14 Jun 2012, at 7:32pm, Philip Bennefall wrote: > The problem is that it only returns a match if every single word is present. > I would like it to return matches if, say, mor than 2 or 3 of the specified > keywords are found. As far as I can figure, you need to write that function yoursel

Re: [sqlite] Full text search without full phrase matches

2012-06-14 Thread Philip Bennefall
gards, Philip Bennefall - Original Message - From: "Simon Slavin" To: "General Discussion of SQLite Database" Sent: Thursday, June 14, 2012 8:24 PM Subject: Re: [sqlite] Full text search without full phrase matches On 14 Jun 2012, at 7:13pm, Philip Bennefall wrote: T

Re: [sqlite] Full text search without full phrase matches

2012-06-14 Thread Simon Slavin
On 14 Jun 2012, at 7:13pm, Philip Bennefall wrote: > That is unfortunate, if it is true that there's no way to accomplish this > with SqLite. To do just plain matching I can use an unordered hash map, so I > wouldn't need a database for that. The trouble with a string distance > function is t

Re: [sqlite] Full text search without full phrase matches

2012-06-14 Thread Philip Bennefall
Sent: Thursday, June 14, 2012 7:24 PM Subject: Re: [sqlite] Full text search without full phrase matches On 14 Jun 2012, at 6:12pm, Philip Bennefall wrote: The trouble I have is that in my query, all the keywords don't necessarily have to be present in order for a successful match to be

Re: [sqlite] Full text search without full phrase matches

2012-06-14 Thread Simon Slavin
On 14 Jun 2012, at 6:12pm, Philip Bennefall wrote: > The trouble I have is that in my query, all the keywords don't necessarily > have to be present in order for a successful match to be made. SqLite's fts > only seems to match if all the keywords are present, which I don't require. You will

Re: [sqlite] Full text search without full phrase matches

2012-06-14 Thread Philip Bennefall
no match is made. 2. How well the ordering matched. Do you have any tips? Kind regards, Philip Bennefall - Original Message - From: To: Sent: Thursday, June 14, 2012 7:01 PM Subject: [sqlite] Full text search without full phrase matches I had to implement something like this fo

[sqlite] Full text search without full phrase matches

2012-06-14 Thread pcarb
-- Date: Wed, 13 Jun 2012 23:09:35 +0200 From: Philip Bennefall To: Subject: [sqlite] Full text search without full phrase matches Message-ID: Content-Type: text/plain; charset="iso-8859-1" Hi all, I am new to this maling list and to SqLite, so I wanted to start by thanki

[sqlite] Full text search without full phrase matches

2012-06-14 Thread pcarb
-- Date: Wed, 13 Jun 2012 23:09:35 +0200 From: Philip Bennefall To: Subject: [sqlite] Full text search without full phrase matches Message-ID: Content-Type: text/plain; charset="iso-8859-1" Hi all, I am new to this maling list and to SqLite, so I wanted to start by thanki

[sqlite] Full text search without full phrase matches

2012-06-13 Thread Philip Bennefall
Hi all, I am new to this maling list and to SqLite, so I wanted to start by thanking all of those who make this project a reality. It is a great tool. Now, to my question. I am trying to use the full text search feature to find rough matches for a chat robot. Basically I want to match as many k