[postgis-tickets] [PostGIS] #2217: [raster] ST_AsBinary semantic discrepancy

[PostGIS]

#2217: [raster] ST_AsBinary semantic discrepancy
---------------------+------------------------------------------------------
 Reporter:  mloskot  |       Owner:  dustymugs
     Type:  defect   |      Status:  new      
 Priority:  medium   |   Milestone:           
Component:  raster   |     Version:  trunk    
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by mloskot):

 @pracine Database communication is based on client-server model. The fact
 that you can put application and database on the same machine is
 irrelevant here, because we discuss public SQL API which is supposed to
 provide seamless means of access.
 I'd also argue, that in distributed systems, in a cloud, returning local
 path is useless indeed. It is not responsibility of application to read
 the file registered in PostGIS database as out-db raster, but it is
 responsibility of PostGIS to serve that file. The application does not
 want to distinguish storage modes in the server.

 IMHO, you seem to be trying to mix in data server and data client into
 single solution. Nothing with that as long as the data server does not
 make assumptions about local data access.

 From your perspective, instead of having geometry functions in PostGIS
 passing blobs of data, they simply could juggle IDs/pointers/indexes to
 serialised storage only without any real data exchange.

 @dustymags It is defined in that doc, but it does not consider SQL API.
 There is no need for change, as the WKB already defines all we need in the
 first part.

 I don't want to make yet another discussion ride, about API design, use
 cases, and other things you don't necessarily would like to hear.

 Let's turn this ticket this way:
  * I'm a user.
  * I have table with raster registered as out-db
  * I call SQL API.
 How can I query and fetch complete blob of WKB data for the whole raster?

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2217#comment:15>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.