doltlite v0.50.15

DoltLite - Version Controlled SQLite

Release notes

Improved integrity-check and index performance, and fixed concurrency, schema replay, and transactional query bugs.

## Reliability and correctness

- Fixed version-control operations overwriting concurrent writes or retaining stale working sets.
- Corrected merges, rebases, cherry-picks, and reverts involving column renames, drops, defaults, generated columns, and changed indexes.
- Fixed transactional index scans, descending numeric keys, and NOCASE primary keys containing embedded NULs; preserved active readers across rollback and schema changes.
- Corrected fresh-database commits, reference resolution, and staged state after fast-forward pulls; enabled large chunks over HTTP remotes.
- Incorporated upstream SQLite correctness and security fixes.

## Performance and testing

- Accelerated integrity checks by eliminating redundant chunk scans while preserving content verification.
- Improved pending text-key updates, secondary-index reads, and cache handling; reduced copying for in-memory databases.
- Strengthened concurrency, corruption, fuzzing, and oracle coverage, and tightened nightly performance regression checks.

## Benchmark / SQL workload summary

### In-memory

| Operation | SQLite median total | DoltLite median total | Ratio |
| --- | ---: | ---: | ---: |
| Reads | 10.13s | 11.55s | 1.1× |
| Writes | 2.11s | 3.28s | 1.6× |

### File-backed

| Operation | SQLite median total | DoltLite median total | Ratio |
| --- | ---: | ---: | ---: |
| Reads | 11.36s | 11.90s | 1.0× |
| Writes | 3.55s | 4.06s | 1.1× |
| Autocommit writes | 832.26ms | 2.58s | 3.1× |

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

Share this resource