Hi,
Some additional comments on Erwan's answer.
Le 06/04/2015 09:13, Andrea Aime a écrit :
> Interesting, could you compare that with the GeoTools H2 datastore?
GeoTools H2 datastore use blob as geometry columns and does not include
spatial index. H2GIS use the new native Geometry columns and spatial
index of H2. Moreover H2GIS provides all SFS sql functions, geometry
constraints and file drivers.
>> Since you seem to be an expert in H2, I have a question for you. In GeoTools
>> and GeoServer we use H2 in
>> multiple places, but an old version of it.
>> This is mostly because H2 changed the on disk format, and apparently did not
>> include an automatic upgrade
>> procedure for it... which is a serious problem when users are upgrading
>> existing installations.
>> Do you know of a way to make the upgrades transparent?
I think you are talking about the old storage before the PageStore. The
great issue here is the necessity of embedding two versions of H2, one
for creating a sql dump of the database and the latest to execute the
dump. Even if you could achieve that it could failed. There is a
discussion about that here [1]. As the user may loose some data if its
done unnoticed; maybe it is more secure to update h2 in a new major
version of geotools/geonetwork then warn about the database
incompatibility.
Regards,
--
Nicolas Fortin
IRSTV FR CNRS 2488
GIS http://orbisgis.org
Spatial DB http://h2gis.org
Noise http://noisemap.orbisgis.org
Links:
------
[1]
https://groups.google.com/forum/?fromgroups=#!searchin/h2-database/migration|sort:date/h2-database/3TuWJfFiQdc/7TGTJB1JEmoJ
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
