Andrea Aime wrote: > andrea antonello ha scritto: >> [...] >>> Opinions? I noticed GeoToolkit also ditched >>> HSQL, but in favour of the Derby version that's >>> shipping with the JDK. >>> >>> Opinions, preferences? >>> >>> I for one prefer H2, mostly because we're already >>> using it extensively in GeoServer and GeoWebCache, >>> and we have a JDBC datastore based on it. But that's >>> just me, what do others prefer? >> Hi Andrea, >> same here for H2, we also use it a lot in JGrass and are going to >> remove hsql. Derby would be cool since it is integrated but I don't >> think there is a spatial effort on that? Is there? > > Nope, there is none. Actually the spatial effort on H2 is languishing > as well, the author won't implement R-tree indexes for the moment and > thus the datastore is stuck into doing full scans in memory everytime > a spatial operator is used. The current "plan" is to use geohash to spatialize H2. I did some experimentation and its relatively easy to implement, although not as effective as an R-Tree, but good in a lot of cases.
> > The best embedded spatial db today seems to be Spatialite, too bad > it is native code, so it requires recompiling on various platforms, and > there are also issues with its java bindings under OSX (or so I heard). I more or less fixed these OSX issues. But the jdbc driver has a few issues, I have submitted a patch which has been rolled in and its now useable, but has some issues surrounding primary keys which i am working on another patch for. It's on my TODO list to get it to releasable. > > Cheers > Andrea > -- Justin Deoliveira OpenGeo - http://opengeo.org Enterprise support for open source geospatial. ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Geotools-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
