Single Command Database Setup

When you are working on a backend application, you are likely to need a database. You can either install it on your machine or use a Docker container. I prefer to use Docker containers because it is easier to setup and doesn’t pollute my machine with unnecessary dependencies.

This short guide will show you how to spin up a MySQL, PostgreSQL, or MongoDB instance on your local machine using docker. Feel free to submit a PR adding more databases.

PostgreSQL

You can run the following command to run PostgreSQL in a Docker container:

docker run \
  --name pg \
  --detach \
  --publish 5432:5432 \
  --env POSTGRES_PASSWORD=admin \
  postgres

Now you can connect and run commands against the instance using the following:

docker exec -it pg \
  psql -U postgres

MySQL

You can run the following command to run MySQL in a Docker container:

docker run \
  --name ms \
  --publish 3306:3306 \
  --detach \
  --env MYSQL_ROOT_PASSWORD=admin \
  mysql

Now, you can use the following to run commands against the MySQL instance:

docker exec -it ms \
  mysql -u root -padmin

MongoDB

You can run the following command to run MongoDB in a Docker container:

docker run \
  --name mdb \
  --publish 27017:27017 \
  --detach \
  mongo

Now, you can use the following to run commands against the MongoDB instance:

docker exec -it mdb \
  mongo

Feel free to submit a pull request by adding additional databases to this guide.

Community

roadmap.sh is the 6th most starred project on GitHub and is visited by hundreds of thousands of developers every month.

Roadmaps Best Practices Guides Videos FAQs YouTube

roadmap.thaiprogrammer.org by Kamran Ahmed

Community created roadmaps, articles, resources and journeys to help you choose your path and grow in your career.

© roadmap.sh · Terms · Privacy ·

ThewNewStack

The leading DevOps resource for Kubernetes, cloud-native computing, and the latest in at-scale development, deployment, and management.