QuasarDB 3.9.8 Beta released

We are very pleased to announce the immediate availability of QuasarDB 3.9.8.

This release is planned to be the penultimate beta before 3.10. It includes several bug fixes and improvements related to query results.

Several features have also been added to fix accidental data duplications or operational-induced data corruptions without shutting down the cluster.

32-bit and 64-bit ARM binaries for Linux are now included with every release.

Get it here!

Fixes and improvements

  • [api] Add an API to verify data integrity remotely
  • [api] Fix potential invalid results for variance, skewness, and kurtosis
  • [daemon] Add an operation to nuke a corrupted bucket without shutting down the server remotely
  • [daemon] Add statistics for write errors
  • [daemon] Correctly support dates before 1970 and beyond 5000
  • [daemon] Fix descriptor usage on systems with a low descriptor limit
  • [daemon] Log when buckets are too large
  • [daemon] Make disks writes more resilient to major failures such as a server shut down
  • [daemon] Make the persisted firehose shard size configurable
  • [query] Add support for duplicate rows deletion
  • [query] Correctly support WHERE != ""
  • [query] Fix an invalid timestamp returned for certain first/last queries
  • [query] Fix GROUP BY results that could be returned as blobs when they are in fact strings
  • [query] Fix invalid error code returned for certain ASOF JOIN queries
  • [query] Fix invalid results for adjacent_count on large queries
  • [query] Fix several GROUP BY issues related to timestamps
  • [query] Fix several incoherences in the way GROUP BY results were given
  • [query] Support tagging at table creation
  • [railgun] Fix a performance problem when inserting in multiple tables
  • [rest] Fix a potential resource leak

by Edouard Alligand

QuasarDB is now an Engage portfolio company

We are very proud to announce that, following our commercial successes in the US, we have officially joined Engage's Spring 2021 Enterprise Go-To-Market program.

Engage is changing corporate innovation and venture capital by introducing a collaborative venture investment model for corporations.

Their partners are AT&T, Chick-fil-A, Cox Enterprises, Delta Air Lines, Georgia-Pacific, Georgia Power Foundation, Georgia Tech, Goldman Sachs, The Home Depot, Intercontinental Exchange (ICE), Inspire Brands, Invesco, Invest Georgia, Tech Square Ventures, and UPS.

by Edouard Alligand

QuasarDB 3.9.7 Beta Released

We are very pleased to announce the immediate availability of QuasarDB 3.9.7.

As we approach the end of the beta cycle, this release bring stability, performance, and quality of life improvements.

Get it here!

Fixes and improvements

  • [daemon] Add an option to unconditionally uncache entries after write
  • [daemon] Add several statistics related to asynchronous pipelines
  • [daemon] Fix a rare issue, when, during writes, previously cached entries may have not properly reacquired the lock for writing
  • [daemon] Greatly improve asynchronous pipelines performance and memory usage
  • [daemon] Improve intra-node recovery on error for ACL permissions lookup
  • [daemon] Significantly improve memory usage for columns containing strings or blobs
  • [dbtool] Improved safety and clarity of low-level shard operations
  • [query] Add cast to int64 support for timestamps
  • [query] Add support for ALTER TABLE RENAME column
  • [query] Add support for PIVOT on all possible ASOF JOINS
  • [query] Experimental support for results deduplication in queries
  • [query] Fix a GROUP BY issues when querying multiple tables
  • [query] Fix an issue related to DELETE … WHERE queries
  • [query] Fix an issue where empty FIND() results would result in an invalid query
  • [query] Greatly improve the performance FIND() when the number of tables is very high
  • [query] Lookup now works on every column type

by Edouard Alligand

QuasarDB 3.8.10 Released

We are very pleased to announce the immediate availability of QuasarDB 3.8.10.

This release brings stability and quality of life improvements.

Fixes and improvements

  • Protocol version 35
  • [api] Properly handle empty partial results
  • [daemon] Add more context to the "invalid depot path" error message
  • [daemon] Fixed a rare issue, when, during writes, previously cached entries may have not properly reacquired the lock for writing
  • [daemon] Name differently the high and low partitions threads
  • [daemon] Properly set the default for the advertized address
  • [daemon] Reset the ACL fetcher on error
  • [daemon] Skip missing buckets when aggregating instead of failing
  • [query] FROM table.column was incorrectly accepted as a valid clause
  • [replication] Properly replicate tags
  • [shell] Fixed a potential segmentation fault when using quotation marks
  • [shell] Fixed invalid format for integers
  • [shell] Log warnings related to the history file instead of displaying them on the console
  • [shell] No output was given when a script file was not properly specified

by Edouard Alligand

QuasarDB Beta 3.9.6 Released

We are very pleased to announce the immediate availability of QuasarDB 3.9.5.


This release further extends the capabilities of FIND() and comes with several quality of life improvements.


Fixes and improvements


  • [api] Fixed an internal error when the direct API was used with the wrong URI
  • [daemon] Fixed a a couple of warning/error log messages
  • [query] FIND() can now be used in (PRE)WHERE clauses
  • [shell] List the type along with the name when doing a prefix get
  • [shell] The direct mode is set automatically at startup

by Edouard Alligand

QuasarDB Beta 3.9.5 Released

We are very pleased to announce the immediate availability of QuasarDB 3.9.5.


This release introduces extended FIND() capabilities, customizable compaction, and several bug fixes.


Fixes and improvements


  • [api] Added a faster, but approximate, tag counting function
  • [api] Added a new compaction mode that is slower, but uses less disk
  • [api] Added an API call to enable or disable auto-compaction dynamically
  • [api] Fixed an issue where prefix get could return more results than the limit
  • [api] Load balancing is now disabled by default
  • [api] The query engine will now transparently parallelize queries to increase performance
  • [api] Trimming and compaction are now two distinct API calls
  • [daemon] Advertised as address will use by default the value of address
  • [daemon] Statistics are now properly restored on startup
  • [dbtool] A summary of execution time is now printed
  • [query] Added support for DROP TABLE IF EXISTS
  • [query] find() can now be used in PREWHERE and WHERE clauses
  • [query] find(tag=t) can now be recursive
  • [query] Fixed a potential GROUP BY crash.
  • [query] Fixed an issue where rows could be partially removed after a DELETE WHERE
  • [query] Fixed an issue where LIMIT would improperly be applied when a WHERE ORDER BY clause is used
  • [query] SHOW TABLE displays the internal column number
  • [replicate] Tags are now replicated with the data during a manual cluster-to-cluster replication
  • [shell] Some integers could be misformatted
  • [shell] You can now change the maximum results count in get_tagged

by Edouard Alligand