[Gdal-dev] open files from mysql

[Frank Warmerdam]

Emanuele Conti wrote:
> Hi and thanks for your fast reply,
> 
>     I'm concerned that this is a rather specialized driver, and that
>     folks might
>     actually want to use rasters from MySQL in a variety of other ways
>     as well.
> 
> 
>  Can you give me an example? I can't imagine (I'm not so expert in gis 
> maps) how a raster map could be stored in a mysql db other than the one 
> of storing the whole file in a blob...

Emauele,

Well, another approach is to treat a large image as a set of tiles.  So
a table might represent the image, and each row is a tile with other
columns holding the bounds for instance.

>     I would be happy to have the driver put in "spike" (an experimental
>     area) in
>     subversion, but I'm not yet all that comfortable that this makes
>     sense as
>     *the* mysql raster driver for GDAL.
> 
> 
> How should I do that? And how could this first "idea" of driver be 
> improved? I could work on it if only I'd have some feedback about the 
> direction it should go and if I'm pretty sure that it won't be wasted time!

If you submit the driver via Trac, I can commit it on the spike.

Then I'd encourage you to write up a topic about the driver in the wiki
for folks to look at if they want to try it.  I'll add a bit of info there
on how to pull it out of spike into an existing build.  Likely we would
handle it as a plugin.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org