Re: [sqlite] Still trying to track down loadable extensions

2014-02-24 Thread a . furieri 

On Mon, 24 Feb 2014 00:43:40 +0200, Alek Paunov wrote:

Just in case if Alessandro Furieri do not follow the list closely



Hi Alek,

I can simply add few more details to your already excellent
introduction.
SpatiaLite is a loadable extension adding standard Spatial SQL
capabilities to the SQLite's basic core.
It's almost conformant to OGC-SFS [1] 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
statements.

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.

bye Sandro

[1] http://portal.opengeospatial.org/files/?artifact_id=25355


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Still trying to track down loadable extensions

2014-02-23 Thread Alek Paunov 

On 21.02.2014 02:05, Nico Williams wrote:

https://github.com/slightfoot/sqlite3-extensions
https://github.com/salviati/sqlite3-lz4
https://github.com/ralight/sqlite3-pcre
http://sqlite.mobigroup.ru/wiki?name=extensions
http://sqlite.mobigroup.ru/wiki?name=utils
https://github.com/djodjo/sqlite3ext_parse_json
https://github.com/fnoyanisi/sqlite3_capi_extensions
https://github.com/mrwilson/squib
https://github.com/evsukov89/SQLiteFuzzySearch
https://sites.google.com/site/lserinol/sqlitecompress
ftp://ftp.freebsd.org/pub/FreeBSD/ports/local-distfiles/glarkin/extension-functions-1.0.c
http://sqlcipher.net/design/
http://sourceforge.net/projects/sqlite-undo/
http://schplurtz.free.fr/wiki/schplurtziel/sqlite3-ipv4-ext
https://bitbucket.org/luciad/libgpkg
https://www.linux.com/news/software/developer/8010-libferris-and-sqlite-a-powerful-combination-part-2


Just in case if Alessandro Furieri do not follow the list closely, 
several of the spatialite project provided addons:


Spatial functionality (+extras: math functions, libxml2/VirtualXPath 
table, MS XLS Virtual table):

https://www.gaia-gis.it/fossil/libspatialite/index
http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.1.0.html
https://www.gaia-gis.it/fossil/freexl/index

PostgreSQL interface:
https://www.gaia-gis.it/fossil/virtualpg/index

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Still trying to track down loadable extensions

2014-02-23 Thread Alek Paunov 

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 [1].


Alek

[1] https://groups.google.com/forum/#!topic/sqlite-dev/icj60Bc5Lt0

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Still trying to track down loadable extensions

2014-02-20 Thread Nico Williams 
On Thu, Feb 20, 2014 at 5:19 PM, Peter Haworth  wrote:
> I know nothing about git so can someone please point me in the right
> direction to find these loadable extensions.

SQLite3 is version controlled with Fossil anyways, not git...

Besides the ones that SQLite3 comes with (see D.R. Hipp's responses)

The great search engines find lots of third-party SQLite3 extensions.
Here's a few results, barely skimmed by myself, in no particular
order, nor any endorsement from me:

https://github.com/slightfoot/sqlite3-extensions
https://github.com/salviati/sqlite3-lz4
https://github.com/ralight/sqlite3-pcre
http://sqlite.mobigroup.ru/wiki?name=extensions
http://sqlite.mobigroup.ru/wiki?name=utils
https://github.com/djodjo/sqlite3ext_parse_json
https://github.com/fnoyanisi/sqlite3_capi_extensions
https://github.com/mrwilson/squib
https://github.com/evsukov89/SQLiteFuzzySearch
https://sites.google.com/site/lserinol/sqlitecompress
ftp://ftp.freebsd.org/pub/FreeBSD/ports/local-distfiles/glarkin/extension-functions-1.0.c
http://sqlcipher.net/design/
http://sourceforge.net/projects/sqlite-undo/
http://schplurtz.free.fr/wiki/schplurtziel/sqlite3-ipv4-ext
https://bitbucket.org/luciad/libgpkg
https://www.linux.com/news/software/developer/8010-libferris-and-sqlite-a-powerful-combination-part-2
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Still trying to track down loadable extensions

2014-02-20 Thread Richard Hipp 
On Thu, Feb 20, 2014 at 6:19 PM, Peter Haworth  wrote:

> I'm still hunting for loadable extensions.
>

In the ext/ folder, and especially in ext/misc/

http://www.sqlite.org/src/tree?name=ext/misc=trunk

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Still trying to track down loadable extensions

2014-02-20 Thread Peter Haworth 
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.

Thanks,

Pete
lcSQL Software 
Home of lcStackBrowser  and
SQLiteAdmin 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users