3 ms·
You can do hierarchical queries in Oracle and now you can in Postgres too[1], but that's a relatively recent innovation and it's still horrible in MySQL[2] IMS
by gaius 10y ago
You can do hierarchical queries in Oracle and now you can in Postgres too[1], but that's a relatively recent innovation and it's still horrible in MySQL[2]
IMS is still a huge seller for IBM and a tiny fraction is periodically reinvented and hyped as the latest and greatest thing (e.g. MongoDB) so there are use cases for which it is still the right tool. I feel dirty for saying "MongoDB" and "right tool" in the same sentence.
[1] http://stackoverflow.com/q/24898681/447514 http://stackoverflow.com/q/24898681/447514
[2] http://stackoverflow.com/q/7631048/447514 http://stackoverflow.com/q/7631048/447514
- tracker1 10y agoThere's always RethinkDB as probably a better example... I don't really dislike MongoDB, I've used it, aware of its' issues, and liked it. I just find RethinkDB's approach much more sane.