Dockerfile

# Inspired by `https://github.com/alfg/docker-php-apache`
# Thank you, Alfred Gutierrez, it's such a small image based on your Dockerfile!
FROM alpine:latest

# `apk` is the package manager in Alpine Linux

# PHP, PHP modules, git
RUN apk --update add --no-cache php-apache2 php-json php-mbstring php-mysqli php-openssl php-pgsql php-session git

# configs:
# /etc/apache2/httpd.conf
# /etc/php82/php.ini
# but PHP path changes from version to version and thus can't be easily used

# listen to port 1111, DON'T listen to 80
# this is an overkill and user would override it at runtime anyways, it's more of enforcing caution and not occupying a popular port accidentally
RUN sed -i 's/Listen 80/Listen 1111/' /etc/apache2/httpd.conf
# AllowOverride is required to set PHP options in `.htaccess` (and setting them there is better so they persist through PHP version change)
RUN sed -i 's/AllowOverride None/AllowOverride All/gi' /etc/apache2/httpd.conf

# respond to "localhost" and an alternative "sqlantern.local" (which must be added to host to use)
# and, of course, it'll also work if requested by IP, naturally
RUN echo -e "\
        <VirtualHost *:1111>\n\
        ServerName localhost\n\
        ServerAlias sqlantern.local\n\
        DocumentRoot /var/www/localhost/htdocs\n\
        </VirtualHost>\n\
" >> /etc/apache2/httpd.conf

# some PHP options are set to pretty high values below, but again: this docker MUST NOT be run on publicly exposed machines, it is intended for dev only
RUN cd /var/www/localhost/htdocs \
        && rm -rf index.html \
        && git clone https://github.com/nekto-kotik/sqlantern.git . \
        && echo -e "\
<?php\n\
define(\"SQL_MULTIHOST\", true);\n\
" > php/config.sys.php \
        && echo -e "\
php_value memory_limit 256M\n\
php_value post_max_size 256M\n\
php_value upload_max_filesize 256M\n\
php_value max_execution_time 120\n\
php_value gc_maxlifetime 86400\n\
php_value max_input_time 300\n\
" > php/.htaccess

# Apache must be run as a program in this case, not as a service (as far as I could understand; I'm very new to Docker)
RUN echo -e '#!'"/bin/sh\n\
cd /var/www/localhost/htdocs\n\
git pull\n\
ln -sf /dev/stderr /var/log/apache2/error.log\n\
mkdir -p /run/apache2 && /usr/sbin/httpd -D FOREGROUND\n\
exit \"\$@\"\n\
" > /opt/entrypoint.sh

EXPOSE 1111

# maybe I should run `chmod` instead, to allow running the script manually in `-it` mode for debug without chmodding it every time...
ENTRYPOINT ["sh", "/opt/entrypoint.sh"]