Dolt 2.0 is the second major release of Dolt. It includes all the performance improvements and new features of Dolt 1.x releases in the 3 years since the 1.0 release, as well as several major milestones:
- Automatic garbage collection on by default
- Archival storage on by default
- Faster than MySQL on sysbench
- Beta support for Vector data
- Adaptive storage for TEXT, JSON, GEOMETRY, and BLOB types (similar to TOAST in Postgres)
Dolt 2.0 is backwards compatible with all 1.x releases of Dolt. Databases written by 2.x releases will not be readable by 1.x clients in all cases.
Merged PRs
dolt
- 11019: .github/actions/setup-go-toolchain: Make a common toolchain setup action which go test and bats test workflows can depend on.
This is responsible for installing Golang toolchain and getting ICU4C in the environment so it can be used. - 11017: flip flag for adaptive encoding
Closed Issues
Performance
| Read Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| covering_index_scan | 1.93 | 0.54 | 0.28 |
| groupby_scan | 13.46 | 9.91 | 0.74 |
| index_join | 1.52 | 1.86 | 1.22 |
| index_join_scan | 1.5 | 1.32 | 0.88 |
| index_scan | 34.33 | 22.28 | 0.65 |
| oltp_point_select | 0.2 | 0.25 | 1.25 |
| oltp_read_only | 3.82 | 5.0 | 1.31 |
| select_random_points | 0.35 | 0.5 | 1.43 |
| select_random_ranges | 0.39 | 0.56 | 1.44 |
| table_scan | 34.95 | 22.28 | 0.64 |
| types_table_scan | 75.82 | 47.47 | 0.63 |
| reads_mean_multiplier | 0.95 |
| Write Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| oltp_delete_insert | 8.43 | 6.43 | 0.76 |
| oltp_insert | 4.18 | 3.13 | 0.75 |
| oltp_read_write | 9.06 | 11.04 | 1.22 |
| oltp_update_index | 4.18 | 3.19 | 0.76 |
| oltp_update_non_index | 4.18 | 3.02 | 0.72 |
| oltp_write_only | 5.28 | 5.99 | 1.13 |
| types_delete_insert | 8.58 | 6.67 | 0.78 |
| writes_mean_multiplier | 0.87 |
| TPC-C TPS Tests | MySQL | Dolt | Multiple |
|---|---|---|---|
| tpcc-scale-factor-1 | 93.16 | 45.32 | 2.06 |
| tpcc_tps_multiplier | 2.06 |
| Overall Mean Multiple | 1.29 |
|---|