News for hackers. Stuff that matters.
Re:Smaller is better – The rise, fall, and rise of flat file... by rrrrrrrrrrrryan on Sunday May 22, 2022 @01:11PM (#31470418)
> There is no fundamental difference between a database and a flat file, it is all bytes on a disk/memory in the end.

A database has a whole engine, which I'd argue is a pretty fundamental difference.

I think I get what you were trying to say, though: there's no fundamental difference between database tables and flat files, and there's no fundamental difference between a database and a filesystem.

Re:Smaller is better – The rise, fall, and rise of flat file... by hunter2_ on Sunday May 22, 2022 @02:53PM (#31471481)
> there's no fundamental difference between database tables and flat files

But "flat" essentially means "one table that doesn't reference (and isn't referenced by) other tables in a reliable way." It's a way of saying 2 dimensions (flat) versus 3+ dimensions (relational). The moment you start having multiple plain text files where columns act as primary and foreign keys, the system is no longer flat, despite using plain text files.

It seems to me that TFA and most comments here are really just talking about using a DBMS vs using plain text files, not using flat vs using relations.

Re:Smaller is better – The rise, fall, and rise of flat file... by timClicks on Sunday May 22, 2022 @02:50PM (#31471444)
File systems are also "whole engines". Otherwise we wouldn't have named files or directory structures.
Re:Smaller is better – The rise, fall, and rise of flat file... by djrobstep on Sunday May 22, 2022 @08:16PM (#31474133)
How is a filesystem not a "whole engine"?
Re:Smaller is better – The rise, fall, and rise of flat file... by rrrrrrrrrrrryan on Sunday May 22, 2022 @11:27PM (#31475062)
A filesystem is, but a flat file alone is not. That was the only point of my comment - I was just being pedantic.