Databases vs Filesystem
The cluster centers on debates about whether to store data in databases (like SQLite or RDBMS) versus using the filesystem or flat files, weighing simplicity, performance, reliability, and overkill concerns.
Activity Over Time
Top Contributors
Keywords
Sample Comments
Wouldn’t it be better to keep such files inside a database?
Why "still" ? Is there anything wrong in using the filesystem as a database when it suits to do so ?
Why don't I just keep my data in a database then?
but that big blob is a database. surely it's better than a json file right?
Couldn't you just use sqlite with blobs? Or, you know, use files?
How is NoSQL better than simply using the filesystem?
It seems like the OP really wants to use a database instead of a file system.
Why even have a database - let's just keep the data in CSVs, we can grep it easily, it's all bytes on a disk.
Why not sqlite? put the json in a single column, maybe copy some parts of it or metadata to another two or three. Should be faster than the filesystem for reading multiple rows.
I don't agree that it's easier to store them in filesystem. You'll have to deal with a lot of potential problems: consistency, backup, transactions, replication, corruption. Database solves those problems automatically and as long as you can store everything there, you better do that. Good databases are not that bad at storing blobs.