We are excited to announce that SingleStoreDB On-Premises 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 On-Premises 2.5, developers can use SQL to easily analyze JSON objects while quickly ingesting JSON data feeds. In addition, SingleStoreDB On-Premises 2.5 ships with support for ONLINE ALTER TABLE, which means that you can make changes to your production schemas without any downtime. SingleStoreDB On-Premises 2.5 enables rapid application prototyping,  updating data models on the fly, and otherwise eliminates downtime.
The list of upgrades in SingleStoreDB On-Premises 2.5 includes:
JSON Data Type
SingleStoreDB On-Premises 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 On-Premises 2.5 performs 3x faster over large datasets, enabling scans of over 30 million rows per second per core.
Online “ALTER TABLE”
SingleStoreDB On-Premises 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 On-Premises 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 On-Premises 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