News for hackers. Stuff that matters.
Re:Bedrock – Rock-solid distributed data by quinthar on Tuesday October 18, 2016 @11:33PM (#12740856)
Re: SQLite's performance -- Can you point to anything that shows SQLite isn't the fastest for some class of query? In my experience (though admittedly I haven't formally benchmarked) it's at least as fast, and generally faster (due to the dramatically reduced overhead to query it over a traditional database server).

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!

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:Bedrock – Rock-solid distributed data by ngrilly on Wednesday October 19, 2016 @02:10PM (#12746189)
Thanks :-)