Re: plpython

["Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>]

KM,

Can someone hint on resources for using plpython for writing stored procedures ?
I have gone thru official docs for  8.1.5 for plpythonu but its not in detail/with examples.

CREATE OR REPLACE FUNCTION myfunc(text)
  RETURNS text AS
$BODY$
eingabe=args[0]
hello = "Good Morning %s" % (eingabe,)

return hello
$BODY$
  LANGUAGE 'plpythonu' VOLATILE;
ALTER FUNCTION myfunc(text) OWNER TO postgres;

that as a first example to get you started. The other one I could give you is using Pyro, which brings in rather uncommon challenges.

>When is plpython going to be considered safe ? any targeted version ?

Hey, you fell into the same "safe" and "unsafe" trap than me!

"unsafe" does not have the information: "it is possibly errorprone to use this language"

"unsafe" simply says: "it is impossible for the database to guarantee, that a bad minded programmer can do harmfull thins with this language"

For example: with plpython you can read and delete files on the server. There is no way for PostgreSQL to stop plpython from doing harm; so it is considered "unsafe".

(Btw: there is no restricted mode of execution for Python, google the Python Mailingslists  for it; "sandbox" is a helpfull keyword)

So: plpython is only recommended to be used by trustworthy programmers. Not by the general public.

Harald

-- 
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.