ETL tool for transfering data from MongoDB to PostgreSQL
Project description
Purrito
Purrito is an open source ETL tool which transfers collections from MongoDB to PostgreSQL.
Features
- quick setup
- generate schema based on existing MongoDB collections or use a custom schema
- keep syncing with MongoDB real-time
- update the schema while syncing without stopping anything
- handle connectivity issues
- view collection transfer statistics
Support
MongoDB 3.4
PostgreSQL 9.6
Installation
Check out an example or set things up on your own:
-
install Purrito by typing
pip install purrito
-
start MongoDB as a replica set
-
create a source database in MongoDB and add a collection with a couple of documents
-
create a destination database in Postgres
-
generate the schema (
collections.yml
):purrito -m -mdb mongodb://localhost:27017 -n source_db
-
start Purrito:
purrito -cf collections.yml -pg postgres://127.0.0.1:5432/destination_db -mdb mongodb://localhost:27017 -n source_db -t
Documentation
For more details about Purrito check out our Documentation.
Contribute
Want to help us and the community with perfecting Purrito? Take a look at our contribution Guidelines and submit a PR.
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file purrito-1.0.3.tar.gz
.
File metadata
- Download URL: purrito-1.0.3.tar.gz
- Upload date:
- Size: 32.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.19.1 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.31.1 CPython/3.6.5
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 |
676a73a3dcdd85c7e2bb17a28bb2fedb8d2b16f3eba3b1547b3de185341da74c
|
|
MD5 |
34e8c74fbc79d7e32df8836ca1c0a8e7
|
|
BLAKE2b-256 |
f24128fb6090a88f2eebbec61a20533259e8d63ed2e86a6aece4f235a4f50ca1
|
File details
Details for the file purrito-1.0.3-py3-none-any.whl
.
File metadata
- Download URL: purrito-1.0.3-py3-none-any.whl
- Upload date:
- Size: 44.1 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.19.1 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.31.1 CPython/3.6.5
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 |
98a2f53ace158625720775c0911a735f001fefa82876d0b78fda81d7361a65d3
|
|
MD5 |
6573571161bcb71ac73118f345cf1d54
|
|
BLAKE2b-256 |
989d2ebbe2ee12df3388f96f815de5acb4e475b5c18da543515c7798dec887db
|