What’s new at Oxla – release summary 1.1.0 – 1.3.0

We are thrilled to share the latest update of Oxla 1.3.0!

Since the beta release, we’ve been working hard and are now dropping three releases – 1.1.0, 1.2.0, and the latest 1.3.0.

Release Summary

New Features

● SQL Mutations
● COPY FROM with endpoint
● SET/SHOW statements
● Handling columns specified in the INSERT INTO with SELECT. e.g. INSERT INTO tbl1(c2) SELECT col1 FROM tbl2.
● Support for Basic INSERT INTO [table] SELECT [statement].

Performance Improvements

● Four performance optimizations. For details, please refer here.

Bug Fixes

● Twelve bug fixes. For details, refer here.

Let’s dive into the exciting details:

SQL Mutations

We now support SQL mutations as part of our continued effort to expand SQL support. This includes directly manipulating and modifying database data through a structured query language.

Key Points:

1. Only one data mutation (DELETE or UPDATE) is allowed at a given moment.
2. Data mutations rewrite all files containing the data from the UPDATE/DELETE condition.
3. Running DELETE from the table without any condition is possible, but it will be much slower than the DROP TABLE table.
4. The syntax is simplified in comparison to Postgres. For example, the SET column=<value> operation doesn’t support sub-SELECT as the value, and the WHERE clause cannot contain sub-SELECT.

Currently, we support the following SQL mutations:

Update

UPDATE table SET column1 = expression1, column2 = expression2 ... WHERE conditions;

Delete

DELETE FROM table WHERE conditions;

COPY FROM with Endpoint

We have upgraded the functionality for COPY FROM queries to include the endpoint URL. ​⁠It allows you to copy data from S3-compatible solutions other than S3, e.g., Google Cloud Storage.

COPY table_name FROM 'file_path' (AWS_CRED(AWS_REGION 'aws_region', AWS_KEY_ID "
      "'key_id', AWS_PRIVATE_KEY 'access_key', ENDPOINT 'endpoint_url'));

Example endpoints:

● AWS S3 Bucket in us-east-2 zone – s3.us-east-2.amazonaws.com.
● Google Cloud Storage – https://storage.googleapis.com.

Set and Show

Support is now provided for two queries: SET and SHOW. These commands provide a convenient way to set and retrieve specific options and their current values.

This support includes the following options:

● extra_float_digits – set extra digits for floating-point numbers.
● application_name – set a custom name for the application.
● timezone – set the time zone.
● client_min_messages – set the message levels.
● search_path – set namespaces.

SET

SET <option> TO <value>;

SHOW

SHOW <option>;

Experience the latest features of Oxla by trying our BETA version. It’s quick, easy, and a single node is free of charge. In just 2 minutes, you’ll have access to all the new features we have to offer. We value your feedback, so please don’t hesitate to let us know what you think by emailing us at [email protected].