7 min read
Cahyo Subroto

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 table SET column1 = expression1, column2 = expression2 ... WHERE conditions;


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 <option> TO <value>;


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].

  • beta
  • changelog
  • release summary

Ask a question

This grabbed your attention? Are you curious for more information or seeking relevant resources? Don't miss out—ask your questions in our community!

Take me to Discord

You may also like

Simplify your testing with Mixins in C++
18 min read
Krzysztof Smogór

Simplify your testing with Mixins in C++

Oxla – Using Huge Pages in Linux Applications
33 min read
Wojciech Chlapek

Using Huge Pages in Linux Applications Part 2: Transparent HugePage

Monitoring OXLA cluster using Prometheus and Grafana
14 min read
Marcin Grzebieluch

Monitoring Oxla cluster using Prometheus and Grafana