Skip directly to content

VoltDB 4.0

VoltDB is a Churning Urn of Groovy Funk

Tuesday, February 11, 2014 - 12:00am

VoltDB is welcoming Groovy into its ecosystem as its first inline procedure language. Code your procedure logic straight into the DDL, bypassing the java procedure requirements to edit/compile java source files separately.

 

With VoltDB Groovy stored procedures you can code your procedure implementation as part of CREATE PROCEDURE statements in your DDL file.

 

CREATE PROCEDURE groovy.procedures.Item AS ###
selectItem = new SQLStmt('SELECT ITEM_ID, DESCRIPTION FROM ITEMS WHERE ITEM_ID = ?')
transactOn = { id ->
    voltQueueSQL(selectItem, EXPECT_ZERO_OR_ONE_ROW, id)