4 ms·
Hi kasano. One of the most relevant use cases of ToroDB Stampede is precisely what you say, replacing MongoDB to PostgreSQL ETLs, where you have to design the
by ahachete 10y ago
Hi kasano.
One of the most relevant use cases of ToroDB Stampede is precisely what you say, replacing MongoDB to PostgreSQL ETLs, where you have to design the schema, solve data type conflicts, maybe flatten or discard data, etc. And other problems like real-time replication, managing HA, etc. Stampede addresses all these problems.
While most people may want to use an empty, dedicated database for Stampede, it is not required to do so. Stampede will generate the tables under a schema name that matches the collection name. So as long as there are no name conflicts, you can happily have ToroDB-generated tables alongside your own. Needless to say, this gives you the ability to JOIN information from different data sources.
So sure, go and give it a try! :)