[Mapserver-dev] Any experience with SQL Relay?

[Sean Gillies]

On Jun 18, 2004, at 11:08 AM, David Blasby wrote:

> Sean Gillies wrote:
>
>> On Jun 18, 2004, at 10:44 AM, Zamil Murji wrote:
>>> Hi Sean,
>>>
>>> Before you go to far with SQL Relay, here is an interesting note 
>>> that I came across in the FAQs.
>>>
>>> Does SQL Relay support XXX's specific features?
>>>
>>> Database   Queries Bind Variables Procedural Language Auto-Commit
>>> PostgreSQL Yes     Scalar Input   No                  No
>>>
>>> Now I'm no PostGIS guru but I'm pretty sure that it makes heavy use 
>>> of plpgsql (procedural language for Postgres).
>>> If that is the case, then SQL relay would be out of the question 
>>> because it does not support Procedural Language for postgres.
>>>
>>> I hope that kind of makes sense. Here is the link to their FAQ:
>>> http://sqlrelay.sourceforge.net/sqlrelay/faq.html#features
>
> Its unlikely that there will be problems using SQL Relay with PostGIS 
> -   It should be just passing the query off to the database.
>
> The only problem that might be a problem is the use of Binary Cursors 
> - I dont know how SQL Relay manages them.  Mapserver's connection to 
> postgis is through a binary cursor.
>
> dave
>

Thanks, Dave.  I think that we'd have to write new connector code that 
would
be inspired by that in mappostgis.c, but using the sqlrelay API.  I'm 
still
undecided about starting in on this.

Sean