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 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). Cheers Andrea -- Andrea Aime OpenGeo - http://opengeo.org Expert service straight from the developers. ------------------------------------------------------------------------------ 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 Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
