Re:Bedrock – Rock-solid distributed data
by ngrilly on Wednesday October 19, 2016 @07:59AM
(#12742986)
> 2158341079 writes
I'm curious: how do you keep track of this number?
Re:Bedrock – Rock-solid distributed data
by quinthar on Wednesday October 19, 2016 @12:13PM
(#12745093)
Every write transaction ever committed to the database is assigned a unique ID, and the most recent few million transactions are kept in a "journal" table. This is what allows nodes to figure out what happened while they were offline and re-execute the missing transactions. A side-effect of that is we know exactly how many write transactions have ever been committed.
Re:Bedrock – Rock-solid distributed data
by ngrilly on Wednesday October 19, 2016 @01:02PM
(#12745520)
That's a funny side-effect! Should I understand the transaction unique ID is an incrementing number?
Re:Bedrock – Rock-solid distributed data
by quinthar on Wednesday October 19, 2016 @01:54PM
(#12746029)
Correct!
Re:Bedrock – Rock-solid distributed data
by justinclift on Wednesday October 19, 2016 @05:42PM
(#12747952)
Out of curiosity, what's the value that'll wrap around at?
Re: SQLite reliability. I'm confused how SQLite isn't more reliable than every other contender, merely given that there is so much less to fail. In 8 years, 2158341079 writes, and probably 100x that many reads, I don't think I've ever had a single failure or bug with SQLite itself.
Re: SSDs -- That's a fair point. Bedrock is not the ideal choice if you are using small volumes and spinning disks.
Re: Security -- I think all databases have crap security that nobody really relies upon. Bedrock doesn't try to pretend. Rather, it gives you a very complete plugin framework, such that you can write C++ "stored procedures" that enforce your application's security model. In practice, we run with the Bedrock::DB plugin disabled, such that the only way to access the database is via our stored procedures -- and those do complete authentication and authorization in an application-specific way that no database could in a generalized fashion.
Thanks for asking!