lumosql

https://github.com/LMDB/sqlightning https://github.com/LumoSQL/LumoSQL

Have you seen SQLightning and/or LumoSQL? * https://github.com/LMDB/sqlightning * https://github.com/LumoSQL/LumoSQL SQLightning was the initial project combining SQLite3 with an LMDB backend. It seemed to be more an experimental/Proof-of-Concept thing, and isn't maintained. LumoSQL is an alternative project (maintained), providing a SQLite3 front end with various optional storage backends. One of which is LMDB. Note - I'm not affiliated with either project, I just remembered they exist. :)

LMDB and SQLite are not directly comparable. LMDB is a transactional B+tree-based key/value store. SQLite is an implementation of a transactional SQL data model on top of a B+tree-based key/value store, so it is logically at least one abstraction layer higher than LMDB. (Key/value stores underlie pretty much all of the other data models you'll ever use.) That aside - LMDB is not just smaller, faster, and more reliable than SQLite, it is also smaller/faster/more reliable than SQLite's own B+tree implementation, and SQLite can be patched to use LMDB instead of its own B+tree code, resulting in a smaller/faster footprint for SQLite itself. Proof of concept was done here https://github.com/LMDB/sqlightning A new team has picked this up and carried it forward https://github.com/LumoSQL/LumoSQL Generally, unless your application has fairly simp

Just fyi, another dev team has picked up the SQLightning code and brought it up to date: https://github.com/LumoSQL/LumoSQL