News for hackers. Stuff that matters.

A comment on LiteTree: SQLite with Branches. Parent comment

Re:LiteTree: SQLite with Branches by nickodell on Wednesday August 29, 2018 @02:44AM (#17866186)
Are you really comparing the same thing, then? Do you have the same consistency guarantees if the system shuts down unexpectedly?
[ Parent | on HN ]
Re:LiteTree: SQLite with Branches by kroggen on Wednesday August 29, 2018 @03:02AM (#17866278)
When I saw the results I did not believe, so I reviewed the benchmark code. It is basically the same SQL commands being run in normal SQLite and with the branching enabled.

Yes, LMDB is proved to be safe. It is used in many apps and even other DB implementations, including Monero.

What I have not tested is SQLite with WAL (Write-Ahead Log). In this case it may be faster than the default journal mode.

[ Parent | on HN ]
Re:LiteTree: SQLite with Branches by bdukic on Wednesday August 29, 2018 @06:39AM (#17867174)
Yes, it would be nice to see results with WAL, as it's significantly faster in most cases.
[ Parent | on HN ]