questdb

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

APACHE-2.0 License

Stars
13.4K
Committers
152
View Code on GitHub Visit Website View on X
Ecosystems: Grafana, Java, PostgreSQL, C++

Bot releases are visible (Hide)

questdb - 6.6

Published by bluestreak01 almost 2 years 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

questdb - 6.5.5

Published by bluestreak01 almost 2 years 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

questdb - 6.5.4

Published by bluestreak01 almost 2 years 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

questdb - 6.5.3

Published by bluestreak01 about 2 years 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

questdb - 6.5.2

Published by pswu11 about 2 years 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

questdb - 6.5.1

Published by bluestreak01 about 2 years 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

questdb - 6.5

Published by bluestreak01 about 2 years 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

questdb - 6.4.3

Published by bluestreak01 over 2 years ago

Release overview

In this released we focused on delivering quality client libraries as well as stability improvements on the database core. Here is the list of client libraries that support both TLS and ILP authentication:

Gotchas

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

What is new

ILP

CORE

SQL

What we fixed

CORE

SQL

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

questdb - 6.4.2

Published by bluestreak01 over 2 years ago

Release overview

Maintenance release to include important bug fixes and critical features.

Gotchas

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

What is new

ILP

What we fixed

ILP

CORE

SQL

Web Console

AMI

Contributor's Hall of Fame

We want to thank our new contributors:

Full Changelog: https://github.com/questdb/questdb/compare/6.4.1...6.4.2

questdb - 6.4.1

Published by bluestreak01 over 2 years ago

Release overview

Maintenance release to include important bug fixes and critical features. Fixed CVE-2022-21449.

Gotchas

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

What is new

ILP

CORE

What we fixed

SQL

ILP

CORE

Contributor's Hall of Fame

We want to thank our new contributors:

Full Changelog: https://github.com/questdb/questdb/compare/6.4...6.4.1

questdb - 6.4

Published by bluestreak01 over 2 years ago

Release overview

This is the long-awaited release with UPDATE functionality. We fully implemented UPDATE syntax, which is compatible with PostgreSQL.

Gotchas

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

What is new

SQL

CORE

What we fixed

CORE

SQL

HTTP

Contributor's Hall of Fame

We want to thank our new contributors:

Full Changelog: https://github.com/questdb/questdb/compare/6.3.1...6.4

questdb - 6.3.1

Published by bluestreak01 over 2 years ago

Release overview

This is a maintenance release driven by our community with new features. We improved SQL usability with external contributors and also fixed a memory leak for SQL execution.

Gotchas

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

What is new

SQL

  • add support for sample standard deviation stddev_samp() aggregate function #2099 by @iridess
  • add support for unit microseconds (U) in SAMPLE BY statements #1984 by @KevinChen16
  • implement extract(part from timestamp) function #2042 by @bluestreak01, @bziobrowski and @marregui

HTTP

  • support wrapping large numbers into strings to avoid overflow #2115 by @HeZean

What we fixed

SQL

  • allow string casts to number by :: keyword #2109 by @HeZean
  • fix potential stack overflow in PG Wire select and insert cache pooling #2103 @puzpuzpuz
  • eliminate reduce counter race in page frame sequence used by parallel filters #2124 by @puzpuzpuz
  • fix memory leak in cross-join cursor by #2126 @bluestreak01

Migration

  • tolerate missing partition folders in 6.2.1 -> 6.3 migration #2114 by @ideoma

Contributor's Hall of Fame

We want to thank our new contributors:

  • @iridess
  • @KevinChen16
questdb - 6.3

Published by bluestreak01 over 2 years ago

