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:

• Stored Procedures (SPs)

• User-Defined Scalar-Valued Functions (UDFs)

• User-Defined Table-Valued Functions (TVFs)

• User-Defined Aggregate Functions (UDAFs)

• External Functions

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.

Extensions in SingleStore allow you to combine user-defined objects, such as UDFs or UDAFs, into a packaged archive and then create, manage, and deploy these objects and other resources using the CREATE EXTENSION command. Extensions support both PSQL and Wasm-based functions. Refer to Extensions for more information.

For information on when to use PSQL, Wasm-based, or external functions, refer to Choose Between PSQL, Wasm-based, and External Functions.