java使用时序数据库,QuestDB是一个用于快速处理时序数据的开源NewSQL关系数据库...

What is new ?

Migrated to Java 11 (#272). Fixed #154

SQL: vectorized group by hour(timestamp) (#398)

SQL: cancel active read-only queries on client disconnect; added resource constraints (#396)

SQL: vectorized count() execution (#382)

SQL: vector aggregation for time range searches (#380)

SQL: Add all_tables() and table_columns(...) functions (#337)

SQL: show tables and show columns (#334)

SQL: less than join implementation (lt join)

SQL: implement negated and commutative boolean function factories (#266)

SQL: limiting impact of joins on hardware with configuration

SQL: Limit the number of rows returned in HTTP requests (http.security.max.response.rows) (#347)

SQL: improved accuracy of round() by more consistent use of tolerance. The latter is adjusted to be lower. JsonQueryProcessor now prints doubles up to scale of 12. (#301)

SQL: abs(double) implementation + unbranching (#318)

SQL: round() unbranching (#317)

Web console: introduce new color scheme and new layout

Web console: migrate code editor to React + overhaul query result experience (#376)

Web console: migrate grid/chart container to React (#386)

Web console: migrate Footer container to React (#339)

Web console: add custom layout for small screens (#389)

Web console: disable "Import" section when readOnly mode is on (#357)

Web console: add Saved Queries and support for new config file (#352)

Web console: new Schema component - fetch tables and columns from server + add tooltips (#340)

Web console: turn the logo in top left corner into a link (to questdb.io) (#328)

Web console: open documentation links in a new tab - #299 (#325)

Server: added all properties to release server.conf (#384)

Server: tracking requests and bytes per connection, tests for new configuration values, passing FD to execution context (#361)

Server: questdb can be configured to limit the number of in memory rows (#308)

Server: questdb can be configured as globally read-only

What we fixed ?

SQL: order by on column with function throws exception. #288 (#289)

SQL: order by does not validate columns correctly. #284 (#305)

SQL: order by timestamp descending bug. #287 (#306)

SQL: support single character symbol. #279 (#311)

SQL: asof join error unless timestamp is selected (#310)

SQL: support millis timestamp in import (#362)

SQL: support uppercase 'DROP', 'ADD', 'ALTER' in ALTER TABLE. #275 (#276)

SQL: GORM sends ';' after login, making sure we reply to that. (#388)

SQL: PSQL port in docker container and documentation (8892 -> 8812). (#271)

SQL: where clause outside of join sub-query was discarded (failed to properly move inside of sub-query) (#387)

SQL: alter table add column symbol does not respect cached flag - #374 (#385)

SQL: insert as select without nominating timestamp - #364 #349 (#365)

SQL: binary search scan for timestamps (#371)

SQL: avg() ksum() nsum() sum() handling of infinity #313 (#338)

SQL: microsecond timestamp (#335)

SQL: partial/short date in where clause >=, > ,

SQL: timestamp search issue with partial date. Equality fix #323 (#331)

SQL: problem with asof join with where clause. also dangling where statement fix. Fixed #307 (#326)

Web console: disable warning for end of line check (#324)

Web console: remove unused deps/assets which reduces the bundle from 2.1MB to 800KB

Web console: remove unnecessary comma when inserting code in the editor