Re: [udig-devel] uDIG/GeoTools data

[Andrea Aime <aaime@xxxxxxxxxxxxx>]

Dave S-B ha scritto:
> We're just about to start development of an RCP application which will 
> use uDIG. The main data store for the application is likely to be MySql 
> and it'd be really handy to be able to include the GIS data in the 
> database along with the normal data using MySql's spatial extensions.
>
> So, has anyone had any experiences with MySql's spatial extensions (i.e. 
> good/bad?) and does anyone know if there is a datastore/featuresource 
> available?

There is a datastore in GeoTools, but it's not actively mantained and 
could use some love (for example, geometries are transferred over the
wire a WKT instead as of WKB as far as I remember).

As for the mysql spatial extensions, they are very minimal. Most 
operations are really faked out, for example intersects() will work
against the bounding boxes, not against the real geometries,
and many others are just plain missing. Consider carefully if you can
live with these limitations, and look at the wealth of capabilities
that postgis has instead.

Cheers
Andrea