News for hackers. Stuff that matters.

A comment on Turning SQLite into a Distributed Database. Parent comment

Re:Turning SQLite into a Distributed Database by CRConrad on Monday August 22, 2022 @09:21AM (#32550962)
> With the usual caveats that nobody is manually mucking about with the blob store, that it hasn't "lost" any blobs due to corruption, etc, etc...

Yeah, with those caveats. But how do you make sure they apply? If someone does manually muck about with the blob store, or it does lose blobs due to corruption, then your transaction is retroactively "un-atomicized" with no trace thereof in the actual DB.

[ Parent | on HN ]
Re:Turning SQLite into a Distributed Database by zasdffaa on Monday August 22, 2022 @10:56AM (#32552365)
If corruption happens then any guarantees by the hardware are voided, and the software guarantees (of durability) which are built o the hardware guarantees are equally voided. So corruption -> dead in the water.

But otherwise I agree.

[ Parent | on HN ]