Setup any database playground with sample data in seconds
The repository has a simple docker-compose file and a few scripts to set up any database playground with sample data in seconds. It is a great way to test your database queries and learn about the database.
You can run a single command to setup Northwind dataset in PostgreSQL, MySQL, PostgreSQL and more.
Make sure you have Docker installed and running.
After that, you can clone the repository and run the following commands to setup any database.
# See what you can do with playground
./playground.sh -h
# run all the services using one of the following
./playground.sh
./playground.sh -s all
# run a single service
./playground.sh -s mongo
./playground.sh -s posgres
# clean up the playground
./playground.sh -c
# clean up the playground and run the services
./playground.sh -c -s all
./playground.sh -c -s mongo
./playground.sh -c -s posgresYou can also ue the docker-compose command directly to run the services.
# run all the services
docker-compose up -d
# run a single service
docker-compose up -d mongo
# clean up the playground
docker-compose downGiven below are the default configuration for the databases.
Following are the details to connect to the database
Host: localhost
Port: 6432
Username: admin
Password: admin
Database: northwind
You can use the following command to run commands on the database
docker exec -it db_playground_postgres psql -U admin -d northwindFollowing are the details to connect to the database
Host: localhost
Port: 4306
Username: admin
Password: admin
Database: northwind
You can use the following command to run commands on the database
docker exec -it db_playground_mysql mysql -uadmin -padminFollowing are the details to connect to MongoDB
Host: localhost
Port: 37017
Database: northwind
You can use the following command to run commands on the database
docker exec -it db_playground_mongo mongosh- Add support for more databases
- Suggest features
- Discuss ideas in issues
- Spread the word
MIT © Kamran Ahmed