<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><blockquote type="cite">Selon Olivier Courtin <<a href="mailto:olivier.courtin@oslandia.com">olivier.courtin@oslandia.com</a>>:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><blockquote type="cite">WFS and Filter Encoding are really closes to SQL concepts (in fact it's just<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">a Web Service API in front of a Spatial Database)<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">So i don't think that using OGR will bring us all the expressivity of plain SQL.<br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I don't see a problem here. OGR justs forwards SQL requests to the RDBMS own SQL<br></blockquote><blockquote type="cite">engine when it is available (otherwise OGR has its own generic simplistic SQL<br></blockquote><blockquote type="cite">engine, but without any spatial support currently, other than bounding box<br></blockquote><blockquote type="cite">intersection through the SetSpatialFilter() API). So if you target OGR backends<br></blockquote><blockquote type="cite">that are RDBMS with SQL/MM support, that should be OK. The part that translates<br></blockquote><blockquote type="cite">Filter Encoding to SQL/MM would be done in a generic way in TinyOWS.<br></blockquote><br>Well it shows that i don't know OGR deeper enough ! <br><br>Do you have a vision of FE support in OGR ?<br>(i.e 1.0, 1.1 and 2.0 versions ?, partial or full ?, is there also a way to add new <br>SQL functions mapping ?) <br><br><br><blockquote type="cite"><blockquote type="cite">And also maybe we will loose a bit of performances rather than a direct<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">database<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">access.<br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Hum, we are talking about client/servers that interact through the Web, so I<br></blockquote><blockquote type="cite">doubt the OGR overhead makes a significant difference.<br></blockquote><br>It had to be benched :)<br><br>--<br>Olivier<br></body></html>