You succeeded, Andrea;
On my winxp box
//========================
D:\bin>sqlite3.exe
SQLite version 3.8.6 2014-08-15 11:46:33
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> select load_extension ( 'libstringmetrics.dll' );
sqlite> select stringmetrics();
usage:
$ stringmetrics("<algoritm>","<kind of
output>","<string1>","<string2>","<tokenlist>")
Where <kind of output> is one of ("similarity", "metric", "phrase")
Where <tokenlist> is the list of char used as token. It is not used by all
the algoritms. The algorithms that use it are postfixed w
ith "custom". If it is omitted the list used is
"carriage return"
"newline (line feed)"
"horizontal tab"
"null character"
"no-break space"
"space"example:
select stringmetrics("block_distance","phrase","via giuseppe-garibaldi","via
giuseppe garibaldi",NULL);
vs
select stringmetrics("block_distance_custom","phrase","via
giuseppe-garibaldi","via giuseppe garibaldi","-");
Where <algoritm> is one of:
block_distance_custom
cosine
cosine_custom
dice
dice_custom
euclidean_distance
euclidean_distance_custom
jaccard
jaccard_custom
jaro
jaro_winkler
levenshtein
matching_coefficient
matching_coefficient_custom
monge_elkan
monge_elkan_custom
needleman_wunch
overlap_coefficient
overlap_coefficient_custom
qgrams_distance
qgrams_distance_custom
smith_waterman
smith_waterman_gotoh
soundex_phonetics
metaphone_phonetics
double_metaphone_phonetics
sqlite>
//========================
-dave
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Andrea Peri
> Sent: Sunday, September 28, 2014 3:53 AM
> To: Gert Van Assche; General Discussion of SQLite Database
> Subject: Re: [sqlite] A new extension for sqlite to analyze
> the stringmetrics
>
>
> You should use SQLite 32bit
> Il 28/set/2014 10:45 "Gert Van Assche" <[email protected]> ha scritto:
>
> > Thanks Andrea.
> > When I download the DLL I get exactly the same error.
> > I'm using the 32bit SQLite3.exe on a Win 64 bit machine.
> > Could that cause the error?
> >
> > thanks
> >
> > gert
> >
> > 2014-09-27 20:27 GMT+02:00 Andrea Peri <[email protected]>:
> >
> >> https://github.com/aperi2007/libstringmetrics
> >>
> >>
> >> >Andrea, where do I find it?
> >> >
> >> >thanks
> >> >
> >> >gert
> >>
> >>
> >>
> >> --
> >> -----------------
> >> Andrea Peri
> >> . . . . . . . . .
> >> qwerty àèìòù
> >> -----------------
> >>
> >
> >
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
