5 ms·
SQLite 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 someth
by avinassh 2y ago
SQLite 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.