This page includes a list of release notes for ScalarDB 3.11.

v3.11.0

Release date: December 27, 2023

Summary

This release has a lot of enhancements, improvements, and bug fixes. There are many SQL enhancements including JOIN support and cross-partition scan support. This release also includes ScalarDB Auth, which is an authentication and authorization mechanism for ScalarDB Cluster. Please see the following for a list of detailed changes.

ScalarDB provides a Community edition and an Enterprise edition. The Community edition is available as open-source software that you can use under the Apache 2.0 License. The Enterprise edition includes not only the features of the Community edition but also many advanced features. Release notes for the Enterprise edition are available under the “Enterprise edition” section. To use the features in the Enterprise edition, you must have a license agreement with Scalar Inc.

Community edition

Enhancements

  • Added import functionalities for existing relational databases. (#841 #931 #1055)
  • Added support for cross-partition scan for relational databases with arbitrary conditions, including LIKE expressions. (#889 #900 #925 #984 #1006 #1045 #1046)

Improvements

  • Added support for implicit pre-read in Consensus Commit. With implicit pre-read, users can perform mutations (Put and Delete operations) without reading the records beforehand. (#1222)

Bug fixes

Enterprise edition

Enhancements

ScalarDB Cluster
  • Added support for cross-partition scan for relational databases with arbitrary conditions, including LIKE expressions.
  • Added import functionalities for existing relational databases.
  • Added support for operating a ScalarDB Cluster node in standalone mode to make development and testing more convenient. You can activate standalone mode by setting scalar.db.cluster.node.standalone_mode.enabled to true.
  • Added the docker-compose.yaml file to test standalone mode. You can run ScalarDB Cluster for testing purposes in your local environment by using the docker compose up command.
  • Introduced ScalarDB Auth, an authentication and authorization mechanism for ScalarDB Cluster.
ScalarDB SQL
  • Added support for cross-partition scan for relational databases with arbitrary conditions, including LIKE expressions.
  • Added support for table aliases for UPDATEDELETE, and SELECT statements. User can write a query with table aliase like SELECT t.col FROM tbl AS t.
  • Added support for the JOIN operation. This enhancement supports INNER JOINLEFT OUTER JOIN, and RIGHT OUTER JOIN.
  • Added support for specifying multiple values in INSERT statements.
  • Introduced support for the START TRANSACTION and ABORT commands, which serve as aliases for the BEGIN and ROLLBACK commands, respectively.
  • Added support for cross-partition WHERE clauses in UPDATE and DELETE statements.
  • Introduced an UPSERT command that creates a new record if it doesn’t exist, or updates the record if it does.

Improvements

ScalarDB Cluster
  • Added pay-as-you-go containers to the AWS Marketplace.
  • Added ScalarDB Cluster (BYOL) to the Azure Marketplace. You can use ScalarDB Cluster by subscribing to it in the Azure Marketplace.
  • Added ScalarDB Cluster (BYOL) to the AWS Marketplace. You can use ScalarDB Cluster by subscribing to it in the AWS Marketplace.
  • Added support for implicit pre-read introduced in the enterprise edition. With implicit pre-read, users can perform mutations (Put and Delete operations) without reading the records beforehand.

Bug fixes

ScalarDB Cluster
ScalarDB GraphQL
ScalarDB SQL