Release highlights

  • The JIT compiler is now enabled by default. The compiler aims at significantly improving execution times for queries with simple arithmetic expressions in where statements. This feature can be disabled by setting cairo.sql.jit.mode to off.

  • The where clause is executed concurrently, which include both JIT-based and function framework based filters. Additionally SQL optimiser takes into account limit values to optimise data passes and optimise memory usage

  • Database backup via filesystem snapshot support has been added for cloud environments, e.g. AWS EBS. This enables live database backups to be inexpensive both in terms of effect on ingestion and SQL execution performance as well as cloud cost. Snapshotting is a three prong process. First, cloud administrators issue statement SNAPSHOT PREPARE, which locks all table readers and flushes filesystem caches to disk (through the sync syscall). Second, administrators can at this point invoke the snapshotting procedure, of their cloud vendor, which can be left to run for however long it needs. Third, statement SNAPSHOT COMPLETE is called to release the readers and should be issued as soon as possible even as the snapshot is being produced. This feature can be disabled by setting cairo.snapshot.recovery.enabled to false.

  • Configuration settings validation is now strict. Unsupported settings and typos cause startup failure (logs are produced with appropriate instructions on how to migrate).

  • Add new functionalities in the web console: SQL formatting and autocomplete table names.

Gotchas

  • If you upgrade 6.2.1 -> 6.3 you cannot go back to 6.2.1 without restoring from backup.

What is new

Storage engine

  • Enable JIT compiler by default #2090.
  • Add asynchronous API for chaining SQL execution components and expose concurrent where clause execution results #1732.
  • Add filesystem snapshotting support for cloud environments. Includes statements SNAPSHOT PREPARE|COMPLETE #1907.

SQL

  • Add cast function to allow casts from string to boolean, e.g. cast('true' as boolean) #2041.
  • Add date_trunc() function to truncate timestamps, e.g.: date_trunc('week', '2022-05-07T02:09:30.111111Z') -> '2022-05-02 00:00:00.0' #2017.
  • Add flush_query_cache() function to clear all Http and PGWire worker caches explicitly by user request #2028.
  • Optimise latest by on symbol column with no index, preventing in many cases a full table scan #2010.
  • Make is null an alias for = null and is not null for != null for null comparisons. This is required to enable integration with 3rd parties, specifically MindsDB #1967.
  • Hide telemetry table from tables() SQL output. This behaviour is governed by setting telemetry.hide.tables #1951.
  • Add sum() function for type long256 #1982.
  • Add comparison operators for type long256 #1943.

ILP

  • Allow users to change the default column type (done through config settings e.g. line.integer.default.column.type) when ILP adds a new column automatically #2040.

PGWire

  • Add config setting pg.security.readonly to toggle read-only mode #2021.

HTTP

  • Use status code 400 to indicate errors. Prior to this change, status 200 would be returned regardless #2039.
  • Add geohash support for CSV import and export #1971.

Web Console

  • Add SQL formatting feature #1999.
  • Add link to Slack community in web console #1962.
  • Support query and executeQuery URL params for inserting and executing queries in web console #1927.

Miscellanea

  • Index rebuild, string col index recover utils #1978.
  • Made config settings validation optional, but enabled for new installs #2047.

What we fixed

Storage engine

  • Always test the existence of a table by checking the filesystem #2046.
  • Fix metadata validation to avoid occasional errors while adding new column #2054.
  • Fix reader reload after truncate table #2022.
  • Handle buffer overflow in async command queue #2008.
  • Handle Table writer commit error in ILP #1989.
  • Fix alter table queue overflow error #1959.
  • Follow-up fix for o3 commit lag shift #1934.
  • Load text_loader.json as a file when it cannot be found as a resource #1929.
  • Writer supports notification callbacks when table is extended #1961.
  • Solve a race condition that happened in ILP #1908.

SQL

  • Jit to handle bind sql context change #2053.
  • Fix timestamp designated timestamp column data type validation #2038.
  • Ignore null literals for non-nullable types #2000.
  • Fix brace matching inside cast #2036.
  • Fix ignored where clause (order by hour) #2027.
  • Fix designated timestamp filter with now() function applied incorrectly in some cases #2014.
  • Parsing ALIGN TO CALENDAR; with semicolon at the end #2013.
  • Fixed set operations/distinct and column pushdown #1956.
  • Limit implicit string, symbol -> timestamp cast to constants to fix expressions like symbol = int #1977.

