Remix.run Logo
umpalumpaaa 4 days ago

There was an attempt/experiment to develop SQLite 4: https://sqlite.org/src4/doc/trunk/www/index.wiki

sgbeal 4 days ago | parent [-]

The focus of that experiment was to find out of LSM-based storage[^1] would prove to be faster. It turned out that LSM, for SQLite's workloads, did not provide enough benefit to justify the upheaval.

[^1]: https://en.wikipedia.org/wiki/Log-structured_merge-tree