Re: status of PlPython

Ühel kenal päeval, E, 2007-05-28 kell 20:57, kirjutas
michele(dot)simionato(at)gmail(dot)com:
> I wonder if I should use PlPython in my projects or not.
> Browsing on the Python list it seems that nobody is using
> it.

At least we are usingi it at Skype.

> Browsing on Google Groups I find worrysome threads talking
> about removing support from it in future versions of PostgreSQL.
> So, I would like to know what's the current status of PlPython.
> Assuming it is in good health, I would like to know how people
> are using it,

Three main uses are

1) as a glue for external libraries, like GeoIP
2) for remote calls to other databases (now we have replaced that use
with pl/proxy)
3) anything that is easier to do in python than in pl/pgsql or pure sql,
like string/list processing, encoding/decoding, etc.
4) caching something in GD

> how do you keep your code in subversion, how do
> you debug it,

we debug it by debugging outside postgresql backend if possible, and by
inserting NOTICE'es (plpy.notice('noticetext')) if running inside
backend.

> what are the pitfalls, etc.

various external python modules may be less robust than standard SQL
stuff. if something crashes inside plpython, it can crash/restart the
whole backend

> What sources of
> information are out there, apart from the postgres manual?

python manual and library reference ;)

>
> Michele Simionato
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend