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

Alessandro Furieri a.furieri a lqt.it
Lun 16 Feb 2009 10:23:10 CET


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 :-) ]

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 a googlegroups.com
> To unsubscribe from this group, send email to spatialite-users+unsubscribe a googlegroups.com
> For more options, visit this group at http://groups.google.com/group/spatialite-users?hl=en
> -~----------~----~----~----~------~----~------~--~---
>
>   


Maggiori informazioni sulla lista Gfoss