2017-11 Java Stored Procedures In PostgreSQL

A talk from Dave Cramer about Java-based stored procedures in PostgreSQL. PL/JVM is a procedural language for PostgreSQL which uses RPC to call java objects inside a user program. There is a Netty pipeline to implement the protocol. PL/JVM came from PL/J which was written back in 2004 and died on the vine. Since then the PL/J code was used to implement PL/container which allows for trusted Python, and R running in containers. PL/JVM uses the C code from PL/container to implement RPC into a JVM based process. This is still in the development phase and I have some unanswered questions such as: How to do class separation? How to deal with auto boxing of methods? Whether to provide this as a library or a complete product. What I'd like to do is explain how it works and some of the issues and open it up for discussion. About the speaker Dave Cramer has been a major contributor to PostgreSQL since 1999, Maintainer for PostgreSQL JDBC. Most recently working for Pivotal, then OpenSCG on Greenplum MPP database.