We are excited to announce that SingleStoreDB Self-Managed 2.5 is now available for download. Of the many new features and performance improvements, one of the most exciting is support for JSON analytics. With native support for the JSON datatype, SingleStore delivers a consolidated view across structured and semi-structured data in real-time.
Using SingleStoreDB Self-Managed 2.5, developers can use SQL to easily analyze JSON objects while quickly ingesting JSON data feeds. In addition, SingleStoreDB Self-Managed 2.5 ships with support for ONLINE ALTER TABLE, which means that you can make changes to your production schemas without any downtime. SingleStoreDB Self-Managed 2.5 enables rapid application prototyping, updating data models on the fly, and otherwise eliminates downtime.
The list of upgrades in SingleStoreDB Self-Managed 2.5 includes:
JSON Data Type
SingleStoreDB Self-Managed 2.5 supports JSON as a column type, which enables developers to store and query structured and semi-structured data together in one database. SingleStore JSON integration provides the following features:
Use standard SQL functions with JSON, including built-ins, GROUP BY, JOINs, and more.
Create JSON indexes online.
Client drivers require no changes to support JSON.
JSON properties are updatable.
JSON columns can contain ‘null’, ‘true’, ‘false’, double-precision floating-point values, quoted strings, heterogeneous arrays, and/or nested JSON objects.
Improved Index and Scan Performance
SingleStoreDB Self-Managed 2.5 performs 3x faster over large datasets, enabling scans of over 30 million rows per second per core.
Online “ALTER TABLE”
SingleStoreDB Self-Managed 2.5 supports online “ALTER TABLE” operations (“ADD [COLUMN]”, “DROP [COLUMN]”, and “ADD{INDEX|KEY} ”) on distributed tables. The table is available for reads and writes while “ALTER TABLE” executes. The memory overhead of online ALTER TABLE is only a few megabytes, regardless of the table size.
Online Backup and Restore
SingleStoreDB Self-Managed 2.5 offers single commands to backup and restore a cluster. “BACKUP DATABASE” takes a point-in-time snapshot of data across the cluster while your read and write workloads continue to run. “RESTORE DATABASE” restores an entire distributed database. The new cluster can have a different number of nodes or different redundancy level from the original.
SQL Support
SingleStoreDB Self-Managed 2.5 supports the following operations on both standalone and distributed tables:
Scalar subselects, subselects with EXISTS and IN
Constants are parameterized in projections, as well as ORDER BY and GROUP BY clauses
UNION ALL, GROUP_CONCAT, various built-in functions, and expression performance improvements
Persisted computed columns on arbitrary SQL expressions
