LumoSQL - Updating SQLite for the Modern Age
Explore the development of LumoSQL, a fork of SQLite, in this 47-minute conference talk from linux.conf.au 2020. Learn about the project's goals to modernize SQLite for contemporary IoT and application use cases, focusing on multi-writer environments, speed, and high-capacity, internet-connected devices. Discover the initial improvements aimed at enhancing speed and reliability by replacing the internal key-value store with LMDB. Gain insights into the challenges faced during development, including code archeology, benchmarking updates, and maintaining parity with upstream code changes. Understand the future plans for replacing the write-ahead log system with a single-level store and participate in a discussion about potential features and improvements for SQLite users and developers.