I'm still hunting for loadable extensions. The SQLite web site makes
reference to extensions being part of the source code in the contrib folder
but when I browser around there, I can only see 2 files dlmalloc and sqlcon.
I know nothing about git so can someone please point me in the right
direction to find these loadable extensions.
On 21.02.2014 01:19, Peter Haworth wrote:
> I'm still hunting for loadable extensions. The SQLite web site makes
> reference to extensions being part of the source code in the contrib folder
> but when I browser around there, I can only see 2 files dlmalloc and sqlcon.
I see that you are supporting non-FOSS software based on SQLite. What is
your goal - to include as much as possible extensions in your software
or to start cataloging initiative in the service of community?
If the latter, you can contact James K. Lowden, who was about to
sort-out something in this direction an year ago .
Re: Still trying to track down loadable extensions
On Mon, 24 Feb 2014 00:43:40 +0200, Alek Paunov wrote:
> Just in case if Alessandro Furieri do not follow the list closely
I can simply add few more details to your already excellent
SpatiaLite is a loadable extension adding standard Spatial SQL
capabilities to the SQLite's basic core.
It's almost conformant to OGC-SFS  and ISO SQL/MM-Spatial
international standards for Spatial DBMSes and Spatial SQL;
roughly speaking it offers a sound and powerful light-weight
alternative to the much more complex PostgreSQL/PostGIS
client-server Spatial DBMS.
It's certainly interesting to note that SpatiaLite has
been successfully ported on Android and other mobile
or embedded devices.
directly included in SpatiaLite are several Virtual Tables
implementing the following features:
- VirtualText: direct read access by SQL to external CSV
and structured text files
- VirtualDbf: direct read access by SQL to external DBF files
- VirtualXls: direct read access by SQL to external MS XLS
spreadsheets (old Excel binary format)
- VirtualShape: direct read access by SQL to external ESRI
Shapefiles (the de facto standard exchange format for
Geographic vector data)
- VirtualSpatialIndex: full fledged Spatial Index support
based on R*Trees
- VirtualNetwork: pure SQL Routing based on a road
network (aka graph) [Dijkstra's Shortest Path]
- VirtualXPath: standard XML Path Language
a further self-standing loadable extension closely related to
SpatiaLite is VirtualPG, allowing to establish a client
connection to a PostgreSQL/PostGIS server and then supporting
direct data exchange between the two DBMSes by standard SQL
both SpatiaLite and VirtualPG are released under the MPL
"tri-licence"; you can freely choose you best fit license
between the GPL, LGPL or the MPL itself.