3 ms·
at the end it says most dbs don’t do this, except some, can someone tell me one that actually does it?
by joseangel_sc 2y ago
at the end it says most dbs don’t do this, except some, can someone tell me one that actually does it?
- ndxf 2y agoPostgreSQL has data checksums, but the option is not enabled by default. More information at: https://www.postgresql.org/docs/current/checksums.html https://www.postgresql.org/docs/current/checksums.html
- taffer 2y agoDb2, Oracle, Postgres and SQL Server do checksums.
- zX41ZdbW 2y agoClickHouse uses and validates checksums for both compressed blocks of data and uncompressed data; it also checksums and validates data during network transfers. Additionally, every replica validates checksums with other replicas when doing deterministic computations. It is the only reasonable way to work with data, and if someone thinks otherwise, I will happily provide motivating examples.
- hodgesrm 2y agoFully agree. There are many bad things that can happen to data. Another good feature is that ClickHouse is fairly tolerant of torn blocks and handles many failures automatically. This fault tolerance actually makes some corner cases hard to illustrate in demos, because ClickHouse repairs them silently. Users never see them.
- bakugo 2y agoMySQL does it by default (or at least InnoDB does).
- rrdharan 2y agoAll the native storage systems at Google do it at every level (block, file, database); I would assume the same is true at AWS and Microsoft.