doltlite v0.50.4

DoltLite - Version Controlled SQLite

Release notes

Go driver URI support and reliability fixes.

### Go

- Added URI filename support, including `file:app.db?lazy_origin=1` for lazy clones.

### Reliability

- Hardened Homebrew release automation and the chunk-source integrity test.

## Benchmark / int-keys (100K rows, Linux x64)

### File-Backed

#### Reads

| Test | SQLite (us) | DoltLite (us) | Multiplier |
|------|------------:|--------------:|-----------:|
| oltp_point_select | 42,644 | 26,503 | 0.62 |
| oltp_range_select | 11,902 | 10,434 | 0.88 |
| oltp_sum_range | 10,635 | 9,062 | 0.85 |
| oltp_order_range | 2,575 | 2,586 | 1.00 |
| oltp_distinct_range | 3,381 | 3,330 | 0.98 |
| oltp_index_scan | 5,899 | 4,546 | 0.77 |
| select_random_points | 11,448 | 10,050 | 0.88 |
| select_random_ranges | 5,387 | 3,919 | 0.73 |
| covering_index_scan | 5,883 | 3,735 | 0.63 |
| groupby_scan | 25,022 | 26,985 | 1.08 |
| index_join | 6,646 | 6,811 | 1.02 |
| index_join_scan | 2,824 | 3,797 | 1.34 |
| types_table_scan | 882,585 | 950,529 | 1.08 |
| table_scan | 1,006,968 | 1,059,392 | 1.05 |
| oltp_read_only | 121,478 | 104,051 | 0.86 |
| Average |  |  | 0.92 |

#### Writes

| Test | SQLite (us) | DoltLite (us) | Multiplier |
|------|------------:|--------------:|-----------:|
| oltp_bulk_insert | 172,728 | 238,216 | 1.38 |
| oltp_insert | 25,860 | 36,816 | 1.42 |
| oltp_update_index | 140,286 | 128,634 | 0.92 |
| oltp_update_non_index | 133,176 | 91,659 | 0.69 |
| oltp_delete_insert | 155,658 | 99,526 | 0.64 |
| oltp_write_only | 130,995 | 88,232 | 0.67 |
| types_delete_insert | 227,835 | 182,608 | 0.80 |
| oltp_read_write | 126,488 | 119,340 | 0.94 |
| Average |  |  | 0.93 |

_100000 rows, median of 5 paired invocations per test; autocommit writes use 9, workload-only timing via host monotonic clock when available._

Share this resource