Re: [JPP-Devel] Jump DB Query Plugin now supports Spatialite

2010-02-04 Thread Martin Davis
> > I also prefer pure-java to mixed java/binary, but SQLite apparently > has a large and growing mindshare. For instance, the latest version > of ogr/gdal supports pushing spatial data directly into a SQLite > database. I tend to view SQLite like I view other databases, as an > external resourc

Re: [JPP-Devel] Jump DB Query Plugin now supports Spatialite

2010-02-03 Thread Larry Reeder
> > What did you use as a Spatialite JDBC connection?  Is this pure Java, or > JNI? > I think there are at least two JDBC drivers for SQLite/Spatialite. I use the Zentus driver with the Jump DB Query Plugin, but I think Jukka has had success with the Xerial drivers. The Zentus documentation is

Re: [JPP-Devel] Jump DB Query Plugin now supports Spatialite

2010-02-03 Thread Larry Becker
Christopher's H2 code comments on SVN says "read only H2 support, still flaky", " working, but way too slow, R*Tree implementation", but it is a start. Larry 2010/2/3 Michaël Michaud > Hi, > > Just had a look to Spat

Re: [JPP-Devel] Jump DB Query Plugin now supports Spatialite

2010-02-03 Thread Martin Davis
Very interesting. What did you use as a Spatialite JDBC connection? Is this pure Java, or JNI? H2 is more appealing to me since it's pure Java - but up til now it hasn't had very good spatial support. The Hatbox project might help with that. It would be nicer to see this capability integrat

Re: [JPP-Devel] Jump DB Query Plugin now supports Spatialite

2010-02-03 Thread Michaël Michaud
Hi, Just had a look to Spatialite (not yet Jump DB Query connector, but it will come soon). Spatialite is very promising : I like its simplicity. I did not test its capabilities yet, but it can handle much more data than OpenJUMP without the complexity of a database like PostGIS. I'd like to l

[JPP-Devel] Jump DB Query Plugin now supports Spatialite

2010-01-21 Thread Larry Reeder
Hey all, I wanted to let the group know that the Jump DB Query Plugin now supports Spatialite databases and SQLite databases that follow the FDO RFC 16 specification. GDAL/OGR and other open source tools use FDO RFC 16 to store spatial data in plain SQLite. Thanks to Jukka Rahkonen for the idea