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.
Also, this story a year ago story https://www.linkedin.com/pulse/mongodb-32-now-powered-postgr... was simply epic.