The main issue I have is that the Apache license, as well as the gpl/lgpl
licenses, force you to include the entire license with any redistribution of
the software (even if it is compiled as part of a derivative work) if my
understanding is correct. I am not too keen on doing that. I certainly don't
mind giving credit where credit is due, but I don't want to include this huge
blob of legal text. This is why I like public domain software so much, as well
as software distributed under licenses such as the Boost Software license, the
Zlib/Libpng license and one or two others 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 get. Damned near public domain
(may as well be for all intents and purposes).
Muy I ask what the problem is? Perhaps something I should aware of?
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
------------------------------------------------------------------------------
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Philip Bennefall [phi...@blastbay.com]
Sent: Thursday, June 14, 2012 2:09 PM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Full text search without full phrase matches
Hi Michael,
That seems to be under either gpl/lgpl/apache licenses, which I cannot use in
my project for various reasons. The reason I am so interested in SqLite is
because it's public domain. I appreciate the tip though.
Kind regards,
Philip Bennefall
----- Original Message -----
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/
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
------------------------------------------------------------------------------
From: sqlite-users-boun...@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 having. That, I can do if I just
get a result back that doesn't necessarily match all the keywords. In the
query you showed as an example, all the keywords would still have to match
in order for a row to be returned. The sorting is a separate problem that
is
not really that difficult once I get a smaller dataset. Then I can order it
manually. 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.
Kind regards,
Philip Bennefall
----- Original Message -----
From: "Simon Slavin" <slav...@bigfraud.org>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
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 <phi...@blastbay.com> 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 that I can't really process the entire dataset with it.
SqLite
> technically has all the features I'm after, I just don't want it to
> necessarily match all the words in a query. If I can get it to match all
> as well as some, that would be enough. I could then do distancing on a
> considerably smaller dataset which would be the result of the broader
> SqLite search.
>
> So I guess my main question is, is there absolutely no way to match a
> subset of the words in a query?
Well, you could write that string distance function and add it to your copy
of SQLite as an external function. Then you could do things like
SELECT string_distance(theText, 'this new piece of text'), theText FROM
oldChats WHERE string_distance(theText, 'this new piece of text') < 10
ORDER
BY string_distance(theText, 'this new piece of text')
(I don't know whether SQLite will optimise that to avoid executing the same
function many times, or whether you can name a column and use that name to
do the same thing yourself.)
Here's the documentation for external functions:
<http://www.sqlite.org/c3ref/create_function.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
_______________________________________________
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
