Re: Oracle and Postgresql

Jonathan Bond-Caron escribió:

> For me, "Oracle stored procedures can be encrypted." is a very real and
> valuable argument.
> It would certainly be a valuable feature in pgsql (in the enterprise space).

Fortunately for you, PostgreSQL is extensible, even in the procedural
languages area. This means that if you want to create a new PL that
takes the encrypted code, decrypts it, and passes it to plpgsql, you can
do it. It shouldn't be very difficult. There was some talk about doing
this as a pgfoundry project, but no one stepped up to actually doing the
work.

Of course, as pointed out by Scott Marlowe, any half-decent hacker will
be able to get the actual code out just like he would on encrypted
PL/SQL, but the barrier for stealing the code got considerably higher at
that point.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.