Change Log¶

0.8.0 (2024-09-03)¶

Features

• SELECT supports simple expr, ex: a + 10 a - b #12
• SELECT supports AS
• Support operators: >, >=, <, <=, !=, <> #13
• WHERE expression supports having the field on the right side, ex: 5 < id
• xdb-cli creates a default memory database, allowing you to directly create tables for practice.
• Support CMake

Improvements

• Optimize INSERT UPDATE DELETE auto-commit performance for in-memory database

Test

• Refactor benchmark test framework and support binding cpu core
• New crossdb and SQLite benchmark test driver
• Add C++ STL Map and HashMap(unordered_map) benchmark test driver
• Import unit test framework
• Add few test cases

Bug Fixes

• Fix bug #15 Segmentation fault occurs while using on-disk database
• Fix close connection then reopen connection will cause previous connection use-after-free issue and memory leak issue
• Fix query misses issue during hash index rehashing

0.7.0 (2024-08-26)¶

Features

• UPDATE SET clause supports simple expression, ex: SET val=val+5 SET val=a-b
• UPDATE SET supports prepared statement
• INSERT supports prepared statement
• New APIs: xdb_bexec, xdb_vbexec, xdb_stmt_bexec, xdb_stmt_vexec, xdb_clear_bindings

Improvements

• INSERT parser avoids malloc
• UPDATE only updates affected indexes
• Optimize INSERT UPDATE DELETE auto-commit performance for in-memory database

Test

• Improve benchmark test
• Add SQLite benchmark test

Bug Fixes

• Fix hash index infinite loop issue
• Fix bench test time unit ns to us

0.6.0 (2024-08-18)¶

Initial refactor release

• This project was redesigned and rewritten from scratch for over one year
• Standard RDBMS model
• New SQL APIs which can support more language
• MySQL style SQL and shell, which will be easy to study.

0.5.0 (2023-06-26)¶

Features

• CrossDB command line tool crossdb-cli is released
• Optimize insert/update/query/delete performance
• Add new API cross_matchCreate and cross_matchFree
• DML APIs supports cross_fields_h and cross_match_h

Bug Fixes

0.4.0 (2023-06-20)¶

Features

• Support FreeBSD(X64)
• Optimize insert/update/query/delete performance
• Add new API cross_fieldsCreate and cross_fieldsFree

Bug Fixes

0.3.0 (2023-06-13)¶

Features

• Support MacOS (X64 and ARM64)
• Change CROSS_DB_XXX to CROSS_XXX

Bug Fixes

• cross_dbTblCreate flags CROSS_DB_RBTREE doesn't create Primary Key Index type correctly

0.2.0 (2023-06-07)¶

Features

• Support Windows
• Support Linux ARM64

Bug Fixes

0.1.0 (2023-06-03)¶

• Initial release