Rails 6: Running on Docker with PHPMyAdmin
One day, I was using my Windows computer. Since the arriving of WSL 2 I wanted to play around with a Rails application. Just for the fun of practicing my Docker skills. The only big requirement for me? Use the Alpine Linux image, well known for the small image size they generate.
After a couple of hours of pain and suffering, I made it. My docker containers were working as expected and it was ready for work. Here, I present all the files and workarounds that I used.
First. I created the Dockerfile for the Ruby container. The route was .docker/Dockerfile
4 apk update && apk upgrade && \
5 apk --no-cache add make gcc libc-dev && \
6 apk add --update --no-cache \
7 build-base curl-dev git libxslt-dev libxml2-dev ruby-rdoc mysql-dev \
8 yaml-dev zlib-dev nodejs yarn tzdata
13RUN gem install nokogiri -- --use-system-libraries
14RUN gem install bundler
16COPY package.json yarn.lock ./
17RUN yarn install --check-files
19COPY Gemfile Gemfile.lock ./
25RUN rm -rf /var/cache/apk/*
30CMD ["rails", "console"]
Do you see that tzdata library? That was giving me errors when I tried bundle install. In short, I just wanted to install all my dependencies without any issues. Inside the container, the app will be located in the /app folder and it comes with the MySQL libraries for a DB integration.
Plus, I added nodejs and yarn as Alpine Linux libraries, we will need them as tools for local development use, specially since Rails relies on Webpacker for frontend development.
📦 Docker compose
After that, we can create our docker-compose.yml file. For this case, we are using a Ruby + MySQL 8.0 + PHPMyAdmin combo. Probably you are wondering, why PHPMyAdmin? That’s because I don’t have any SQL UI tool in my Linux computer and I don’t want to use the command line right now.
4 container_name: rails_project_backend
5 command: sh -c "bundle install && yarn install --check-files && bundle exec rails s -p 3000 -b '0.0.0.0'"
10 dockerfile: .docker/Dockerfile
16 - "node-modules:/app/node_modules"
18 RAILS_ENV: development
20 DATABASE_USER: rails_db_user
21 DATABASE_PASSWORD: rails_db_password
22 DATABASE_NAME: rails_db
24 container_name: rails_project_db
27 MYSQL_ROOT_PASSWORD: password
28 MYSQL_DATABASE: rails_db
29 MYSQL_USER: rails_db_user
30 MYSQL_PASSWORD: rails_db_password
32 - './dbdocker:/var/lib/mysql'
33 - './dbdocker_init:/docker-entrypoint-initdb.d'
39 image: phpmyadmin/phpmyadmin
47 MYSQL_ROOT_PASSWORD: password
In the PHPMyAdmin container we need the root password, because we want to execute “powerful” operations over our databases.
The dbdocker and dbdocker_init are extra folders that you can add to your project if you want to execute extra commands into your MySQL container. Remember once you added it to ignore all the content of dbdocker, where the database files will remain. It’s a good practice to create an empty .gitkeep or .keep file in the folder and then ignoring it. Here is the rule that I’d use in my .gitignore
Remember that you can use a .env file and then add env_file: - .env to your docker compose file (removing the environment section per container first), if you don’t want to commit your env values or if you change them often.