Create the best possible docker-compose.yml for this project

[javiereguiluz]

Calling for help from Docker experts. We need to create the best possible docker-compose.yml file for this project. The application requirements are well defined (we use env vars, Webpack Encore, PHP 7.1, Symfony 4.1, SQLite database, etc.) so it should be possible to create that file.

[javiereguiluz]

An important note mentioned to me by a person on Symfony Slack (I don't remember exactly who, I'm sorry). In the normal Symfony Demo app, we must use SQLite because it's our only option to use a database that requires zero setup.

However, when using Docker, we can use any database with zero setup. So, let's use PostgreSQL in the Docker config file. (I suggest PosgreSQL because to me it looks more popular among Symfony devs than MySQL).

[stof]

the hard part is that our config/packages/doctrine.yml file is currently incompatible with Postgresql as it defines a mysql-only charset (the proper UTF-8 charset is the utf8 on postgresql, as they got it right directly instead of creating a second charset like utf8mb4 for proper UTF-8 support)

[javiereguiluz]

@stof could we run a quick sed command on that config file to replace the wrong value while setting up things in Docker?

[stof]

@javiereguiluz if we copy the file inside the image at build time, we could. If we want to mount the source code instead (to make it a dev-like environment where you can edit things), we cannot modify files in the image (as they are not in the image)

[sebastianblum]

@javiereguiluz we can remove charset: utf8mb4 in this file (https://github.com/symfony/demo/blob/master/config/packages/doctrine.yaml) and add it as a parameter ?charset=utf8mb4 in the env.dist file (https://github.com/symfony/demo/blob/master/.env.dist)

DATABASE_URL=sqlite:///%kernel.project_dir%/var/data/blog.sqlite?charset=utf8mb4

then we can create a new .env file for the docker environment

[syther101]

Hay all, subscribed to this issue when it was being talked about in slack. Was toying around with docker the other day and got reminded of this. Not the most experienced with Docker but can try and help where I can 😄

Do we have any ideas what base image we would want to use. 7.1-jessie maybe?

[OlivierToussaint]

we can take this : https://github.com/dunglas/symfony-docker ?

[frastel]

I would vote for sqlite because you do not have to start an additional container for this database.

About the requirements:

• mailing should also be possible? Or should we ignore this feature as it is disabled by default?
• how about the webserver? Which one should be used or should the build-in webserver be used?
• very often discussed: How about the phpunit and composer runner? Some ppl start the official images ignoring the PHP version used there. Others create own "dev" PHP images with phpunit and composer installed. I prefer the later one because imho it is very important that those runners run within the same PHP environment than your application does.

[frastel]

@OlivierToussaint the aim of your linked docker setup is to start a new Symfony project not to use an existing one.

Btw: The project uses the second approach I mentioned in my prior comment.

[OlivierToussaint]

@frastel yes I know, but the base of dockerfile & docker-compose is here, we can be inspired

[frastel]

@OlivierToussaint Ok, for inspiration it is good enough.

@syther101 The question of the base image is a good one. php:7.1-jessie would be 378MB in size, php:7.2.7-fpm-alpine would be only 81MB.
I would try it with the alpine image. I am aware of the fact that not everything is possible with alpine images. But the Docker workshops I hosted have shown it is very important to use the smallest Docker Images possible.

[ajardin]

There are several possibilities, but to summarize:

• php:7.2-fpm-alpine with everything needed by Symfony 4.1 and Webpack Encore
• nginx:1-alpine VS built-in webserver
• postgres:alpine VS SQLite

I personally prefer the approach where everything is provided by a dedicated container.
Also, I'm using djfarrelly/maildev on my local environment to test emails. Does someone know a better alternative?

[moosti]

I am using this guy

• https://github.com/tulik/symfony-4-docker-runtime-env

It's good (not include yarn support for assets yet)