Free online postgreSQL book 1610

Aquila Deus

big snip

Yea, "role based" security has been around forever, Notes had it years ago. I think it is one of those "buzz word compliant" features people think they want but never really use.

Oh, you mean being able to write stored procedures in Java or .NET?

Oh, you mean call a .NET function, within your VM (CLR) as a trigger? Send me a check for $5000 and I'll write a PostgreSQL function-.NET (or java) clbutt that allows triggers to call a .NET (or java) function. (I'll give you a hint, look at the "LISTEN" and "NOTIFY" statements.)

It isn't hard, I just don't see the need.

There are plenty of tools that can do this, but like "role based" administration, IMHO no one really uses them.

No need, PG works perfectly.

Yea, I have engineering issues with supporting Java or .NET for stored procedures. I think of the database system as a critical point of failure and performance.

While usually a judgement call, I don't like to put too much "in to" the database. While sometimes you need to incorporate functionality that conceptualy does not belong, but it is something to be avoided.

PostgreSQL supports a lot of different langages for functions, and I think Java is supported, but supporting a threaded VM environment in the context of a multi-process db server seems costly.

I don't see how stored procedures simplify code all that much.