Hi there,

for the Geomajas project we are facing a similar problem. We need some (preferably in-memory) spatial database that we can use for test and demo purposes. Just as we worked on Hibernate Spatial a while ago, we were thinking of perhaps extending the HSQLDB with spatial functionality.

Could this be of any use to the GeoTools project?


Andrea Aime schreef:
Ben Caradoc-Davies ha scritto:
 > Andrea Aime reassigned GEOT-2926:
 > ---------------------------------
 >      Assignee: Ben Caradoc-Davies
 >> Some properties aren't displayed when served from a denormalised view

Thanks, Andrea. I saw this one. (I asked Pavel to submit it!)

We (app-schema developers) have run into many SQL problems that are not covered by app-schema unit tests, which all use property files. I would like to remedy this.

I remember you asking the list some time ago for recommendations as to the preferred in-memory Java SQL database (H2/HSQL/Derby ...). Did you get a response? Do any of them support spatial operations, which would make them better candidates for unit testing?

I guess you can use gt-jdbc-h2. It does not support spatial natively,
does not have spatial indexes, but Justin worked a layer on top of it
to provide such features. It won't be fast over large data sets and
all spatial operations will be performed in memory anyways, but it should get you all the SQL coverage you need?

Cheers
Andrea


--
Pieter De Graef

GeoSparc nv.
http://www.geosparc.com/

Sponsor of: http://www.geomajas.org/


------------------------------------------------------------------------------
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
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to