LevelDB and RocksDB are not distributed databases. Hence, Brewer's CAP Theorem is inapplicable.
Thanks PlagTag. We have added the "-Wl, --no-as-needed" to our Makefile: https://github.com/facebook/rocksdb/commit/d03f110904682a340137af07264eb8e148e3477d
The simplest answer is probably Berkeley DB, and bindings are a part of the stdlib: https://docs.python.org/2/library/anydbm.html