Fuzzy.cz

We all know there are fundamental differences between relational and object model - called "object-relation impedance mismatch." If we are going to build relational object model on top of relational database (which is natural if using object-oriented language), we have to solve that difference somehow, and ORM tools are one of the options. But are the often mentioned benefits real?

This article extends an article about reasons to store user files in a database and not in a filesystem, and describes several ways how to do that in PostgreSQL. There are BLOBs, BYTEA columns, custom solutions, and all of them have advantages / disadvantages, so let's investigate them.