News for hackers. Stuff that matters.
Re:Show HN: ToroDB Stampede: Automagical MongoDB to PostgreS... by postila on Wednesday November 30, 2016 @01:28PM (#13073266)
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.

Re:Show HN: ToroDB Stampede: Automagical MongoDB to PostgreS... by gortiz on Wednesday November 30, 2016 @01:42PM (#13073420)
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!
Re:Show HN: ToroDB Stampede: Automagical MongoDB to PostgreS... by ahachete on Wednesday November 30, 2016 @01:45PM (#13073454)
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).
Re:Show HN: ToroDB Stampede: Automagical MongoDB to PostgreS... by eb0la on Thursday December 01, 2016 @01:52AM (#13077700)
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.

Re:Show HN: ToroDB Stampede: Automagical MongoDB to PostgreS... by gortiz on Thursday December 01, 2016 @05:37AM (#13078516)
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!