Company
Date Published
Author
Jimmy Guerrero
Word count
765
Language
English
Hacker News points
None

Summary

You can now use stored procedures in YugabyteDB, which allow developers to "bundle up" operations that would otherwise take several queries and round trips into a single function, minimizing duplicate code. Stored procedures also help minimize transactions issues with functions, enabling developers to reuse existing stored procedures to perform the same actions. The latest release of YugabyteDB 1.2.11 includes stored procedure support, as well as 30 new features, enhancements, and bug fixes. This feature allows developers to enable a flag on their cluster to try out this functionality. To get started with stored procedures, developers need to enable the `ysql_beta_features` flag, create an accounts table, insert data into it, verify the data, create a stored procedure, call the stored procedure, and verify the transfer of money. The latest release also includes new documentation, blogs, and videos on various topics such as building Java, NodeJS, Go, Python, Ruby, and SQL Alchemy apps with ORM examples. Additionally, YugabyteDB will be attending several conferences and meetups over the next few months.