Re: Sugestion for PostgreSQL Developer´s

"Marcio" <marcio@oracullos.com.br> writes:

> I have a sugestion for pgsql 8.2 or next versions ...
> Is complicated encrypt the procedures/functions on Database like Oracle or
> similar?
> I sugest this because we develop ERP/MRP with complex routines and we like
> hide all of this routines...this is our "business secret".
> I know if we write this code in C, for example....is possible to hide. But,
> we prefer pl/pgsql native.
> Thank´s,
>
> Marcio
> Delphi7+postgresql 8.x


>From my understanding the problem is that Oracle supports just "one" language
while PostgreSQL has an extensible system.

Some of the supported languages doesn't support a compiled version of their
code (or the interpreter that will run the code needs access to it).

You don't need to have the routines embedded in the database if it is so
important.  You can use untrusted languages and save the compiled versions
outside of it (Java and Python can run from "compiled" code outside of the
database).  All you need is to create a function that will "import" those
external modules and use them for the calculations / logic.

--
Jorge Godoy      <jgodoy@gmail.com>