You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Transform your NoSQL data from a MongoDB replica set into a relational database in PostgreSQL.
There are other solutions that are able to store the JSON document in a
relational table using PostgreSQL JSON support, but it doesn't solve the real
problem of 'how to really use that data'. ToroDB Stampede replicates the
document structure in different relational tables and stores the document data
in different tuples using those tables.
Installation
Due to the use of different external systems like MongoDB and PostgreSQL, the
installation requires some previous steps. Take a look at out
quickstart in the
documentation.
Usage example
MongoDB is a great idea, but sooner or later some kind of business
intelligence, or complex aggregated queries are required. At this point MongoDB
is not so powerful and ToroDB Stampede borns to solve that problem (see
our post about that).
The kind of replication done by ToroDB Stampede allows the execution of
aggregated queries in a relational backend (PostgreSQL) with a noticeable time
improvement.
A deeper explanation is available in our
how to use section in the
documentation.
Development setup
As it was said in the installation section, the requirements of external
systems can make more difficult to explain briefly how to setup the development
environment here. So if you want to take a look on how to prepare your
development environment, take a look to our
documentation.