ILP

  • Log parsing error on disconnect when disconnect on error is enabled #2085.
  • Tolerate space symbol at the line end #1940.
  • Add default values for ILP props #1945.
  • Race between schema inference and schema mutation could corrupt data #2081.

PGWire

  • Rudimentary support for COPY FROM via pgwire #2061.
  • Fix persistent function parser issue #1997.
  • Passing boolean as 1 and 0 bytes over binary wire protocol #1941.

HTTP

  • Fix memory leak in REST API #1983.

Web Console

  • Bump minimist from 1.2.5 to 1.2.6 #1988.
  • Bump node-forge from 1.2.1 to 1.3.1 #2003.
  • Add appendAt option to appendQuery #2024.
  • Another appendQuery erroneous case #1994.
  • QueryPicker to support nested structure #1992.
  • Adjust regex to allow brackets in editor tokens #1985.
  • Fix unresponsive ui on hidden tables #1963.
  • Error highlighting on selections #1965.
  • Fix copy to clipboard for safari #1960.
  • Fixed conditional update of Web Console from RT package #1957.
  • Add help button in web console #1952.
  • Remove redundant console.log #1932.

Miscellanea

  • Fix trailing digits in double conversions #297, #2055.
  • Added timeout rule to help troubleshoot ci test freezes #2044.
  • Fix flaky query cache flush tests #2035.
  • Remove outdated comment #2033.
  • Add two tests to exemplify use of java.sql.Timestamp with micro precision #1995.
  • Validate server Properties #1998.
  • Stress o3 commit #1990.
  • Assert ts column size #1987.
  • Fixed logging and status reporting for windows service mode #1969.
  • Handing corrupt _txn file in Mig620 #1933.
  • Fixed PG ODBC driver compatibility problems #2031.
  • Fixing code coverage in build #2100.

Documentation

  • Updated URLs to Web Console docs #2049.
  • Updated try questdb section in readme #2051.
  • Added instructions to build with the web console #2032.
  • Updated CMake build instructions #1922.
  • Remove section about commit squashing #1924.
  • Fix contributor badge #2084.

Contributor's Hall of Fame

We want to thank our new contributors:

questdb - 6.2.1

Published by bluestreak01 over 2 years ago

