[Geotools-devel] improving support for spatialite

[Justin D. <jde...@op...>]

Hi all,

Over the weekend I decided to spent some time on long outstanding todo
item, improving our spatialite support. I just pushed some changes which I
hope will allow the driver to be more easily used and on more platforms.
Basically to sum up the work:

* I updated the sqlitejdbc driver to include spatialite on all of its
supported platforms which are 32/64 bit on windows, linux, and osx (intel
macs). With the caveat that the windows 64 bit DLL's are not actually
compiled for 64 bit. But tested the 32-bit DLL's and they seem to work
fine.

Unfortunately my changes to the sqlitejdbc are pretty custom and i have had
a few problems getting the changes in to the core. I am currently hosting
the changes in a forked repo on bitbucket.

      https://bitbucket.org/jdeolive/sqlite-jdbc

I hope to try again soon with the sqlitejdbc maintainer to see how i can
clean up the changes to get them more supported in the core. But for now
though I may just maintain my fork and track the major versions of the
driver.

* I updated the user docs to better explain how to configure the system and
java to properly load all the libs.


http://docs.geotools.org/latest/userguide/library/jdbc/spatiallite.html

* I have posted pre-compiled proj and geos libs for all the supported
platforms containing the same versions that spatialite/sqlite
was compiled against.

      http://gridlock.opengeo.org/geotools/spatialite-libs-linux-x86.zip
      http://gridlock.opengeo.org/geotools/spatialite-libs-linux-x86_64.zip
      http://gridlock.opengeo.org/geotools/spatialite-libs-osx-intel.zip
      http://gridlock.opengeo.org/geotools/spatialite-libs-win-x86.zip

Just hosting them on opengeo servers for now but eventually we should move
them to sourceforge or something. It would be good to get a sanity check on
them though before that.

* Some minor improvements to the spatialite dialect itself, such as WKB
support, etc...

It would be great if other devs could take it for a test drive and attempt
to run the unit tests. I added a readme to the module that describes how to
run the tests:


https://github.com/geotools/geotools/blob/master/modules/plugin/jdbc/jdbc-spatialite/README.txt#L31


Once I can get confirmation of others having some success i hope to
backport the changes to the stable branch as well.

-Justin

-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.