New Features in Release 19.5

Multi-Region Tables

Multi-Region Tables are a new feature that lets users create "read-anywhere" and "write-anywhere" tables that live in multiple regions, where each region is a separate Oracle NoSQL Database store. This is a preview release to give users early access to the new feature. It is not recommended to deploy this version of multi-region tables in a production environment. A general availability version will be available in a future release. Data stored in multi-region tables created with this release may need to be discarded when upgrading to the general availability version. Please refer to the Admin Guide and related documents for more information on the new feature and see the Known Issues section below for a list of limitations in this release.

Asynchronous Table API Methods

The table API now has asynchronous methods that applications can use to make calls without using a thread to wait for results, which can improve the efficiency of clients that make many concurrent calls.

The client uses a new network protocol that multiplexes multiple calls on the same socket which supports asynchronous operations and reduces the number of socket connections needed. The new client is only compatible with this version of the server, although the new server continues to support older clients.

String manipulation SQL functions

A set of new functions have been added to SQL queries to help with string manipulation: concatenation, substring, trim, ltrim, rtrim, length, contains, starts_with, ends_with, index_of, replace, reverse, upper, lower.

Deprecating "kvproxy drivers"

In the 19.3 release, Oracle NoSQL Database released a database proxy component that lets Oracle NoSQL Database drivers communicate with the Oracle NoSQL Database cluster, called the "HTTP proxy drivers." Prior to the 19.3 release, there was another set of Oracle NoSQL Database drivers that used a thrift based proxy for communication, called the "kvproxy drivers." These drivers are available in Java, C#, Javascript, and Python. The "HTTP proxy drivers" provide richer capabilities and will be usable for both on-prem and cloud applications. The "kvproxy drivers" have been deprecated in this release and are subject to removal from future versions. They should be used with that possibility in mind. The APIs are different between the "kvproxy drivers" and the "HTTP proxy drivers", so existing applications will need to be modified to use the "HTTP proxy drivers." Deprecated drivers will be clearly marked on the Oracle Technology Network.