[Mapserver-dev] Any experience with SQL Relay?

[Zamil Murji]

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

Zamil



-----Original Message-----
From: mapserver-dev-admin at lists.gis.umn.edu
[mailto:mapserver-dev-admin at lists.gis.umn.edu]On Behalf Of Frank
Warmerdam
Sent: Friday, June 18, 2004 10:21 AM
To: Sean Gillies
Cc: MapServer-Dev
Subject: Re: [Mapserver-dev] Any experience with SQL Relay?


Sean Gillies wrote:
> I'm looking into whether SQL Relay
> 
>    http://sqlrelay.sourceforge.net/
> 
> would be useful for improving MapServer connections to PostGIS.
> Anyone have any experience with this software?  Any reason
> why I couldn't implement a PostGIS driver that would connect
> to an external SQL Relay connection pool?

Sean,

My understanding is that the connection cost for PostGIS is negligable.
However, it might be of great interest to do this for Oracle and ODBC
connections.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent

_______________________________________________
Mapserver-dev mailing list
Mapserver-dev at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-dev