[sqlite] How change the tmp vacuum temporary files

2016-02-01 Thread Andrea Peri
variable could not always be set, so the default path became the /var/tmp instead of the /tmp. A. 2016-02-01 10:46 GMT+01:00 Clemens Ladisch : > Andrea Peri wrote: >> After some searches, I found the trouble is due to the vacuum command >> that is going to use >> the /var/tmp

[sqlite] How change the tmp vacuum temporary files

2016-02-01 Thread Andrea Peri
in the documentation ? Thanks, Andrea Peri -- - Andrea Peri . . . . . . . . . qwerty ? -

[sqlite] CSV excel import

2015-08-01 Thread Andrea Peri
Toimport a text into a sqlite: this link could be useful: http://www.gaia-gis.it/gaia-sins/spatialite-tutorial-2.3.1.html CREATE VIRTUAL TABLE books USING VirtualText(books.txt, CP1252, 1, COMMA, DOUBLEQUOTE, ','); Regards, A. 2015-08-01 11:43 GMT+02:00 Andrea Peri : > Hi, > to impor

[sqlite] CSV excel import

2015-08-01 Thread Andrea Peri
port. It would really great if this could be > addressed. > > Best regards, > Sylvain > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinf

[sqlite] Libstringmetrics

2015-03-12 Thread Andrea Peri
oops, sorry for wrong typo. "Hi Milan," is the correct. :) Again, A. 2015-03-12 9:08 GMT+01:00 Andrea Peri : > Hi Lina, > > I tested your patch and it resolve the crash. > > I submit the patch in the master and generate a new dll for windows. > > Thx for patchin

[sqlite] Libstringmetrics

2015-03-12 Thread Andrea Peri
Hi Lina, I tested your patch and it resolve the crash. I submit the patch in the master and generate a new dll for windows. Thx for patching. A. 2015-03-12 8:48 GMT+01:00 Andrea Peri : > Of course. > Thx for report and patch. > > However I will contact the original author of th

[sqlite] Libstringmetrics

2015-03-12 Thread Andrea Peri
lastname ) a, > (select "Milan" as firstname, "RoubalRoubalRoubalRo" as lastname ) b > ; >...>...> ...> ...>...>...> > Milan|Milan|Roubal|RoubalRoubalRoubalRo|40.0|100.0 > >Thank you >Best Regards >Milan >> >> ___ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > -- - Andrea Peri . . . . . . . . . qwerty ? -

[sqlite] Libstringmetrics

2015-03-12 Thread Andrea Peri
y code >> or in the original code of the symmetrics library. >> >> I try to resolve this firstly question when and if I find a few of time. >> >> However patches are welcomes. >> :) >> >> Regards, >> >> Andrea Peri. >> >>

Re: [sqlite] SQLite as a meta database

2014-11-06 Thread Andrea Peri
SQLite allow to attach more database at session level. Perhaps here you could find a solution Il 06/nov/2014 09:31 "Hugo Mercier" ha scritto: > Le 05/11/2014 23:08, Simon Slavin a écrit : > > > > On 5 Nov 2014, at 9:28pm, Edward Lau wrote: > > > >>

Re: [sqlite] Finding second occurrence of character in string

2014-10-26 Thread Andrea Peri
earch, or which occurrence to search for > (1st, 2nd, etc.) > > -- > ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/

Re: [sqlite] Make a database read-only?

2014-10-14 Thread Andrea Peri
Against legal. The best approach is to calculate the MD5 of the file If the file chance, the MD5 change Aldo. Il 14/ott/2014 15:37 "RSmith" ha scritto: > > On 2014/10/14 13:48, Ross Altman wrote: > >> Hi Martin, >> >> Thank you, I'll definitely look into that. It's

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

2014-09-28 Thread Andrea Peri
thanks > > gert > > 2014-09-27 20:27 GMT+02:00 Andrea Peri <aperi2...@gmail.com>: > >> https://github.com/aperi2007/libstringmetrics >> >> >> >Andrea, where do I find it? >> > >> >thanks &

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

2014-09-27 Thread Andrea Peri
https://github.com/aperi2007/libstringmetrics >Andrea, where do I find it? > >thanks > >gert -- --------- Andrea Peri . . . . . . . . . qwerty àèìòù - ___ sqlite-users mailing list sqlite-users@sqlite.org ht

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

2014-09-27 Thread Andrea Peri
Hi, I commit the new extension with the runtime statically liked. I test it on a clean machine and seem work. The extension is compiled on 32bit. So need a sqlite 32bit to work. I guess it should not work with a 64bit sqlite shell. Regards, A. 2014-09-26 17:38 GMT+02:00 Andrea Peri <ape

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

2014-09-26 Thread Andrea Peri
th minw and need some other lib to have a true static-linkage. I try to resolve in this week-end. Andrea -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ sqlite-users mailing list sqlite-users@sqlite.org http://

[sqlite] A new extension for sqlite to analyze the string metrics

2014-09-25 Thread Andrea Peri
s.dll"); The extension add One new command: stringmetrics(). calling it without any parameters will return a simple help of the parameters and of the available algorithms. Regards, -- ----- Andrea Peri . . . . . . . . . qw

Re: [sqlite] How preserve the string metric in an extension.

2014-09-20 Thread Andrea Peri
algoritm is used to transform to and from. So I have not any information to understand is the bug is in my code or in the sqlite code. Starting from the response of Richard I study the code and see where was the bug and resolve it. Greetings, A. -- - Andrea Peri

Re: [sqlite] How preserve the string metric in an extension.

2014-09-19 Thread Andrea Peri
e: "P^. " Instead If I use this other printf("%s",sqlite3_value_text(argv[0])); I have correctly "aaa" I don't understand why this difference so my only explanation was that the sqlite was changing. A. 2014-09-19 22:25 GMT+02:00 Richard Hipp <d...@sqlite.org

[sqlite] How preserve the string metric in an extension.

2014-09-19 Thread Andrea Peri
(..) Is this possible ? And there is an alternative approach to avoid to use the sqlite3_value_text(...) ? Thx, -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] Dump a memory DB

2012-10-31 Thread Andrea Peri
Hi, >From the sqlite3 console, is possible to dump on disk a memory DB ? Thx, -- ----- Andrea Peri . . . . . . . . . qwerty àèìòù - ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-

[sqlite] Alter table constraint question

2012-09-09 Thread Andrea Peri
lter table drop constraint ... is a technology choose. and how much complex could be to add both to the sqlite sql. Thx, Andrea -- ----- Andrea Peri . . . . . . . . . qwerty àèìòù - ___ sqlite-users mailing list sqlite-users@