Spin up a data warehouse in under 5 minutes! JoinDB lets you easily join across all your databases and even CSVs in minutes. No complex ETLs or integration projects required.
For Joiner, a hosted Data Warehouse based on JoinDB, check out www.getjoiner.com.
- Clone the repository onto your local machine
- Joiner requires Ruby and Docker. You will need to download those if you don't have them already.
- After downloading Docker, pull the Docker image with
docker pull mjirv/joiner:master
- Run the docker image with
docker run -p 5432:5432 --name joiner mjirv/joiner:master
- Make sure you open port 5432 if you want other computers to be able to connect to your JoinDB
- Run
ruby install.rb
to create your login and see connection details - Run
ruby joindb_client.rb
and follow the prompts on the screen to set up your analytics database and add connections to it - Query via your favorite PostgreSQL client like any other database!
- Joiner currently only supports PostgreSQL and MySQL connections plus CSV imports. I'm adding more soon!
- Best practice is to connect to your other DBs using a read-only user so that your JoinDB can't change your production DBs