[postgis-users] Proposed SQL interface for PGRaster

[Mark Cave-Ayland]

On Tue, 2006-12-05 at 12:39 -0500, Stephen Marshall wrote: 
> I have written a proposal for the SQL interface to PGRaster, a 
> raster-in-DB implementation.  The document can be found on the PostGIS 
> Wiki at
> 
> http://postgis.refractions.net/support/wiki/index.php?PgRasterSqlInterface
> 
> Discussion on the interface is welcome (and hoped for).  However, for 
> now, please do not edit the Wiki directly.  Until the big-picture issues 
> are resolved, I'd like to remain the primary author.
> 
> Yours,
> Steve Marshall


Hi Steve,

Thanks for an interesting proposal. My only comment so far would concern
the endian-ness of the raster data if it is stored as binary - for
example, what would happen in the case of dumping a PostgreSQL database
containing pgrasters on an Intel machine and restoring it on a Power
machine with respect to the int16/32/64 and float32/float64 types?
Perhaps you need to store the endian-ness of the data as it is inserted
into the database, and then perform optional on-the-fly conversion
depending upon the current processor?


Kind regards,

Mark.