2009/7/10, Filipe Brandenburger filbranden@gmail.com:
On Fri, Jul 10, 2009 at 16:21, Alexander Georgievalexander.georgiev@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.