ToroDB Stampede - Provides better analytics on top of MongoDB and make it easier to migrate from MongoDB to SQL

  •        64

ToroDB helps to 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.

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.

https://www.torodb.com/stampede/
https://github.com/torodb/stampede/

Tags
Implementation
License
Platform

   




Related Projects

SQLToNoSQLImporter - Import data from SQL to NoSQL systems

  •    Java

SQLToNoSQLImporter is a Solr like data import handler to import Sql (MySQL,Oracle,PostgreSQL) data to NoSQL Systems (Mongodb,CouchDB,Elastic Search). Migration is now completely configuration driven. SQLToNoSQLImporter reads from sql databases, converts and then batch inserts them into NoSQL datastore.

NoSQLMap - Automated NoSQL database enumeration and web application exploitation tool.

  •    Python

NoSQLMap is an open source Python tool designed to audit for as well as automate injection attacks and exploit default configuration weaknesses in NoSQL databases and web applications using NoSQL in order to disclose or clone data from the database. Originally authored by @tcsstool and now maintained by @codingo_ NoSQLMap is named as a tribute to Bernardo Damele and Miroslav's Stampar's popular SQL injection tool sqlmap. Its concepts are based on and extensions of Ming Chow's excellent presentation at Defcon 21, "Abusing NoSQL Databases".

mosql - MongoDB to PostgreSQL Streaming Replication

  •    Ruby

MoSQL imports the contents of your MongoDB database cluster into a PostgreSQL instance, using an oplog tailer to keep the SQL mirror live up-to-date. This lets you run production services against a MongoDB database, and then run offline analytics or reporting using the full power of SQL.

quasar - A compiler and columnar analytics engine for a SQL dialect with support for heterogeneous structured data

  •    Scala

Quasar is an open source NoSQL analytics engine that can be used as a library or through a REST API to power advanced analytics across a growing range of data sources and databases, including MongoDB. SQL² is the dialect of SQL that Quasar understands.

MongoDB - NoSQL Document Store Database

  •    C++

MongoDB (from "humongous") is a scalable, high-performance, open source, dynamic-schema, document-oriented database. MongoDB bridges the gap between key-value stores (which are fast and highly scalable) and traditional RDBMS systems.


variety - A schema analyzer for MongoDB

  •    Javascript

This lightweight tool helps you get a sense of your application's schema, as well as any outliers to that schema. Particularly useful when you inherit a codebase with data dump and want to quickly learn how the data's structured. Also useful for finding rare keys. Also featured on the official MongoDB blog.

MongoDB SQL Server Importer

  •    

If you want a quick (but kinda dirty) way to import your SQL Server database to MongoDB, this is your tool. This tool is for those who wants to leverage their existing database to learn MongoDB. It's developed in C#.

UnQLite - Transactional Embedded NoSQL Database Engine

  •    C

UnQLite is a in-process software library which implements a self-contained, serverless, zero-configuration, transactional NoSQL database engine. UnQLite is a document store database similar to MongoDB, Redis, CouchDB etc. as well a standard Key/Value store similar to BerkeleyDB, LevelDB, etc.

grandnode - Free and Open Source Ecommerce Shopping Cart solution based on ASP.NET CORE and MongoDB

  •    CSharp

Thank you for choosing GrandNode! It's an open source, free, cross-platform e-commerce software based on ASP.NET Core 2.2 and MongoDB - NoSQL database. You can run it on Linux, Windows and MacOS easily. GrandNode also supports Docker, so you are able to install it just in a seconds with Docker. It can be used for any kind of online store. GrandNode is a perfect choice for people who want to sell simple products. It's solution dedicated for the most demanding users. You can also create auctions, booking/reservation products or product kits. GrandNode became a mature solution especially for developers who want to develop a modern, functional and high performance e-commerce system.

Mongify - Data translator system for moving your SQL data to MongoDB

  •    Ruby

Mongify allows you to map your data from a sql database and into a mongodb document database. It supports MySQL, PostgreSQL, SQLite, Oracle, SQLServer, and DB2.

fatfree - A powerful yet easy-to-use PHP micro-framework designed to help you build dynamic and robust Web applications - fast!

  •    PHP

Condensed in a single ~65KB file, F3 (as we fondly call it) gives you solid foundation, a mature code base, and a no-nonsense approach to writing Web applications. Under the hood is an easy-to-use Web development tool kit, a high-performance URL routing and cache engine, built-in code highlighting, and support for multilingual applications. It's lightweight, easy-to-use, and fast. Most of all, it doesn't get in your way. F3 supports both SQL and NoSQL databases off-the-shelf: MySQL, SQLite, MSSQL/Sybase, PostgreSQL, DB2, and MongoDB. It also comes with powerful object-relational mappers for data abstraction and modeling that are just as lightweight as the framework. No configuration needed.

ejdb - EJDB — Embeddable JSON Database engine

  •    C

Currently we are in development of second generation of EJDB database (see the current limitations). As the first step we have developed modern key/value storage http://iowow.io which will be underlying storage engine for EJDB2. It aims to be a fast MongoDB-like library which can be embedded into C/C++, .Net, NodeJS, Python, Lua, Go, Java and Ruby applications under terms of LGPL license.

Kundera - JPA 1.0 ORM library for the Cassandra/Hbase/MongoDB database.

  •    Java

A JPA 2.0 compliant Object-Datastore Mapping Library for NoSQL Datastores. The idea behind Kundera is to make working with NoSQL Databases drop-dead simple and fun. Currently it supports Cassandra, MongoDB, HBase and Relational databases.

jugglingdb - Multi-database ORM for nodejs: redis, mongodb, mysql, sqlite3, postgresql, arango, in-memory

  •    Javascript

JugglingDB is cross-db ORM for nodejs, providing common interface to access most popular database formats. Currently supported are: mysql, sqlite3, postgres, mongodb, redis and js-memory-storage (yep, self-written engine for test-usage only). You can add your favorite database adapter, checkout one of the existing adapters to learn how. Jugglingdb also works on client-side (using WebService and Memory adapters), which allows to write rich client-side apps talking to server using JSON API.

db - Productive data access layer for Go.

  •    Go

The upper.io/db.v3 package for Go is a productive data access layer for Go that provides a common interface to work with different data sources such as PostgreSQL, MySQL, SQLite, MSSQL, QL and MongoDB.Take the tour to see real live examples in your browser.

mongolike - A proof of concept MongoDB clone built on Postgres

  •    Javascript

Mongolike is an experimental MongoDB clone being built on top of PLV8 and Postgres. Visit http://code.google.com/p/plv8js/wiki/PLV8 and follow the build instructions.

NeDB - Embedded datastore for node.js

  •    Javascript

NeDB is an Embedded persistent or in memory database for Node.js, nw.js, Electron and browsers, It is 100% JavaScript, no binary dependency, its API is a subset of MongoDB. One datastore of NeDB is equivalent to a MongoDB collection.

Hypertable - A high performance, scalable, distributed storage and processing system for structured

  •    C++

Hypertable is based on Google's Bigtable Design, which is a proven scalable design that powers hundreds of Google services. Many of the current scalable NoSQL database offerings are based on a hash table design which means that the data they manage is not kept physically ordered. Hypertable keeps data physically sorted by a primary key and it is well suited for Analytics.