[Gfoss] [SpatiaLite-Users] SQLite 3.6.10 +Spatialite as extension

Messaggio 'immorale': a volte essere pigri serve ...
[nel senso che prima o poi finisci per trovare
qualcun'altro che fa il lavoro al posto tuo :slight_smile: ]

finalmanete abbiamo la distribuzione di SpatiaLite per
Debian Lenny, grazie all'ottimo lavoro di Alexy Pechnikov

ciao,
Sandro Furieri

Alexey Pechnikov ha scritto:

I did build SQLite 3.6.10 with extensions (Spatialite,unicode support,
ipv4, compress,md5,uuid,env,tablefunc).

There is debian repository.

Debian etch:
deb http://mobigroup.ru/debian/ etch main contrib non-free
deb-src http://mobigroup.ru/debian/ etch main contrib non-free

Debian lenny:
deb http://mobigroup.ru/debian/ lenny main contrib non-free
deb-src http://mobigroup.ru/debian/ lenny main contrib non-free

Repository keyring can be installed as
sudo aptitude install debian-mobigroup-keyring

Usage example:

sqlite3 :memory:
sqlite> create virtual table test using VirtualText
(access.log,utf8,0,DOT,DOUBLEQUOTE,' ');
sqlite> pragma table_info(test);
cid|name|type|notnull|dflt_value|pk
0|ROWNO|INTEGER|0||0
1|COL001|TEXT|0||0
2|COL002|TEXT|0||0
3|COL003|TEXT|0||0
4|COL004|TEXT|0||0
5|COL005|TEXT|0||0
6|COL006|TEXT|0||0
7|COL007|TEXT|0||0
8|COL008|TEXT|0||0
9|COL009|TEXT|0||0
sqlite> select * from test limit 1;
ROWNO|COL001|COL002|COL003|COL004|COL005|COL006|COL007|COL008|COL009
1|195.98.38.96|-|-|[1234732034]|GET /ajax/messages.adp HTTP/1.0|200|
169|https://offline.mts.mobigroup.ru/extension/report_02/report.adp|
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "SpatiaLite Users" group.
To post to this group, send email to spatialite-users@googlegroups.com
To unsubscribe from this group, send email to spatialite-users+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/spatialite-users?hl=en
-~----------~----~----~----~------~----~------~--~---