3 ms·

Thanks, that's useful. I know nothing about SQLite's concurrency model, but it's not surprising that it can't compete with Postgres. Does this mean that ActorD

Thanks, that's useful. I know nothing about SQLite's concurrency model, but it's not surprising that it can't compete with Postgres. Does this mean that ActorDB relies on LMDB to replace the WAL? I don't know enough about LMDB either, but I presume it has some kind of redo log.

biokoda 11y ago
Yes ActorDB takes sqlite3.c, takes out the wal.c code and replaces it with calls to LMDB. There is no redo log, LMDB is designed in such a way that it does not require it. It is actually verified as the safest storage engine design out there.
- thesz 11y ago
  Do you have a link on the LMDB verification? What I know is that SQLite IS safe to use even on unsafe file systems. There was a discussion here few months ago (link was from danloo.com).
  - biokoda 11y ago
    https://www.usenix.org/conference/osdi14/technical-sessions/presentation/pillai https://www.usenix.org/conference/osdi14/technical-sessions/...