Friday, April 7, 2017

Trusted Languages in PostgreSQL ... finally with PL/Container

Today PL/Container has been released as open source under the BSD license.

PL/Container runs Python code (and hopefully R code when we can open source it) inside a Docker container. The server side code running inside GPDB communicates with the container using an RPC protocol very similar to the GPDB FE/BE protocol.

Of course there is some overhead but with complicated enough functions this overhead is overcome by the ability to throw more computing power at the problem.

     For example a complicated function that brute force computes the prime numbers below 10,000 runs in approx. 250ms, actually runs faster.

No comments: