SingleStore 8.0 was released on December 13th, 2022. Below you can find the release highlights. In addition, you can see the complete feature list on our Release Notes page and in our announcement Blog Post.
Code Engine - Powered by Wasm
The Code Engine feature allows you to create UDFs/TVFs using code compiled into WebAssembly (Wasm). This feature supports any language that can compile to the Wasm core specification.
For more information, see Code Engine - Powered by Wasm.
Improved Seekability in Universal Storage Tables
These enhancements will deliver large performance gains for transactional workloads on universal storage tables.
Added support for fast seeking into JSON columns in a universal storage table using subsegment access.
Improved seek performance for string data types for universal storage for LZ4 and run-length encoded (RLE) data.
Recursive Common Table Expressions
Recursive common table expressions (CTE) are now supported bySingleStoreDB. Previously, complex operations including temporary tables within a stored procedure would be needed to perform the actions that a simple recursive CTE query can handle.
For more information, see WITH (Common Table Expressions).
Initial IPv6 Support
Preview feature: Added initial support for IPv6 to the SingleStoreDB engine (
memsqld) and SingleStoreDB Toolbox. Refer to the
bind_addressengine variables for more information.