Hacker News Reader

Comment by postila | Hacker News Reader

It's so funny to hear sometimes that noSQL is better that SQL databases and see how much more powerful tools can be built using old good relational engines.

Also, this story a year ago story https://www.linkedin.com/pulse/mongodb-32-now-powered-postgr... was simply epic.

View on HN

Another ToroDB developer here! What you say is one of the things we always repeat: is it really necesary to reinvent the wheel? relational databases have been here since several decades and they have improved from then!

Indeed, MongoDB BI connector v1 was based on PostgreSQL. However, they used 9.4's foreign data wrappers and since those could not push down query clauses, the connector itself introduced a significant performance degradation (on top of MongoDB's current performance difference when compared to Stampede/PostgreSQL).

I've tried that connector and decided against using it. The problem was you had to define your schema by hand and in mongo sometimes you have legacy data records with different semantics.

In my case it crashed Tableau data import after 45 minutes because it blindly sent data that shul have been NULLIFIED.

Will take a look at the way Stampede does the transformation. It might suit us.

Great! We are looking forward to hear from your experience! Open a ticket on github or email us if you find problems or do you think there is something we can improve!

Reply on news.ycombinator.com