v0.1.15

Added

• limit in SQL Query now support negative number, which return last n rows instead top n rows for positive number, the common SQL

SELECT * FROM (
    SELECT * 
    FROM your_table 
    ORDER BY ts DESC 
    LIMIT 10
) AS subquery
ORDER BY ts ASC;

can be simplify to

SELECT * FROM your_table ORDER BY ts ASC LIMIT -10;

Fix

• Fix performance regression of large object query.

v0.1.14

Fix

• Fix serde issues in table

v0.1.13

Added

• Support for multiple channel workers/senders to improve message processing throughput.
• Custom delimiter configuration option when importing CSV files.
• Support for Decimal type in SQL parsing.

Changed

• Query worker now returns an empty table instead of an error when the requested object is not found.
• Optimized performance of clearing/deleting table contents.
• Upgraded workspace crate dependencies (including axum, sqlparser, and others).
• Fixed compiler and binding warnings in Python and TypeScript bindings.

Fixed

• Fixed import failure for Key-Value (KV) engine tables.

v0.1.12

Added

• Key-value (KV) storage engine mode support (WITH (engine='kv')) for simple point lookup/mapping tables, bypassing background workers, caches, and partitions.
• Integration tests for KV engine mode verifying SQL table creation, inserts, deletes, point queries, and wildcard operations.
• Reference documentation for KV engine mode in the SQL interface guide.
• Developer design/architecture documentation.
• Column unit attribute support.
• Channel update notifications count in Notify.
• Broker configuration in application state.
• Chinese (README.cn.md) translation.

Changed

• Enhanced channel notification/trigger updates implementation.
• Improved CSV parser to support empty line handling.
• Improved Variant parser to support empty value handling.
• Optimized concatenation functionality in python binding.
• Added pre_join_hook during table load.
• Upgraded workspace crate dependencies and bumped version configurations.

Removed

v0.1.11

Added

• Python doc

Changed

• Fix insert order

v0.1.10

First github release