Re: PL/PySQL?

Hi!

I've been taking a look in the Feature Lists / TODO Files of PostgreSQL 7.1,
and thought "hey, why is there PL/pgSQL, Perl and TCL interpreters available
for PostgreSQL and no Python one? That'd be a great thing for, ie, Zope!"

Any thougts? What would it take to do it? Just some PgSQL Language API
hacking and glueing with Python's C API? If somebody's got more experience
with that internals of PostgreSQL or the Python C API, i'm very interested
in getting more information about how the thing would work.

Thanks in advance,

# Carlos Villela
# leecho(at)brasnet(dot)org
# ICQ UIN 6962556

"Carlos Villela" <carlos(at)valenti(dot)com(dot)br> writes:
> I've been taking a look in the Feature Lists / TODO Files of PostgreSQL 7.1,
> and thought "hey, why is there PL/pgSQL, Perl and TCL interpreters available
> for PostgreSQL and no Python one? That'd be a great thing for, ie, Zope!"

Go for it ;-). IIRC, someone else has been making noises about such a
thing, but no submission has showed up. Check the PG mail list archives,
join forces, produce something ...

> Any thougts? What would it take to do it? Just some PgSQL Language API
> hacking and glueing with Python's C API?

The pltcl and plperl sources should give some hints --- note that
plperl is actually a hacked-up descendant of pltcl.

regards, tom lane

On Thu, 25 Jan 2001, Tom Lane wrote:

> Go for it ;-). IIRC, someone else has been making noises about such a
> thing, but no submission has showed up. Check the PG mail list archives,
> join forces, produce something ...
That would be really great and you would gain a lot of friends :).

Kind regards

Andreas.

Attached is an email from someone working on a PlPython.

> "Carlos Villela" <carlos(at)valenti(dot)com(dot)br> writes:
> > I've been taking a look in the Feature Lists / TODO Files of PostgreSQL 7.1,
> > and thought "hey, why is there PL/pgSQL, Perl and TCL interpreters available
> > for PostgreSQL and no Python one? That'd be a great thing for, ie, Zope!"
>
> Go for it ;-). IIRC, someone else has been making noises about such a
> thing, but no submission has showed up. Check the PG mail list archives,
> join forces, produce something ...
>
> > Any thougts? What would it take to do it? Just some PgSQL Language API
> > hacking and glueing with Python's C API?
>
> The pltcl and plperl sources should give some hints --- note that
> plperl is actually a hacked-up descendant of pltcl.
>
> regards, tom lane
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026