---
title: Databases
url: 'https://www.niklas-stephan.de/en/wiki/free-open-source-software/datenbanken'
markdown: 'https://www.niklas-stephan.de/en/wiki/free-open-source-software/datenbanken.md'
lang: en
date: '2026-03-24'
description: 'Databases Operating database systems is today as simple as never before – thanks to operating system containers such as Docker. While professionally I still learned to configure an Oracle database perfectly over days in most laborious small work, today one just brings up the container with a few st…'
---

#  Databases 

Operating database systems is today as simple as never before – thanks to operating system containers such as Docker.

While professionally I still learned to configure an Oracle database perfectly over days in most laborious small work, today one just brings up the container with a few standard configuration options.

## Relational databases

The "classics" of databases.

For operation we need, besides the container as such, a volume for the persistent storage, environment variables, and a few configuration options.

Careful with the choice of the user under which the database container should run, since the permissions on the persistent volume carry through.

### MariaDB

MariaDB is an open-source project that originated as a fork of MySQL and has largely displaced that one.

#### Configuration

Example here.

compose.yml:

```yaml
mariadb:
  container_name: mariadb
  image: mariadb:10.11
  user: "1000:1000"
  restart: unless-stopped
  command: --transaction-isolation=READ-COMMITTED --log-bin=binlog --binlog-format=ROW --log_bin_trust_function_creators=true
  volumes:
    - ./db:/var/lib/mysql
  env_file: .env
  networks:
    - default
```

.env:

```ini
MARIADB_ROOT_PASSWORD=
MARIADB_DATABASE=
MARIADB_USER=
MARIADB_PASSWORD=
TZ=Europe/Berlin
PUID=1000
PGID=1000
```

#### Operation

Back up the database (backup or dump):

```bash
docker exec DBCONTAINERNAME sh -c 'exec mysqldump -u"root" -p"ROOTPASSWORD" "DBNAME"' > dump.sql
```

Restore the database from the dump:

```bash
cat dump.sql | docker exec -i DBCONTAINERNAME sh -c 'exec mysql -u"root" -p"ROOTPASSWORD" "DBNAME"'
```

### PostgreSQL

PSQL is the most beloved relational database in the open-source community and in modern software projects usually the standard.

compose.yml:

```yaml
services:
  psqldb:
    container_name: psqldb
    image: postgres:15-alpine
    user: "1000:1000"
    environment:
      POSTGRES_DB: ${POSTGRES_DB}
      POSTGRES_USER: ${POSTGRES_USER}
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
    restart: unless-stopped
    volumes:
      - ./db:/var/lib/postgresql/data
    networks:
      - default
```

.env:

```bash
POSTGRES_DB=
POSTGRES_PASSWORD=
POSTGRES_USER=
PUID=1000
PGID=1000
TZ=Europe/Berlin
```

---

## Navigation

- Parent: [Free Open-Source Software](https://www.niklas-stephan.de/en/wiki/free-open-source-software.md)
- Previous: [🤖 Node-RED](https://www.niklas-stephan.de/en/wiki/free-open-source-software/node-red.md)
- Next: [git](https://www.niklas-stephan.de/en/wiki/free-open-source-software/git.md)