What is new

  • ILP: added multi-queue support to accelerate multiple table ingestion (#1869)
  • ILP: added a configuration for ILP to disconnect on error (#1868)
  • HTTP: unhandled errors in health check endpoint influence health status (#1872)
  • HTTP: added a flag to report JIT compilation status in REST API (#1836)
  • UI: added an icon for successful query execution with JIT compiler (#1842)
  • SQL: optimize order by designated timestamp desc with filter (#1852)
  • SQL: added new syntax drop table if exists <table-name> (#1839)

Bug fixes

  • ILP: ILP type conversions (#1892)
  • ILP: reduced default ILP connection pool capacity (#1903)
  • ILP: removed aggressive ILP TCP read retry mode (#1837)
  • SQL: rnd_str(iiii) ignores null rate setting (#1899)
  • SQL: fixed order by aliased column positions (#1905)
  • SQL: support for null/prev/linear when a list of values is provided after FILL (#1820)
  • SQL: distinct not applying order or limit; order by removal in sub-queries with the limit clause; outer query ordering skipping (#1893)
  • SQL: fixed parsing of timestamps that have 0 micros (#1887)
  • SQL: fixed UnsupportedOperationException on group by geohash column (#1862)
  • SQL: fixed cast with index parse error (#1859)
  • SQL: partitioning without designated timestamp should not be possible (#1844)
  • SQL: reject the latest by table queries over non-designated timestamp (#1850)
  • SQL: fixed not equals filter on indexed symbol column (#1838)
  • O3: fixed memory leak in 6.2 (#1901)
  • CORE: fixed possible long overflow problem in countdown latch(#1909)
  • CORE: fixed crash when row added out of order, cancelled and then added back (#1851)
  • CORE: fixed TableReader double free events (#1878)
  • UI: fixed errors in WebConsole browser console (#1888)
  • UI: removed devtools warning from web console (#1858)
  • PGWIRE: joins cursor leak in PgWire (#1875)
  • PGWIRE: handle SQL statement blocks in PgWire to make asyncpg work (#1788)
  • PGWIRE: fixed NPE for prepared statements with filters on indexed column (#1825)
questdb - 6.2

Published by bluestreak01 over 2 years ago

Release highlights

  • Major bugfix release with heavy investment in ILP and Core stability by implementing various fuzz tests
  • We introduce SIMD JIT compiler that is able to significantly accelerate the performance of arbitrary WHERE expressions
    (JIT is disabled by default and is limited to supporting primitive column types and their expressions, excluding function calls)
  • We significantly optimised LIMIT queries, specifically around fetching the most recent records of time series and aggregating top records
  • We introduced new syntax LATEST BY in SQL with more predictable and easy-to-understand behaviours
  • We simplified the configuration of network connection limits
  • We improved memory management to prevent QuestDB RAM usage from ballooning
  • We support JDK17 and use it in Docker image

A detailed walk-through of these highlights can be found in this blog post.

What is new

  • SQL: optimize queries with sort and limit by using fixed-size tree chain (#1736)
  • SQL: new LATEST BY syntax (#1739)
  • SQL: Just-in-time Compilation for simple filter expressions (#1592)
  • SQL: optimize getting last X rows by designated timestamp (#1748)
  • UI: implement Tree component to handle hierarchical views (#1710)
  • UI: table autocomplete in SQL editor (#1744)
  • CORE: allow disabling query caches (#1735)
  • CORE: detect and report file system type for the database location (#1725)
  • CORE: java 17 support (#1674)
  • ILP: removed 30s delay on ILP before data appears in table (#1731)
  • CONF: renamed network configuration properties to make names more intuitive (#1819)
  • CONF: automatically derive IODispatcher configuration from a single parameter (#1810)

What we fixed

  • SQL: apply filter before latest by when index is present (#1774)
  • SQL: fix incorrect results returned by latest by queries that have a sub-queries in the where clause, such as in (select ...) filters on a symbol column (#1747)
  • SQL: throw exception if order by expression is not in select list (#1743)
  • SQL: bind variable creation wasn't using correct execution context (#1742)
  • SQL: improve error message for o3 insert on non-partitioned table (#1708)
  • SQL: average function overflow for LONG column type (#1824)
  • SQL: support timestamp formats used by python drivers (#1816)
  • SQL: fix assertion for static symbol table (#1799)
  • SQL: support latest by over sub-query (#1796)
  • SQL: fixed crash to do with variable-length columns address/size adjustment (#1782)
  • SQL: fixed possible crash on SQL execution pipeline (#1782)
  • CORE: fixed consistency issues when reloading TableReader under contention (#1800)
  • CORE: check value block offset for sparse keys (#1776)
  • CORE: various failures when column sizes are near page size (#1727)
  • CORE: re-tagging DirectLongList instances with site of their use (#1722)
  • CORE: fix reader and txn scoreboard leak (#1759)
  • CORE: fixed race condition releasing (and potentially leaking) table reader (#1746)
  • CORE: fix o3 commit corrupts data in var columns (#1734)
  • CORE: reduces chances of "table busy" error message (#1695)
  • CORE: convert address to network order to fix tcp/udp binding on windows (#1780)
  • CORE: remove c++ runtime/stdlib dependency (#1761)
  • CORE: remove unnecessary object allocation (#1794)
  • CORE: cleaner algo to resolve race condition between pool return and close (#1821)
  • CORE: fix scoreboard race for new table readers (#1811)
  • CORE: fixed incorrect _txn content to be occasionally written to the file (#1805)
  • CORE: sleep bug (#1801)
  • CORE: remove unnecessary object allocation (#1794)
  • CORE: resolving high CPU utilisation at idle (#1791)
  • CORE: fixed windows dependency on mingw
  • O3: making txn release by TableReader more robust (#1766)
  • O3: partition purge logic (#1778)
  • ILP: fixed potential table corruption for cases with large number of ingested tables (#1767)
  • ILP: default partitioning for tables created by udp ilp (#1827)
  • ILP: case insensitivity for table names via ILP (#1826)
  • ILP: commit pending rows after a timeout if no further ingestion (#1731)
  • ILP: preventing occasional data corruption when input contains duplicated columns (#1696)
  • HTTP: adjusts column order during csv import (#1789)
  • PGWire: added support for asyncpg client (#1751)
questdb - 6.1.3

Published by bluestreak01 almost 3 years ago

Release highlights

This release adds Prometheus Alertmanager support, new counters in the Prometheus endpoint for memory information, automatic query timeout, Monaco as the new SQL editor for QuestDB's web interface, and various UI additions. Alongside new features, this release fixes bugs in binary search and improves stability relating to filesystem sync and crashes when using ILP. These features and fixes enhance the system's usability, flexibility, and stability.

What is new

  • CORE: expose memory counters to Prometheus endpoint (#1630) Bolek Ziobrowski
  • LOG: add critical level to be used for alerting (#1663)
  • LOG: log writer for Prometheus Alertmanager (#1588)
  • SQL: process ALTER TABLE SQL when writer is busy in ILP (#1504)
  • SQL: enhance type compatibility check to extend numeric conversions (#1627) Bolek Ziobrowski
  • SQL: query execution timeout (#1637)
  • SQL: specify index block size in alter table alter column add index (#1628) Bolek Ziobrowski
  • SQL: SQL for bulk insert (#1603) mkaruza
  • UI: change SQL editor to monaco - vscode core (#1610)
  • UI: add column type to grid (#1621)
  • UI: collapsible table schema panel (#1593) Enol

What we fixed

  • CORE: double and float parsing #1615 (#1626) Bolek Ziobrowski
  • CORE: fixed binary search bugs (#1650)
  • O3: fixed crash, which is to do with incorrectly sizing input data (#1654)
  • ILP: handling of duplicate fields and tags in a message (#1213)
  • ILP: handling of duplicate timestamps (#1608)
  • ILP: race condition between ILP and DDL via HTTP or PG (#1618)
  • ILP: reject null fields when table does not exist (#1686)
  • ILP: sanitize table name to avoid FS corruption (#1605)
  • HTTP: allow single row csv import (#1655)
  • HTTP: fixed serialization of float infinity to json (#1622)
  • SQL: fixed support for UTF8-encoded table names and columns in metadata (#1623)
  • SQL: tweak hash function to speed up FastMap (#1647)
  • SQL: ALTER TABLE ADD COLUMN parse error #1612 (#1634) Bolek Ziobrowski
  • SQL Column alias 'time' is now supported (#1602) mkaruza
  • SQL: allow column names with spaces (#1617)
  • UI: update favicon.ico url (#1606) Eric Schultz
questdb - 6.1.2

Published by bluestreak01 almost 3 years ago

Release highlights

This release includes bug fixes for cases when tables were locked on concurrent reads, and provides stability fixes on transaction file reads. Also included is a new partition by HOUR strategy that offers greater granularity when working with larger data volumes.

What is new

  • SQL: support count(1) syntax (#1555)
  • CORE: partition by HOUR (#1571)

What we fixed

  • UI: fix create table schema syntax (#1587)
  • UI: smaller notifications (#1566)
  • UI: editor shortcuts (#1564)
  • SQL: NPE in the latest by with symbol filter (#1586)
  • SQL: correct execution of SQL with multiple LATEST BY columns (#1478)
  • SQL: treat zero char as empty string literal (#1550)
  • CORE: fix table locked on concurrent reads and create table (#1576)
  • CORE: fixed errors with truncate() and addIndex() (#1567)
  • CORE: more stable txn read on reader reload (#1557)
questdb - 6.1.1

Published by bluestreak01 almost 3 years ago

Release highlights

This release focuses on stability and bug fixes through further testing and error prevention. All known stability issues relating to InfluxDB Line Protocol are resolved, with new functionality provided by SQL additions.

What is new

  • SQL: left()/right() SQL string function implementations (#1479)
  • SQL: ceil() and floor() functions (#1526)
  • SQL: add strpos() function (#1506)
  • SQL: support constant expression in sample by period (#1519)

What we fixed

  • UI: make refresh button execute correct query (#1524)
  • UI: enable tooltips for charts (#1523)
  • UI: show partition and timestamp info in table schema pane, add to context menu action (#1508)
  • UI: virtual renderer for the table schema pane (#1509)
  • UI: save panel position in console in local storage (#1518)
  • CORE: fix allocate() in Darwin to do absolute size allocation (#1540)
  • CORE: fixed memory order when reading transaction file (#1522)
  • CORE: fixed fanout race condition (#1496)
  • CORE: 6.1 migration issues (#1494)
  • CORE: fix bitmap index writer under-sizing value file (#1488)
  • CORE: remap error on open symbols when 16k page block is filled exactly (#1491)
  • CORE: fixed arithmetic issues calculating row counts during asynchronous O3 ingestion (#1474)
  • CORE: inconsistent reads when column is removed and added back under the same name
  • CORE: fix stack overflow in concurrent FanOut.and() (#1460)
  • CORE: Fix oops compression status (#1463)
  • O3: crash fix (#1516)
  • O3: o3 copy to use index block capacity (#1548)
  • O3: fix mmap offset page alignment (#1542)
  • O3: possible crash when O3 move uncommitted processes columns with tops (#1453)
  • ILP: fix sender encoding, fix parser to handle table name with spaces (#1473)
  • ILP: Boolean to number conversion for TCP (#1418)
  • SQL: Fixed cast as column name (#1502)
  • SQL: fix union all with all literals (#1512)
  • SQL: fixed column index dereference in latest by SQLs (#1501)
  • SQL: fixed error in dump_thread_stacks() (#1546)
  • SQL: fixed column index dereference in latest by SQLs (#1500)
  • SQL: fixed error with count() in non-keyed vector aggregations (#1457)
questdb - 6.0.9

Published by bluestreak01 almost 3 years ago

Release highlights

Fixed ILP server crash under high rate of new symbol values. Improved ILP performance by throttling reload of symbol tables and reducing number of system calls.

What is fixed

  • ILP: refactored UDP and TCP senders to avoid confusing inheritance (#1445)
  • ILP: fixed unsafe memory access error (#1441)
questdb - 6.0.8

Published by bluestreak01 about 3 years ago

Release highlights

Improved ILP parser based on internal testing and customer feedback. UI improvements to remove query execution pop-ups. Added problem diagnostic methods.

What we fixed

  • ILP: ILP client to escaped quotes in strings fields (#1433)
  • ILP: ILP parser on string partial parsing edge cases (#1409)
  • ILP: support timestamp in fields (#1358)
  • SQL: implemented bind variable for regex function. Fixed expr parser to report unclosed quotes (#1431)
  • UI: last row is missing from ui (#1436)
  • UI: escape table names on Add (#1414)
  • CORE: handle OS process crash on opening txn file (#1428)
  • CORE: make column memory size configurable (#1373)

What is new

  • SQL: dump thread stacks function for diagnostics (#1411)
  • HTTP: add support for schema boolean attribute index, to flag a symbol column as indexed (#1352)
  • UI: reload table list on schema changes (#1425)
  • UI: New notification panel, no more popups (#1334)
  • UI: Copy table schema to clipboard (#1323)
Package Rankings
Top 8.17% on Proxy.golang.org
Top 5.8% on Repo1.maven.org
Related Projects
cpeditor

The IDE for competitive programming | Fetch, Code, Compile, Run, Check, Submit

12 Nov 2019 1,670
serenity

The Serenity Operating System 🐞

02 Dec 2018 28,800