Questdb Versions Save

An open source time-series database for fast ingest and SQL queries

7.0.0

1 year ago

Overview

:rocket: New Features

This is the Beta release of the Write Ahead Log (WAL) table storage model #2951.

We are always listening to our users, and took to heart your problem of ingestion slowdown with heavy out-of-order data flow. This release provides a comprehensive solution to that.

The reasons why you should switch to WAL are:

  • Consistent ingestion performance, unaffected by out-of-order data processing (2x performance increase on ILP)
  • Concurrent writing via all interfaces. Issues like #1461 are solved for WAL tables.
  • Enables future work on replication. Replication will work with WAL tables only.

The WAL storage model is inactive by default. To create a WAL-based table, the following syntax should be used (note WAL at the end):

create table ABC(x int, t timestamp) timestamp(t) partition by day WAL;

You can also convert your existing table to WAL (followed by an instance restart). The conversion touches table configuration (not data!) and is fully reversible.

To convert an existing table to WAL:

  • alter table ABC set type WAL;
  • restart instance

To convert a WAL table to non-WAL:

  • alter table ABC set type bypass WAL;
  • restart instance

What is new

CORE

SQL

UI

What we fixed

SQL

Full Changelog: https://github.com/questdb/questdb/compare/6.7...7.0.0

6.7

1 year ago

Overview

:rocket: New Features

  • 128-bit UUID column type to make storage and queries more efficient (#2769)
  • explain SQL to show insights into query execution plan (#2680)
  • Trigonometric functions and a performance improvement for SQL queries (#2890)

❗ Breaking changes

  • As of this release, it is strongly discouraged to modify or delete table directories in the db directory or delete table directories while the database instance is still running. It is still safe to do those activities while database is shut down. (https://github.com/questdb/questdb/pull/2752)

  • If multiple database instances share the same db directory, you will now have to declare all but one of them as read-only instances via their configuration. (https://github.com/questdb/questdb/pull/2752)

What is new

CORE

SQL

PGWire

ILP

What we fixed

CORE

SQL

HTTP

New Contributors

Full Changelog: https://github.com/questdb/questdb/compare/6.6.1...6.7

6.6.1

1 year ago

Overview

This is a follow up release for the 6.6. It fixes a serious data consistency issue, introduced specifically by 6.6.

❗ Breaking change

Unless you're upgrading from versions before 6.6, you will be affected by a minor breaking change: commitLag keyword in SQLs is no longer supported in this release. We recommend you remove these keywords and "lag" values and let the system handle things automatically.

What we fixed

CORE

Full Changelog: https://github.com/questdb/questdb/compare/6.6...6.6.1

6.6

1 year ago

Overview

We introduce an automated system, which removes the concept of commit lag thus simplifying capacity planning. Developers don't have to compromise between high ingestion speed and data visibility. Data visibility is instant while ingestion performance is always at its peak.

Additionally, there is a number of important bug fixes that improve system performance and stability.

❗ Breaking change

commitLag keyword in SQLs is no longer supported in this release. We recommend you remove these keywords and "lag" values and let the system handle things automatically.

What is new

CORE

SQL

HTTP

What we fixed

CORE

SQL

ILP

HTTP

Contributor's Hall of Fame

We want to thank our new contributors:

Full Changelog: https://github.com/questdb/questdb/compare/6.5.5...6.6

6.5.5

1 year ago

Overview

This release features an improved migration experience when importing CSV files from PostgreSQL and stability improvements for the Core and SQL engine.

What is new

CORE

SQL

What we fixed

CORE

SQL

Contributor's Hall of Fame

We want to thank our new contributors:

Full Changelog: https://github.com/questdb/questdb/compare/6.5.4...6.5.5

6.5.4

1 year ago

Overview

This release includes new SQL features from our amazing Hacktoberfest contributors as well as performance and stability improvements.

What is new

SQL

string functions:

numeric functions:

others:

Web Console

What we fixed

SQL

CORE

PGWire

ILP

Web Console

Docs

Contributor's Hall of Fame

We want to thank our new contributors:

Full Changelog: https://github.com/questdb/questdb/compare/6.5.3...6.5.4

6.5.3

1 year ago

Overview

This is a maintenance release, which includes important stability fixes and improvements for the SQL engine and core.

What is new

SQL

CORE

Web console

What we fixed

SQL

CORE

PGWire

Contributor's Hall of Fame

We want to thank our new contributor:

Full Changelog: https://github.com/questdb/questdb/compare/6.5.2...6.5.3

6.5.2

1 year ago

Overview

This is a maintenance release focusing on important bug fixes for 6.5.1.

What is new

SQL

What we fixed

SQL

CORE

PGWire

  • recompile cached Update SQL when table structure changed instead of a failure by @jerrinot #2479

AMI

Full Changelog: https://github.com/questdb/questdb/compare/6.5.1...6.5.2

6.5.1

1 year ago

Release overview

This release adds new SQL statements for detaching and re-attaching partitions to tables, enabling cold storage as a solution to the disk size limitation. In addition, we include several fixes and improvements for the overall reliability of the SQL engine.

What is new

SQL

What we fixed

SQL

CORE

HTTP

Full Changelog: https://github.com/questdb/questdb/compare/6.5...6.5.1

6.5

1 year ago

Release overview

This release brings a new algorithm for the SQL COPY statement [Reference], which is specifically designed to enable fast and easy CSV Import for large and unsorted data files. This feature comes in handy when there's a need to migrate a large amount of data from other databases to QuestDB [Guide: CSV import]. In addition, there are several improvements and fixes for the Influx line protocol, Core, and SQL engine.

Gotchas

No gotchas when you are upgrading from the start or 6.3, as it is just a software update. If you're upgrading from 6.2.1 or earlier, please refer to the gotchas of 6.3

What is new

CORE

SQL

What we fixed

CORE

SQL

ILP

PGWire

Full Changelog: https://github.com/questdb/questdb/compare/6.4.3...6.5