Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL and SOAP, version 7.4/8.0

From: Steve Wampler <swampler(at)noao(dot)edu>
To: mlw <pgsql(at)mohawksoft(dot)com>
Cc: "Jason M(dot) Felice" <jfelice(at)cronosys(dot)com>,Postgres-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PostgreSQL and SOAP, version 7.4/8.0
Date: 2003-03-28 21:47:09
Message-ID: 1048888029.10241.21.camel@weaver.tuc.noao.edu (view raw or flat)
Thread:
Lists: pgsql-hackers
On Fri, 2003-03-28 at 14:39, mlw wrote:

> I was thinking of using SOAP over HTTP as the protocol, and a
> minimalist version at best. If the people want "more" let them add it.
> 
> I have an HTTP service class in my open source library. It would br
> trivial to accept a SQL query formatted as a GET request, and then
> execute the query and, using libpq, format the result as XML. It
> should be simple enough to do. 

It would be easy.  I've done something similar (using ODBC to
get to PostgreSQL) - but using a language none of the rest of
you are likely to be interested in (Unicon).  Works just fine,
though the implementation (deliberately, by personal preference)
avoids accepting arbitrary SQL statements from SOAP clients,
instead forcing the clients to use an RPC interface so I can
do sanity checking in the Unicon [which I know better than I know
PostgreSQL...] SOAP servers.

I, too, opted for a 'minimal-SOAP' implementation.  A 'real'
implementation boggles the mind.

-- 
Steve Wampler <swampler(at)noao(dot)edu>
National Solar Observatory


In response to

Responses

pgsql-hackers by date

Next:From: Hiroshi InoueDate: 2003-03-28 23:05:16
Subject: Re: updateable cursors & visibility
Previous:From: mlwDate: 2003-03-28 21:39:34
Subject: Re: PostgreSQL and SOAP, version 7.4/8.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group