Starting Database with Docker

PostgreSQL

docker run -p 5432:5432 --name pgdemodb --rm -ePOSTGRES_DB=test -ePOSTGRES_USER=test -ePOSTGRES_PASSWORD=test postgres:9.4 \
    -c max-prepared-transactions=110 -c log-statement=all

docker run -d -p 5432:5432 --name pgdemodb --rm -v $(pwd)/init.sql:/docker-entrypoint-initdb.d/init.sql \
    -e POSTGRES_USER=test -e POSTGRES_PASSWORD=test -e POSTGRES_DB=test postgres:11

To setup database with another user could be done e.g. with

docker ps
doker exec -it 99ff8a3fc9e9 bash
createdb --username test test2
createuser --username test test2
psql test2 test2
##    ALTER USER test2 WITH PASSWORD 'test2';
----


== MySQL

[source,sh]
----
docker run -p 3306:3306 --rm -it --name mymysql -eMYSQL_DATABASE=test -eMYSQL_USER=test -eMYSQL_PASSWORD=test -eMYSQL_LOG_CONSOLE=true \
    docker.io/mysql/mysql-server:5.7 --log-error --general_log=1 --general_log_file=/tmp/mysql.query.log
----

Some notes for examining MySQL

[source,sh]
----
docker exec -it $(docker ps | grep mymysql | awk '{print $1}') bash -c 'tail -F /tmp/mysql.query.log'
docker stop $(docker ps | grep mymysql | awk '{print $1}') # CTRL + C somehow does not work for the container of mysql
----

== MariaDB

[source,sql]
----
" cat > /tmp/mariadb.sql <<EOF
CREATE DATABASE test;
USE 'test';
CREATE USER 'test' IDENTIFIED BY 'test';
GRANT USAGE ON *.* TO 'test'@localhost IDENTIFIED BY 'test';
GRANT USAGE ON *.* TO 'test'@'%' IDENTIFIED BY 'test';
GRANT ALL privileges ON test.* TO 'test'@localhost;
FLUSH PRIVILEGES;
CREATE TABLE test ( id smallint unsigned not null auto_increment, name varchar(20) not null, constraint pk_example primary key (id) );
" EOF

docker run -t --rm --name maria -p 3306:3306 -v /tmp/mariadb.sql:/docker-entrypoint-initdb.d/test.sql -eMARIADB_ROOT_PASSWORD=mypassword \
    mariadb/server:10.3
# docker kill maria
----


== Oracle DB

* original Oracle DB: https://github.com/oracle/docker-images/blob/master/OracleDatabase/SingleInstance/README.md,
  you need docker in version 17.09+
* user driven repository for Oracle 18c XE: https://github.com/fuzziebrain/docker-oracle-xe