Обсуждение: 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@brasnet.org
#  ICQ UIN 6962556

"Carlos Villela" <carlos@valenti.com.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@valenti.com.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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026