PL/Java language support

[domenico1982]

Describe the problem

Any chance to get the PL/Java language listed as trusted languages and thus supported with pg_tle?
If yes, can you provide an ETA for GA?

• What are you trying to solve? --> use-cases where the PL/Java language can help with its specific superpowers
  See Features section here: https://github.com/tada/pljava/wiki

[jkatz]

Hi @domenico1982 -- we actually don't list out specific trusted languages that work with pg_tle in the docs, though we do provide examples of writing TLEs with a few of them. As noted in the security section of the docs:

Use pg_tle with trusted languages. While pg_tle can work with untrusted languages, trusted languages in PostgreSQL provide more protections for user-provided code.

Implicitly, you can write TLEs with PL/Java so long as your environment has PL/Java installed. Perhaps we can add in the README a comment about how TLE applies to trusted languages in genera. However, unless we have specific examples built on in the docs of pg_tle being used with another language, I don't know if we should list all of the languages out.

[davecramer]

Hi @domenico1982 PL/Java is also somewhat unique in that it requires a JVM to exist on the host. I guess you would only run this on your hosts that actually had a JVM ?

[domenico1982]

Hi Dave, yeah, you're right. We're only wondering if this will ever be supported with RDS/Aurora. Thanks for your support, both answers are clear and valuable.

[jkatz]

@domenico1982 Thanks for the feedback. I am going to close out this issue.

[davecramer]

@domenico1982 PL/Java hasn't seen much love lately. I'm wondering just how much it is used. Obviously you are using it, do you have any notion how popular it is ?