[JPP-Devel] SVN: [5489] core/trunk

2017-08-11 Thread jump-pilot-svn--- via Jump-pilot-devel
Revision: 5489 http://sourceforge.net/p/jump-pilot/code/5489 Author: elnico Date: 2017-08-11 10:38:28 + (Fri, 11 Aug 2017) Log Message: --- Spatial Index support for SQLite/Spatialte datasources: quotes identifiers when generating SQL queries Modified Paths:

Re: [JPP-Devel] Requst to update SQLite driver

2017-08-11 Thread edgar . soldin
done in r5488.. ede On 8/11/2017 9:22, Rahkonen Jukka (MML) wrote: > Hi, > > For getting even more speed for BBOX queries which utilize spatial index of > GeoPackage and Spatialite databases it would be good to update the SQLite > driver that is delivered with OpenJUJMP Plus. The version we

[JPP-Devel] SVN: [5488] core/trunk

2017-08-11 Thread jump-pilot-svn--- via Jump-pilot-devel
Revision: 5488 http://sourceforge.net/p/jump-pilot/code/5488 Author: edso Date: 2017-08-11 07:54:41 + (Fri, 11 Aug 2017) Log Message: --- update to latest sqlite jdbc Modified Paths: -- core/trunk/ChangeLog Added Paths: ---

[JPP-Devel] Requst to update SQLite driver

2017-08-11 Thread Rahkonen Jukka (MML)
Hi, For getting even more speed for BBOX queries which utilize spatial index of GeoPackage and Spatialite databases it would be good to update the SQLite driver that is delivered with OpenJUJMP Plus. The version we use now is sqlite-jdbc-3.8.11.2.jar but starting from version 3.17 the R-Tree

[JPP-Devel] Good news about GeoPackage and SpatiaLite and spatial index

2017-08-11 Thread Rahkonen Jukka (MML)
Hi, Nicolas Ribot has kindly improved the SQLite based datastores so that the R-Tree spatial index is utilized if it exists for GeoPackages. This makes a huge speedup for dynamic browsing of GeoPackage layers which are added to the map through Open Datastore Layer. The same speedup is