ToroDB Stampede

Open source

ToroDB Stampede replicates a MongoDB replica set into relational PostgreSQL tables so the data can be queried with SQL.

GitHub stars
1.8k
Last 30 days
-1(+0%)
Last commit
8 yr ago
Repository age
12 years
Version
v1.0.0
Licence
AGPL-3.0
Self-hosted
Yes

About ToroDB Stampede

ToroDB Stampede takes data from a MongoDB replica set and turns it into a relational database in PostgreSQL. Rather than storing each JSON document in a single table column, it copies the document structure into separate relational tables and puts the document data into rows of those tables.

The stated reason is analytics. The README says MongoDB eventually runs into business intelligence or complex aggregated queries, and that replicating into a relational backend lets those aggregate queries run noticeably faster. It also positions the tool as a way to ease migration from MongoDB to SQL.

Because it relies on both MongoDB and PostgreSQL, installation needs prerequisite steps that are described in the project documentation quickstart. The code is written in Java and distributed under the GNU AGPL v3. Version 1.0.0 was released on October 24th 2018, after three beta releases.

Key features

  • Replicates MongoDB data into PostgreSQL
  • Document structure mapped to relational tables
  • Document data stored as tuples in those tables
  • Aggregate queries run on a relational backend
  • Aimed at MongoDB to SQL migration

Good fit for

  • Business intelligence on MongoDB data
  • Aggregate queries in SQL
  • Migrating from MongoDB to PostgreSQL
Built with
Java tools
Tags
mongodb
postgresql
analytics
replication
sql
migration

ToroDB Stampede: questions and answers

What is ToroDB Stampede used for?
ToroDB Stampede replicates a MongoDB replica set into relational PostgreSQL tables so the data can be queried with SQL. It is a good fit for business intelligence on MongoDB data, aggregate queries in SQL and migrating from MongoDB to PostgreSQL.
Is ToroDB Stampede open source?
Yes. ToroDB Stampede is open source under the AGPL-3.0 licence. Its source code is on GitHub at torodb/stampede and is written mainly in Java.
Is ToroDB Stampede free?
Yes. ToroDB Stampede is open source, so the software itself is free to use.
Can I self-host ToroDB Stampede?
Yes. ToroDB Stampede can be self-hosted on your own server or infrastructure.
What are some alternatives to ToroDB Stampede?
Similar open-source tools in the Data Pipelines & ETL category include Dremio OSS, MetricFlow and Apache Spark. SaaS products in the same category include Oracle GoldenGate, HVR (now part of Fivetran) and Alteryx.
Is ToroDB Stampede actively maintained?
The most recent commit to ToroDB Stampede was on 25 October 2018, and the latest release is v1.0.0, published on 25 October 2018. The project has 1.8k stars on GitHub.

Open-source alternatives to ToroDB Stampede

See all

SaaS alternatives to ToroDB Stampede

See all