SQLite's safe mode is not comparable to LMDB's; SQLite is vulnerable to silent data loss in a crash.
https://wisdom.cs.wisc.edu/workshops/spring-14/talks/Thanu.p...
LMDB is not.
Isn't this from the paper "all filesystems are not created equal"? [1] If you search the tables for "sqlite-wal" you will see that it shows zero vulnerabilities.
[1] https://www.usenix.org/system/files/conference/osdi14/osdi14...
For my purposes as an application developer, I care about comparing databases operating in safe mode i.e. a system crash should never cause total data loss. According to my experience SQLite's safe mode is many times faster than LMDB's safe mode, with a write workload. While LMDB is thrashing the disk and achieves only a handful of write transactions per second.