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