Very cool! I was actually looking at doing this as we also have PL/R.
Dave Cramer
On Tue, 24 Aug 2021 at 04:26, Konstantina Skovola <konskov@gmail.com> wrote:
Hello hackers,
Here is a summary of what was implemented over the summer in PL/Julia:
1. Added support for more datatypes as input and output: NULL, boolean, numeric types, composite types, arrays of base types can now be passed as input arguments to PL/Julia functions. Users can also return the above, or sets of the above from PL/Julia UDFs. 2. Added trigger support - users can write trigger functions in PL/Julia 3. Added event trigger support 4. Added support for the DO command 5. Added functions for database access from PL/Julia: spi_exec(query, limit) and spi_exec(query) for SQL-statement execution, spi_fetchrow(cursor) and spi_cursor_close(cursor) to return rows and to close the cursor respectively, spi_prepare(query, argtypes) to prepare and save an execution plan and spi_exec_prepared(plan, args, limit) to execute a previously prepared plan.
