Re: [udig-devel] Questions about HSQL Services ...

[Chris Holmes <cholmes@xxxxxxxxxxxxx>]

I've also been leaning towards H2.  It's better than HSQL since it has 
two stage commit (which is what Dave loved about Derby, iirc), but it 
also seems to have pluggable indexes, which was the big downside of 
Derby - we couldn't easily make a spatial index.  I believe H2 has a 
mechanism like GiST to create your own index.  And it looks to be quite 
a bit faster than Derby to boot.

I've been talking to a guy who successfully got H2 working with Spatial 
DB in a box.  See: 
http://r1.bocher.free.fr/index.php?n=Main.GeoEmbeddedDB  Though the 
actual links to the stuff don't seem to be there.  And there's some 
discussion of it in the forum archives of H2.  He hasn't gotten to the 
spatial index yet, but he has written connectors to gvSig.  It'd be 
great if it could be a piece shared by uDig/gvSig and GeoServer (we'd 
love to ship with a default database that can handle real transactions - 
let people come on and start collaborating on a map right away).

If anyone has an inclination/funding to work on this I might be able to 
put some in-kind developer time to collaborate on it.

best regards,

Chris

On 1/12/07, Jody Garnett <jgarnett@xxxxxxxxxxxxxxx> wrote:
> I think it is the same crew that hid hsql; but this time out they are
> doing a full JDBC support (HSQL did not have transactional independence
> making things very hard).  Derby is okay; we did use it for the spatial
> database in a box experiment but they had an upper limit on their
> String/Blob size that prevented it being a great choice for storing
> Geometry. When I last talked seriously to Dave Blasby about this sort of
> thing he was keen on looking at Derby again when they had a specific
> kind of index supported (perhaps it was RTree that you can fake an
> "okay" bounding box index ontop of?).
>
> Here is the link:
> - http://docs.codehaus.org/display/GEOS/SpatialDBBox
>
> There are bindings on that page for Derby, HSql etc...
>
> Jody
>
> > Do you know how H2 compares to Derby?
> >
> > Jesse
> >
> >
> > On 12-Jan-07, at 10:05 AM, Jody Garnett wrote:
> >
> >> My vote is for an H2 DataStore - seriously the HSQL datastore has
> >> lapsed into "unsupported" status on the GeoTools library side of
> >> things and does not look like it will be available for uDig 1.1.
> >>
> >> Jody
> >>> No sir.  We in actual fact the support of the HSQLService has badly
> >>> lapsed since we don't have the man power to do all the work to it
> >>> that we want.  In addition we are hesitant to make our own format
> >>> for storing data, which is what HSQLService turning into.  However,
> >>> you are welcome to take over maintanence of that plugin and the
> >>> associated Geotools plugin if you wish.
> >>>
> >>> Jesse
> >>>
> >>>
> >>> On 12-Jan-07, at 4:59 AM, Antonio Redondo Lora wrote:
> >>>
> >>>> Hi udiggers!
> >>>>
> >>>> Two questions, please ...
> >>>>
> >>>> Anybody has worked with HsqlService to read CSV files?
> >>>> Are there any documentation or snippets?
> >>>>
> >>>> Thank you
> >>>>
> >>>> Saludos
> >>>>
> >>>> Antonio Redondo Lora
> >>>> Subdirección de Integración de Sistemas
> >>>> E.P. Desarrollo Agrario y Pesquero
> >>>> c/Bergantín, 39 - 41012 Sevilla.  España
> >>>> Email: arlora@xxxxxx
> >>>> Tlfno: 955059762
> >>>> Corporativo: 359762
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>  -----------------------------------------------------
> >>>>   Este correo electrónico y, en su caso, cualquier fichero anexo
> >>>>   al mismo, contiene información de carácter confidencial
> >>>>   exclusivamente dirigida a su destinatario o destinatarios. Queda
> >>>>   prohibida su divulgación, copia o distribución a terceros sin la
> >>>>   previa autorización escrita de Dap. En el caso de haber
> >>>>   recibido este correo electrónico por error, se ruega notifíquese
> >>>>   inmediatamente esta circunstancia mediante reenvío a la dirección
> >>>>   electrónica del remitente.
> >>>>   ----------------------------------------------------------
> >>>>   The information in this e-mail and in any attachments is
> >>>> confidential
> >>>>   and solely for the attention and use of the named addressee(s).
> >>>>   You are hereby notified that any dissemination, distribution 
or copy
> >>>>   of this communication is prohibited without the prior written
> >>>> consent
> >>>>   of Dap. If you have received this communication in error,
> >>>>   please, notify the sender by reply e-mail.
> >>>>   -------------------------------------------------------------
> >>>> _______________________________________________
> >>>> User-friendly Desktop Internet GIS (uDig)
> >>>> http://udig.refractions.net
> >>>> http://lists.refractions.net/mailman/listinfo/udig-devel
> >>>
> >>> _______________________________________________
> >>> User-friendly Desktop Internet GIS (uDig)
> >>> http://udig.refractions.net
> >>> http://lists.refractions.net/mailman/listinfo/udig-devel
> >>
> >> _______________________________________________
> >> User-friendly Desktop Internet GIS (uDig)
> >> http://udig.refractions.net
> >> http://lists.refractions.net/mailman/listinfo/udig-devel
> >
> > _______________________________________________
> > User-friendly Desktop Internet GIS (uDig)
> > http://udig.refractions.net
> > http://lists.refractions.net/mailman/listinfo/udig-devel
>
>
> _______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel
>

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

begin:vcard
fn:Chris Holmes
n:Holmes;Chris
org:The Open Planning Project
adr:;;377 Broadway, 11th Floor;New York;NY;10013;USA
email;internet:cholmes@xxxxxxxxxxxxx
title:VP, Strategic Development
x-mozilla-html:FALSE
url:http://topp.openplans.org
version:2.1
end:vcard