Thread: Postgresql <--> webservices?

Postgresql <--> webservices?

From
"Philippe Lang"
Date:
Hello,

Does anyone have experience in interfacing a Postgresql database
(tables? plpgsql functions? perl functions?) with the outside world
through webservices? (XML-RPC, SOAP, UDDI, WSDL...)

Philippe

Re: Postgresql <--> webservices?

From
Christopher Browne
Date:
Martha Stewart called it a Good Thing when philippe.lang@attiksystem.ch ("Philippe Lang") wrote:
> Does anyone have experience in interfacing a Postgresql database
> (tables? plpgsql functions? perl functions?) with the outside world
> through webservices? (XML-RPC, SOAP, UDDI, WSDL...)

Yeah, I did some of this using the Perl SOAP module.

The robust way involves getting Apache involved so that you've got
something that starts the services 'on demand,' as well as a
connection pool manager.  Perl's weaker on the WSDL side of things, as
that is something typically autogenerated by a language compiler,
whilst Perl is pretty dynamic and way too weakly typed; if you want
WSDL, Java is probably the way to go...

Contrary to how it gets billed, this is pretty heavyweight stuff,
because you have a pretty thick layer of XML encoding on top of the
data.
--
"cbbrowne","@","acm.org"
http://linuxfinances.info/info/soap.html
"What I find most amusing  about com and .NET  is that they are trying
to solve a problem I only had when programming using MS tools."
-- Max M <maxm@mxm.dk> (on comp.lang.python)

Re: Postgresql <--> webservices?

From
Bill Moran
Date:
Christopher Browne <cbbrowne@acm.org> wrote:
> Martha Stewart called it a Good Thing when philippe.lang@attiksystem.ch ("Philippe Lang") wrote:
> > Does anyone have experience in interfacing a Postgresql database
> > (tables? plpgsql functions? perl functions?) with the outside world
> > through webservices? (XML-RPC, SOAP, UDDI, WSDL...)
>
> Yeah, I did some of this using the Perl SOAP module.
>
> The robust way involves getting Apache involved so that you've got
> something that starts the services 'on demand,' as well as a
> connection pool manager.  Perl's weaker on the WSDL side of things, as
> that is something typically autogenerated by a language compiler,
> whilst Perl is pretty dynamic and way too weakly typed; if you want
> WSDL, Java is probably the way to go...
>
> Contrary to how it gets billed, this is pretty heavyweight stuff,
> because you have a pretty thick layer of XML encoding on top of the
> data.

I've done this twice with C and the gsoap library.

Works very well, but you have the deveopment time and effort involved with
C apps.  gsoap generates a WSDL from your header files, which is nice.
And, of course, it's very fast.

You have to write your own connection handling routines, so there's a bit
of work to do there.  Especially if you want to avoid the latency of
establishing the Postgres connection, and thus need preforked or
pretreaded systems.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com

Re: Postgresql <--> webservices?

From
Björn Lundin
Date:
Philippe Lang wrote:

> Hello,
>
> Does anyone have experience in interfacing a Postgresql database
> (tables? plpgsql functions? perl functions?) with the outside world
> through webservices? (XML-RPC, SOAP, UDDI, WSDL...)
>
> Philippe
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly

Yes, using Ada Web Server, and it's SOAP module + an Ada interface to libpq.
Works very well, but I did it only as a test, no 'real world' application
was developed.
/Björn