Geospatial Foreign Data Wrappers

[robe]

Now that PostgreSQL 9.1 has produced usable SQL/MED bindings and with raster we now have libgdal dependency. It seems to me we have all the ingredients to make some very slick geospatial data wrappers.

Here is an example from PgCon?2011 talk leveraging these bindings:

 http://www.pgcon.org/2011/schedule/events/353.en.html

[pracine]

You mean that could be an easy way to implement full support for out-of-db rasters (and out-of-db vectors of course!)?

[pracine]

See also:

 http://www.pgcon.org/2009/schedule/events/142.en.html

[pracine]

and  http://www.postgresql.org/docs/9.1/static/fdwhandler.html

[robe]

Yes that is what I was thinking.

[nicklas]

To add more possible fdw-implementations

If fdw can be used against twitter it ought to be possible to use it against a gps-stream.

A fdw catching the data from  gpsd.

[robe]

This may need to require 9.2+ or higher. They've changed the API quite a bit in 9.2 for FDW to the point that trying to do a bunch of IFDEFs could become painful and most 9.1 FDWs are broken I believe. I got wind of this when I complained to Andrew I couldn't build my favortie FDW anymore on 9.2 and he fixed it but decided to have two parallel branches instead after that.

 https://github.com/adunstan/file_text_array_fdw/commit/9d173bc89fef92e280e8803ceca962d7393a7bc5