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 integrated into the original H2 codebase (but then that hasn't seemed to have slowed down Spatialite at all, so maybe I worry too much...) H2 I think also is more flexible than Sqlite - e.g. in-memory databases, etc. But Sqlite is certainly getting deployed in a LOT of large projects, so its longevity seems assured. I guess it would be good to support both! Michaël Michaud wrote: > 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 let you (developper) know that h2 is a pure java database > which has most of the SQLite qualities (simplicity, one file storage, > in-memory mode...), and that it has now a spatial index called HatBox > from Peter Yuill (http://hatbox.sourceforge.net/news.html). AFAIK > Geotools has started h2/hatbox integration into Geotools. > In hatbox, indexes seem to be build in a way which is very similar to > spatialite way (i.e trigger updating a Rtree stired in a plain table), > and quite different from postgis. > > Of course, a complete integration of h2, hatbox and OpenJUMP would be an > interesting challenge ;-) > > Michaël > > Larry Reeder a écrit : > >> 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 and QA support, and a big "Thank you" to the >> OpenJump developers for continuing to support a great open source GIS >> tool. >> >> You can find out more about the plugin at >> http://jumpdbqplugin.sourceforge.net/. >> >> >> -Larry >> >> ------------------------------------------------------------------------------ >> Throughout its 18-year history, RSA Conference consistently attracts the >> world's best and brightest in the field, creating opportunities for >> Conference >> attendees to learn about information security's most important issues through >> interactions with peers, luminaries and emerging and established companies. >> http://p.sf.net/sfu/rsaconf-dev2dev >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> >> >> >> > > > ------------------------------------------------------------------------------ > The Planet: dedicated and managed hosting, cloud storage, colocation > Stay online with enterprise data centers and the best network in the business > Choose flexible plans and management services without long-term contracts > Personal 24x7 support from experience hosting pros just a phone call away. > http://p.sf.net/sfu/theplanet-com > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > -- Martin Davis Senior Technical Architect Refractions Research, Inc. (250) 383-3022 ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
