I’d read this: https://apple.github.io/foundationdb/cap-theorem.html https://apple.github.io/foundationdb/cap-theorem.html And https://apple.github.io/founda

I’d read this: https://apple.github.io/foundationdb/cap-theorem.html https://apple.github.io/foundationdb/cap-theorem.html And https://apple.github.io/foundationdb/consistency.html https://apple.github.io/foundationdb/consistency.html For a summary. Tldr is that FDB provides transactional guarantees similar to an rdbms but can be distributed and has optimistic concurrency, meaning locks are not necessary. In the context of SQLite that’s the main issue it has and FDB is positioned to solve it.