Release Notes

This page contains release notes of the released versions of qikkDB.

qikkDB

The released versions of qikkDB (database server) are listed below, along with their main changes.

1.4.1

Release Date: the 23rd of October 2019

Features & Performance:

  • GROUP BY support for unlimited number of unique values in results

  • Block size can be set also per tables

  • Decreased memory (RAM) usage of loaded databases by 30%

  • Decreased memory (RAM) usage when loading databases from disk by 40%

  • Added function DATE() which returns datetime in human readable format

  • Improved speed of queries like SELECT * FROM table LIMIT 10;

  • Added functionality to use GROUP BY without aggregation function

  • Added possibility to rename database / table / column

Bug Fixes:

  • Fixed wrong query results when using OFFSET on single GPU

  • Fixed bug causing different query results when using aliases (AS)

1.4

Release Date: the 25th of September 2019

Features & Performance:

  • Date Functions

  • Numeric Functions

  • String Functions

  • Polygon Functions: Intersect, Union, Contains

  • GROUP BY

  • ORDER BY

  • LIMIT

  • WHERE

  • Nested Loop Inner JOIN (Experimental)

  • Clustered Indexing

  • Aliases

  • NULL Values

  • LRU Caching

  • Logging

  • Configuration File

  • Console Client