Tutorial

We have re-started working on the storage part to make it more understandable. As the tutorial is not in a complete stage, we would postpone the release to the end of next month.

Storage

In this week, we fixed several bugs in the storage engine. We separated RowSetBuilder with RowSetWriter, so as to make the codebase easier to understand. Most importantly, we have added a new run-length encoding for our storage layer. The PR is currently under review, and will be merged soon.

• fix(storage): fix panic when finishing an empty blob builder (fix(storage): fix panic when finishing an empty blob builder. #489)
• fix(storage): skip flush in rowset builder if its empty, allow empty (fix(storage): skip flush in rowset builder if it's empty, allow empty finish of column builders. #492)
• fix(storage): ignore errors on shutdown. by arkbria (fix(storage): ignore errors on shutdown. #497)
• fix(storage): filter columns will be skipped incorrectly (fix(storage): filter columns will be skipped incorrectly #504)
• refactor(storage): separate writing from builder (refactor(storage): separate writing from builder. #499)
• feat(storage): support run-length encoding (feat(storage): support run-length encoding #507)

Computing (Optimizer, Planner, Executor)

In this week, we fixed several bugs in the computing engine. Also, there are some changes listed in Miscellaneous.

• fix(planner): group by without aggr calls (fix(planner): group by without aggr calls #500)
• fix(planner): row handler not included when count(*) is used as subexpression (fix(planner): row handler not included when count(*) is used as subexpression #502)
• fix(executor): limit should exit early when offset and limit are both zero (fix(executor): limit should exit early when offset and limit are both 0 #506)
• refactor(executor): experimental support of cancellable query execution (refactor(executor): experimental support of cancellable query execution. #467)

Miscellaneous

We finally support insert into select from syntax in RisingLight. At the same time, we also experimented with some cool technologies like cargo nextest. Also, we added BIGINT datatype support.

• feat(ci): switch to nextest (feat(ci): switch to nextest #490)
• feat(insert): support insert into select from (feat(insert): support insert into select from #487)
• tests: use AsyncDB (tests: use AsyncDB (re #485) #509)
• optimize(cli): optimize the execution time format (optimize(cli): optimize the execution time format and omit to print time on empty query #514)
• feat(types): support BIGINT datatype (feat(types): support BIGINT datatype #518)

Interesting Things...

• We have migrated sqllogictest (https://github.com/risinglightdb/sqllogictest-rs) to the RisingLight project! sqllogictest is a test runner for SQL databases, with config syntax compatible with SQLite’s sqllogictest. sqllogictest is currently being used in RisingLight as unit test runner.
• We have finished all features planned in RisingLight v0.1 roadmap ([Roadmap] RisingLight v0.1 #317), and the code is in its final stage of reviewing. We will release RisingLight v0.1 soon.
• Let's welcome new RisingLight project members @Fedomn!