Procedural Extensions

SingleStore Procedural Extensions (PSQL) are available beginning in MemSQL version 6.0. These extensions provide familiar mechanisms for SQL developers and database administrators to encapsulate custom programmatic logic, namely:

Within stored procedures, you can write flexible queries that use static parameterized SQL and dynamic SQL.

SingleStore also supports Wasm-based functions. Refer to Code Engine - Powered by Wasm for information on creating Wasm-based UDFs and TVFs. To create Wasm-based UDAFs, refer to CREATE AGGREGATE. If your logic and data structures can be implemented in PSQL with reasonable effort in a way that performs well, use PSQL. For integrating more complex logic and data structures, or using existing C/C++ or Rust code, SingleStore recommends using Wasm-based functions.

In this section

Last modified: January 31, 2024

Was this article helpful?