Hacker News new | ask | show | jobs
by jakearmitage 2315 days ago
How the hell do you deal with locks properly on files? Or each file is a row?
1 comments

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.