Search Postgresql Archives

Re: Why isn't Java support part of Postgresql core?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



cowwoc wrote on 15.09.2014 19:55:
H2, HSQLDB, Derby all support Java triggers.

But only because they already live/run inside a JVM, so it's the "natural" choice of language.

And H2 and Derby *only* support Java stored procedures.

The main disadvantage I see with that is, that you can't "just" write a procedure (or trigger) with a simple (procedural) SQL Statement. Yyou need to compile it, package into a jar file and the add the jar file(s) to the classpath of the application (or the server process).

This essentially means you need to restart your application or the server when you deploy a trigger.
Hardly anyhting that you want to do in a production environment.

Granted, we are not talking about MySQL or Oracle here,
but these did not add Java triggers as an afterthought.

MySQL does not have Java triggers (or procedures).








--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux