5 ms·
Sqlite is the wrong layer at which to care about storage hardware failures. That would be the job of the disks themselves, the hardware or software volume manag
by bityard 2y ago
Sqlite is the wrong layer at which to care about storage hardware failures. That would be the job of the disks themselves, the hardware or software volume manager, or filesystem.
- avinassh 2y agoSQLite or any other mainstream database like Postgres don't do checksums. Wouldn't you be concerned if you are using it for financial data or medicine or something crucial?
- School-Cotton 2y agoI’d be concerned if a system without ECC ram and disks were being used for something crucial.
- avinassh 2y agoYou would be surprised :) A couple of my friends who work in the financial domain showed surprise at this post - they had no idea this was possible. I guess most people just assume databases 'just work'?
- School-Cotton 2y agoFWIW I said I’d be concerned, not surprised. SQLite isn’t doing anything wrong here, IMO — people who use non-ECC ran for critical workloads are. But people do wrong things all the time, so it doesn’t surprise me.
- GauntletWizard 2y agoIf I could get ECC ram for my consumer hardware, I would - but I'm not paying the xeon tax to store my photos, in addition to the necessary 20% premium for the ram sticks themselves, for my personal workloads.
- pseudalopex 2y agoMost AMD desktop CPUs and some cheap motherboards for them support ECC.
- avree 2y agoYeah, that’s what the SQLite documentation that the OP quoted in their post says.
- GauntletWizard 2y agoI'm much less worried about storage hardware failures than other parts of the process scribbling over memory that sqlite has mapped. Being able to detect incorrect software behavior, regardless of the source, is useful in its own right.