Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

at the end it says most dbs don’t do this, except some, can someone tell me one that actually does it?


ClickHouse 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.


Fully 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.


PostgreSQL has data checksums, but the option is not enabled by default. More information at: https://www.postgresql.org/docs/current/checksums.html


All 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.


MySQL does it by default (or at least InnoDB does).


Db2, Oracle, Postgres and SQL Server do checksums.




Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: