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

Re: plpython3

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: James William Pye <lists(at)jwp(dot)name>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Josh Berkus <josh(at)agliodbs(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: plpython3
Date: 2010-01-13 20:12:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Wed, 2010-01-13 at 13:06 -0700, James William Pye wrote:
> On Jan 13, 2010, at 11:08 AM, Joshua D. Drake wrote:
> > My argument would be now, what is the benefit of the James Pye version
> > over our version. James can you illustrate succinctly why we should be
> > supporting a new version?
> Doing so, succinctly, is unfortunately difficult.
> It is primarily a matter of comparing features, AFAICT. And, furthermore, some features may not be useful to some users.
> It exposes additional functionality that should *not* be incrementally developed  in plpython as it would break applications. This was the point of trying to move forward with it for Python 3.
> Function Modules:
>  - Does away with the need for GD/SD (more natural Python environment).
>  - Allows tracebacks (tracebacks are useful, right?) to implemented easily.
>  - Does *not* expose a bastardized variant of the language by pretending that "modules/script files" can return and yield.
>  - Helps to promote the Python tenet of being explicit.
> Native Typing:
>  - Provides PG type introspection not available in any other PL, AFAIK.
>  - Improves efficiency in some cases (conversion must be _explicitly_ called for) 
>  - MD Array support.
>  - Composites are a sequence and a mapping.
> Other features:
> Aside from function modules and native typing, many of plpython3's features could be implemented incrementally. However, I had a chance to sprint and they are available now in a new implementation. I did so, rather than improving plpython, because I believe that native typing and function modules are very useful.
> I'm not sure this fulfills your request, but, hopefully, it's a start.

It does actually. Now, hackers... as a Python guy I can say these things
are truly useful, to a Python programmer trying to use Python as a
procedural language with PostgreSQL.

What do we think?

Joshua D. Drake

-- Major Contributor
Command Prompt, Inc: - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.

In response to


pgsql-hackers by date

Next:From: Chris BrowneDate: 2010-01-13 20:18:22
Subject: Re: RFC: PostgreSQL Add-On Network
Previous:From: James William PyeDate: 2010-01-13 20:06:58
Subject: Re: plpython3

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