[sime]

A relational database would have been a much better fit for this system.

The author initially states that all relational databases are good for is speed but then goes on to highlight flaws in their object store that could all have been mitigated by using an RDS:

* schema changes without needing to write programs to update all your data

* data aggregation (and in fact any sort of adhoc reporting)

* data storage independence.

There's also no mention of data integrity but this is a big risk as soon as the original authors are no longer involved.

Object oriented data stores are hierarchical/network databases. Relational databases were introduced to replace these years ago and for good reason.

[cmircea]

But... if your data is hierarchical in nature, then trying stuff it into a relational database results in a giant clusterfuck.

Just use the right tool for the job.

[sime]

How so? Modern RDBMS' are more than capable of manipulating hierarchical data.