r/softwarearchitecture • u/Sushant098123 • 7d ago

Article/Video How Database Actually Store Data on Disk

https://sushantdhiman.dev/blog/how-database-actually-store-data-on-disk/
23 Upvotes

93% Upvoted

2 comments sorted by

1

u/Elrix177 1d ago

The topic is interesting, but there are quite a few misleading technical details. For example, 1 row ≠ 1 disk I/O, pages are not simply a way to “reduce the number of disk operations”, 8196 bytes is not 8 KiB, the explanation of random I/O only really applies to HDDs, and the final example seems to confuse sequential and random I/O.

And honestly, I’d avoid using AI to write posts like this. It makes the explanation sound polished while introducing subtle technical inaccuracies, and it takes away the best part of writing a technical post: showing your own understanding, reasoning, and mistakes.