plperl direction

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: plperl direction
Date: 2001-06-17 14:02:49
Message-ID: Pine.BSO.4.10.10106162146001.8898-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Just wanted to share with y'all what I wanna do with plperl:

1) I want to implement database access from plperl script by providing a
perl module DBD::PgSPI which instead of using libpq interface to talk to
database would use SPI. Thus, certain client-side scripts could become
stored procedures with no change of code.

2) When that's done, it'll be possible to have an 'application server'
running as an frontend to postgresql. An external program would take SOAP
(or CORBA or something) calls and translate them to calls of plperl stored
procedures. Since perl procedures are able to return complex data
structures, and methods to marshal them are easily available, such
procedure can encapsulate business logic in one place. Also, an neat
possibility is client providing perl code to process things to the server
(where SQL just won't do).

3) Possibly, later, the 'external program' described above could be merged
into postgresql proper, to achieve additional speedup.

Let me know if this all makes sense.

-alex

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Lincoln Yeoh 2001-06-17 15:05:52 Re: Re: Encrypting pg_shadow passwords
Previous Message Alex Pilosov 2001-06-17 13:52:53 Re: [PATCH] untrusted plperl