On 2014-10-09, 11:09 AM, Dan Kennedy wrote:
On 10/09/2014 07:23 PM, Sohail Somani wrote:
On 2014-10-09, 7:32 AM, Dan Kennedy wrote:
Got it, thanks for the explanation. Just to make sure that I
understand you correctly, is the clause MATCH '*l0l* *h4x*' getting
translated to MATCH 'l0l* h4x*'?
On 10/09/2014 07:23 PM, Sohail Somani wrote:
On 2014-10-09, 7:32 AM, Dan Kennedy wrote:
Got it, thanks for the explanation. Just to make sure that I
understand you correctly, is the clause MATCH '*l0l* *h4x*' getting
translated to MATCH 'l0l* h4x*'?
Yes, that's right.
Dan.
In that case, sho
On 2014-10-09, 7:32 AM, Dan Kennedy wrote:
Got it, thanks for the explanation. Just to make sure that I
understand you correctly, is the clause MATCH '*l0l* *h4x*' getting
translated to MATCH 'l0l* h4x*'?
Yes, that's right.
Dan.
In that case, shouldn't the test in the original post have retu
On 10/09/2014 01:13 AM, Sohail Somani wrote:
On 2014-10-07, 4:04 PM, Dan Kennedy wrote:
On 10/08/2014 01:52 AM, Sohail Somani wrote:
Figured it out: match terms should be "l0l* h4x*" NOT "*l0l* *h4x*",
though it did work as expected with the older version. I'd suggest
keeping the old behaviour
On 2014-10-07, 4:04 PM, Dan Kennedy wrote:
On 10/08/2014 01:52 AM, Sohail Somani wrote:
Figured it out: match terms should be "l0l* h4x*" NOT "*l0l* *h4x*",
though it did work as expected with the older version. I'd suggest
keeping the old behaviour unless there is a performance-based reason
not
On 10/08/2014 01:52 AM, Sohail Somani wrote:
Figured it out: match terms should be "l0l* h4x*" NOT "*l0l* *h4x*",
though it did work as expected with the older version. I'd suggest
keeping the old behaviour unless there is a performance-based reason
not to.
On 2014-10-07, 2:49 PM, Sohail Soma
Figured it out: match terms should be "l0l* h4x*" NOT "*l0l* *h4x*",
though it did work as expected with the older version. I'd suggest
keeping the old behaviour unless there is a performance-based reason not to.
On 2014-10-07, 2:49 PM, Sohail Somani wrote:
SELECT COUNT(*) FROM t_fts WHERE t_f
$ ./bin/sqlite3 --version
3.7.17 2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668
$ ./bin/sqlite3 -batch < /tmp/test.sql
--- 1 ---
0
--- 2 ---
1
$ ./bin/sqlite3 --version
3.8.7 2014-09-30 19:04:41 5ce05757aac80b99c3b2141cd301809f8e28e661
/bin/sqlite3 -batch < /tmp/test.sql
--- 1 ---
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
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
...@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
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
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
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
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
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
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
--
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
--
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
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
Hi,
Thanks for help.
Sumesh.
On Sat, Mar 26, 2011 at 1:48 PM, Dan Kennedy wrote:
> On 03/26/2011 02:18 PM, Sumesh KS wrote:
>> Hi,
>>
>> I am Sumesh, student from india. I currently doing a project using qt
>> and sqlite. I want to implement Full Text Search in that project.
>> Anyone please te
On 03/26/2011 02:18 PM, Sumesh KS wrote:
> Hi,
>
> I am Sumesh, student from india. I currently doing a project using qt
> and sqlite. I want to implement Full Text Search in that project.
> Anyone please tell me, from where i start to learn FTS and it's
> working and how it is implemented.
htt
Hi,
I am Sumesh, student from india. I currently doing a project using qt
and sqlite. I want to implement Full Text Search in that project.
Anyone please tell me, from where i start to learn FTS and it's
working and how it is implemented.
regards,
Sumesh.
Take a look at the custom tokenizer API. I think tokens returned don't
necessarily have to be substrings of the text. So, maybe the text you
"tokenize" could be the file path, but the tokens could be things you
pull from the contents of the file.
Just a thought,
Cheers,
Sam
___
On Sun, Oct 17, 2010 at 11:13 PM, Dami Laurent (PJ)
wrote:
>>Is it possible to use FTS3 for search without storing the actual file
>>contents/search terms/keywords in a row. In other words, create a FTS3
>>tables with rows that only contains an ID and populate the B-Tree with
>>keywords for search
>Is it possible to use FTS3 for search without storing the actual file
>contents/search terms/keywords in a row. In other words, create a FTS3
>tables with rows that only contains an ID and populate the B-Tree with
>keywords for search.
>
Each FTS3 table t is stored internally within three regular
On Sun, Oct 17, 2010 at 11:54 PM, pipilu wrote:
>
> My question is:
> Is it possible to use FTS3 for search without storing the actual file
> contents/search terms/keywords in a row. In other words, create a FTS3
> tables with rows that only contains an ID and populate the B-Tree with
> keywords
On Sun, Oct 17, 2010 at 2:54 PM, pipilu wrote:
> Hi:
> I am trying to build a sqlite3 database to index files. What I want to do is
> to keep the files in the file system on the disk (not in the database) and
> index the files with keywords such that when a search is performed, the
> right file na
Hi:
I am trying to build a sqlite3 database to index files. What I want to do is
to keep the files in the file system on the disk (not in the database) and
index the files with keywords such that when a search is performed, the
right file names are returned.
My question is:
Is it possible to use F
Hi, Newbie on SQLite here.
I also have the same problem on how to do a ranking on FTS3 but no clue.
And I found that you use a function call score() that do sorting. But it is
not found in SQLite doc.
So, can you please tell me how can I get this function or, can you please
tell me what is the
On 6/10/07, Mark Gilbert <[EMAIL PROTECTED]> wrote:
I have just started learning about Full Text search in SQlite, and I
have some questions
Sorry for the delayed response, I just noticed this email waiting for
an answer, and nobody has ...
1) With the Amalgamated Sqlite, I guess to enable F
Folks.
I have just started learning about Full Text search in SQlite, and I
have some questions
1) With the Amalgamated Sqlite, I guess to enable FTS I just #define
SQLITE_ENABLE_FTS2 at the start of sqlite3.c
Is there anything else I have to do to switch it on ?
2) If I want to do a full
Martin Pfeifle <[EMAIL PROTECTED]> wrote:
> Dear all,
> I have just seen that there are some thoughts going on to incorporate full
> text search into SQLite.
> http://www.sqlite.org/cvstrac/wiki/wiki?p=FullTextIndex
> What is the current status on that project?
Work on this is progressing. It a
Dear all,
I have just seen that there are some thoughts going on to incorporate full
text search into SQLite.
http://www.sqlite.org/cvstrac/wiki/wiki?p=FullTextIndex
What is the current status on that project?
On Thu, 12 Aug 2004, Pavel wrote:
> MS> There are some modules on CPAN which provide generic full text search
> MS> backed on any RDBMS. Try http://search.cpan.org/
>
> CPAN was my first search, only was I found was DBIx::FullTextSearch
> that require MySQL and DBIx::TextIndex that search in BLOB
Hello Matt,
Thursday, August 12, 2004, 12:02:04 AM, you wrote:
MS> On Wed, 11 Aug 2004, Pavel wrote:
>> Hello sqlite-users,
>>
>> Fri, 16 Jan 2004 Steve O'Hara wrote:
>>
>> > I was developing my FT engine to run from a CD so I wasn't interested in
>> > keeping my inverted index up to date af
Hello sqlite-users,
Fri, 16 Jan 2004 Steve O'Hara wrote:
> I was developing my FT engine to run from a CD so I wasn't interested in
> keeping my inverted index up to date after deletions/updates to the main
> table. When you add this in too, the heap of code neccersary to implement
> this with
> -Original Message-
> From: Bertrand Mansion [mailto:[EMAIL PROTECTED]
> Sent: 16 January 2004 19:18
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [sqlite] Full text search implementation
>
>
> <[EMAIL PROTECTED]> wrote :
>
> >
> &
<[EMAIL PROTECTED]> wrote :
>
>
>> -Original Message-
>> From: David Morel [mailto:[EMAIL PROTECTED]
>> Sent: 16 January 2004 17:32
>> To: Brad Campbell
>> Cc: George Ionescu; [EMAIL PROTECTED]
>> Subject: Re: [sqlite] Full text search imp
> -Original Message-
> From: David Morel [mailto:[EMAIL PROTECTED]
> Sent: 16 January 2004 17:32
> To: Brad Campbell
> Cc: George Ionescu; [EMAIL PROTECTED]
> Subject: Re: [sqlite] Full text search implementation
>
>
> > My regex patch should do that
&g
David Morel wrote:
My regex patch should do that
SELECT * FROM Categories WHERE CategoryDescription RLIKE 'Beverages" and CategoryDescription NOT
RLIKE 'Whiskey';
In such a simple string matching I suspect a regex search is totally
overkill... that's ok for a db containing 1000 rows, but try i
> My regex patch should do that
>
> SELECT * FROM Categories WHERE CategoryDescription RLIKE 'Beverages" and
> CategoryDescription NOT
> RLIKE 'Whiskey';
>
In such a simple string matching I suspect a regex search is totally
overkill... that's ok for a db containing 1000 rows, but try it on
70
Le ven 16/01/2004 à 15:30, George Ionescu a écrit :
> I've been using sqlite for quite some time now and I am a fan (thank you Dr.
> Hipp).
so am I
> Regarding Full Text Search syntax, I think CONTAINS statement would be ok
> (as implemented in other database engines).
> So:
> SELECT * FROM C
George Ionescu wrote:
Hello dear SQLite users.
Hello Dr. Hipp,
I've been using sqlite for quite some time now and I am a fan (thank you Dr.
Hipp).
I will try to rewrite my (unfinished) Document Management application using
SQLite and I was wondering if Full Text Search will be implemented.
I'vee se
Hello dear SQLite users.
Hello Dr. Hipp,
I've been using sqlite for quite some time now and I am a fan (thank you Dr.
Hipp).
I will try to rewrite my (unfinished) Document Management application using
SQLite and I was wondering if Full Text Search will be implemented.
I'vee seen a ticket posted
45 matches
Mail list logo
