Re: [JPP-Devel] R: (no subject)

2009-01-10 Thread Stefan Steiniger
but didn't write Erwans project a spatial extension to H2 already? see this page: http://geosysin.iict.ch/irstv-trac/wiki/H2spatial/Download Michael Michaud schrieb: Hi In general this seems like a nice way to go. Even nicer IMHO would be a pure Java DB like H2. But someone needs to step

Re: [JPP-Devel] R: (no subject)

2009-01-10 Thread Michael Michaud
Hi Stefan but didn't write Erwans project a spatial extension to H2 already? Yes, Erwan did a nice work, adding all the needed spatial functions to h2. (And I saw another project working in this field: http://code.google.com/p/h2spatial/) But none of them did the hard part which is adding

[JPP-Devel] R: (no subject)

2009-01-09 Thread P . Rizzi Ag . Mobilità Ambiente
Good idea!!! I see there's even a JDBC driver for it: http://www.zentus.com/sqlitejdbc/ so I may take a look at it, but even if I can add SQLite support to the SISDB plugin, it will be read-only like any other OJ DataStore. But the great thing would be the adoption of a light DB, such as

Re: [JPP-Devel] R: (no subject)

2009-01-09 Thread Martin Davis
Thanks for this link, Paolo - I've been wondering if there's a JDBC driver for Sqllite. Are there any issues with using this driver with SpatialLite? Or is SpatialLite 100% transparent from the driver point of view? In general this seems like a nice way to go. Even nicer IMHO would be a

Re: [JPP-Devel] R: (no subject)

2009-01-09 Thread Michael Michaud
Hi In general this seems like a nice way to go. Even nicer IMHO would be a pure Java DB like H2. But someone needs to step to spatializing H2 for this to be appealing for OJ. Probably a similar approach to SpatialLite can be taken here, except for one thing - H2 doesn't have an Rtree