Re:Ask HN: What are some examples of good database schema de...
by jakearmitage on Friday February 14, 2020 @01:49PM
(#22329094)
How the hell do you deal with locks properly on files? Or each file is a row?
[ Parent
| on HN ]
Re:Ask HN: What are some examples of good database schema de...
by contingencies on Friday February 14, 2020 @01:53PM
(#22329142)
Right tool for the job. If you have a write-heavy, rapidly evolving dataset with short publishing times, critical contention considerations, and absolute referential integrity requirements, or a huge dataset where memory efficient access is an issue, SQL may be your friend. But try SQLite before a full-blown RDBMS. See also https://yourdatafitsinram.net/
In the real world, however, most systems do not have this type of requirement.