Pure SQL stored procedures are stored procedures that can be declared as individual SQL statements without any further processing. They are declared using the CREATE PROCEDURE AS statement. You can now create simple procedures with multiple SQL statements by enclosing the statements in a BEGIN-END clause. For example:
CREATE PROCEDURE ReadyToShip
INSERT INTO shipments
SELECT order_num, item, customer FROM orders
SELECT COUNT(*) FROM shipments;
The Analysis tab, which was added to the web-based VoltDB Management Center in 7.6, has been extended and now provides analysis of both procedure execution and table storage. Within the Analysis tab, after running the data gathering, you can choose between Data and Procedures to view statistics regarding the distribution of the tables and the execution of stored procedures.
The VoltDB Go client has been revised to significantly improve performance, remove known defects and keep up to date with advances in the Go language. A description of the changes are available in this blog post.
The VoltDB software kit includes a new sample application. The Anti-Fraud example application demonstrates how easy it is to integrate Apache Kafka and VoltDB to create a fast data pipeline with data analysis and reporting. See the README in the examples/fraud-detection/ folder where you installed VoltDB for more information.
For a full list of v7.7 features and fixes, visit our Release Notes. If you have questions or feedback, drop our Customer Success Manager Ben Ballard a note at support [at] voltdb.com. Download VoltDB v7.7 here.