[CentOS] Question about optimal filesystem with many small files.

Fri Jul 10 20:57:40 UTC 2009
Alexander Georgiev <alexander.georgiev at gmail.com>

2009/7/10, Filipe Brandenburger <filbranden at gmail.com>:
> On Fri, Jul 10, 2009 at 16:21, Alexander
> Georgiev<alexander.georgiev at gmail.com> wrote:
>> I would use either only a database, or only the file system. To me -
>> using them both is a violation of KISS.
>
> I disagree with your general statement.
>
> Storing content that is appropriate for files (e.g., pictures) as
> BLOBs in an SQL database only makes it more complex.
>

Please, explain why. I was under the impression that storing large
binary streams is BLOB's reason to exist.

> Creating "clever" file formats to store relationships between objects
> in a filesystem instead of using a SQL database only makes it more
> complex (and harder to extend!).

Indeed.

> Just because you are using less technologies doesn't necessarily make
> it simpler.

Of course, but if one of those technologies can provide both
functionalities without hacks, twists and abuse, I would stay with
that single technology.