[sqlite] Libstringmetrics

2015-03-11 Thread aperi2007
ithub.com/aperi2007/libstringmetrics . For example: > When I use "similarity" in qgrams_distance, I get good results. But > when I use "metric", it works only if it is only once in the query. > When there are 2 different usages, they somehow interfere together. Is >

Re: [sqlite] A new extension for sqlite to analyze the stringmetrics

2014-09-28 Thread aperi2007
Hi Keith, thx for hints. I have apply all of them. The only one I like to explain: I know the warning for the void insted of int declaration of stringmetricsFunc. But if I put it as "int" I had a warning in the create_function that want a void function. So I preferred to maintain the warning

Re: [sqlite] The execute command

2014-04-17 Thread aperi2007
value (1/0 - successful/unsuccesful). Many thx, Andrea Peri. On 17/04/2014 20:47, Richard Hipp wrote: On Thu, Apr 17, 2014 at 2:43 PM, aperi2007 <mailto:aperi2...@gmail.com>> wrote: Hi to all, There is in sqlite a command to run a query build at runtime ? Not built-in. B

[sqlite] The execute command

2014-04-17 Thread aperi2007
Hi to all, There is in sqlite a command to run a query build at runtime ? Our use-case is a list of query build from a sql script and stored in a table. something like this: select EXECUTE([field_query]) from table1; where "table1" is the table and "field1" is the field where the builded q