I also read this sentence and my immediate thought was that I would only use three exclamation marks in the documentation for a database engine to say something like "TWICE AS MUCH test coverage!!!"
If I want a fast database, I will just write my data to /dev/null. It has well-understood data durability guarantees and is very quick to write to.
Re:LiteTree: SQLite with Branches
by da_chicken on Wednesday August 29, 2018 @10:39AM
(#17868521)
I prefer /dev/urandom or /dev/zero. They have a much higher likelihood of returning the data I wrote.
True! For maximum I/O efficiency, obviously you write to /dev/null and read from /dev/urandom.
Re:LiteTree: SQLite with Branches
by stuffchunk on Wednesday August 29, 2018 @02:20PM
(#17870397)
Just how I like my CQRS!
No, no, /dev/urandom is really slow...
Re:LiteTree: SQLite with Branches
by blattimwind on Wednesday August 29, 2018 @02:40PM
(#17870552)
> In this benchmarking test are the data durability guarantees the same for both LiteTree and vanilla SQLite?
Who cares if you get more bongoliomarks.
Looks like the speed comes from using lmdb rather than sqlites own storage layer.
I first read this as
IMDd for Internet Movie Database and got confused, but probably you mean
LMDB for Lightning Memory-Mapped Database,
which makes much more sense. :)
Re:LiteTree: SQLite with Branches
by JetSpiegel on Wednesday August 29, 2018 @11:48AM
(#17869137)
lmdb != Imdb
Check your fonts if those two look the same.
Re:LiteTree: SQLite with Branches
by bluecarbuncle on Thursday August 30, 2018 @12:54AM
(#17874180)
I wonder if they got the inspiration from https://github.com/LMDB/sqlightning
Re:LiteTree: SQLite with Branches
by checker659 on Wednesday August 29, 2018 @12:56PM
(#17869768)
But, AFAIK, lmdb is not write optimized (as opposed to something that uses LSM trees like levelDB).
In my experience, claims like these usually end up showing that the author didn't understand the `PRAGMA synchronous` setting at all, or they chose to ignore it to juice their stats.
In this benchmarking test are the data durability guarantees the same for both LiteTree and vanilla SQLite?