Re: Python as a replacement to PL/SQL

2011-10-24 Thread Ben Finney
Alec Taylor writes: > What else is there besides PL/Python (for any DB) in the context of > writing stored procedures in function? I know of no server-side language other than SQL which can reasonably be expected to work “for any DB”. PostgreSQL supports PL/pgSQL, PL/Python, PL/tcl, PL/Perl, an

Re: Python as a replacement to PL/SQL

2011-10-24 Thread Martin Komoň
PostgreSQL supports PL/SQL, PL/TCL, PL/Python, PL/Perl and I've also seen PL/Java add on module. Martin On 10/24/2011 4:59 PM, Alec Taylor wrote: > Hmm... > > What else is there besides PL/Python (for any DB) in the context of > writing stored procedures in function? > > Thanks for all suggesti

Re: Python as a replacement to PL/SQL

2011-10-24 Thread Alec Taylor
Hmm... What else is there besides PL/Python (for any DB) in the context of writing stored procedures in function? Thanks for all suggestions, Alec Taylor On Tue, Oct 25, 2011 at 1:45 AM, Alain Ketterlin wrote: > Alec Taylor writes: > >> Is there a set of libraries for python which can be used

Re: Python as a replacement to PL/SQL

2011-10-24 Thread Alain Ketterlin
Alec Taylor writes: > Is there a set of libraries for python which can be used as a complete > replacement to PL/SQL? This doesn't make much sense: PL/SQL lets you write server-side code, i.e., executed by the DBMS. Oracle can't execute python code directly, so python can only be used on the cli

Python as a replacement to PL/SQL

2011-10-24 Thread Alec Taylor
Good morning, Is there a set of libraries for python which can be used as a complete replacement to PL/SQL? Alternatively, is there a python library for generating PL/SQL? (I am speaking from the context of Oracle DB, PL/Python only works with PostgreSQL) Thanks for all suggestions, Alec Taylo