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.