doltlite v0.50.13

DoltLite - Version Controlled SQLite

Release notes

Improved scan and bulk-write performance, reduced checkpoint overhead, and strengthened version-control and SQL correctness.

## Reliability and correctness

- Fixed concurrent commits overwriting successful peer writes, stale branch references after lock waits, and recovery after a failed commit race.
- Corrected merges involving column renames and drops, generated columns, expression and unique indexes, and full-text indexes.
- Improved interactive rebase ordering, conflict pauses, rollback recovery, and retries; added support for edit steps and keeping or dropping empty commits.
- Fixed historical-query schemas and branch-tip resolution, staging after soft reset, and workspace and constraint-violation reporting.
- Corrected embedded-NUL handling in NOCASE keys, foreign-key collation checks, row-ID allocation, and transaction rollback after pending data spills.

## Performance and testing

- Accelerated large-table and wide-row reads, scans after pending edits, and repeated queries with small caches; reduced cache disruption from large scans.
- Improved bulk updates and deletes, range joins, grouped queries, and default-column backfills.
- Made chunk-index checkpoints incremental, reducing file growth and write overhead for streams of small commits.
- Added nightly SQL hotspot discovery and expanded performance regression, version-control fuzzing, and Dolt oracle coverage.

## Benchmark / SQL workload summary

### In-memory

| Operation | SQLite median total | DoltLite median total | Ratio |
| --- | ---: | ---: | ---: |
| Reads | 10.17s | 11.66s | 1.1× |
| Writes | 1.97s | 3.18s | 1.6× |

### File-backed

| Operation | SQLite median total | DoltLite median total | Ratio |
| --- | ---: | ---: | ---: |
| Reads | 10.73s | 11.80s | 1.1× |
| Writes | 3.76s | 4.31s | 1.1× |
| Autocommit writes | 901.73ms | 2.65s | 2.9× |

_Full nightly results: [performance-report.md](https://github.com/dolthub/doltlite/blob/v0.50.13/performance-report.md#sql-workload-summary)._

Share this resource