3 ms·
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. Al
by postila 10y ago
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-postgresql-john-de-goes https://www.linkedin.com/pulse/mongodb-32-now-powered-postgr... was simply epic.
- gortiz 10y agoAnother 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!
- ahachete 10y agoIndeed, 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).
- eb0la 10y agoI'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.
- gortiz 10y agoGreat! 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!