News for hackers. Stuff that matters.
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?
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.