databases.md

Database tooling

Client tools only on the host. Database servers run in Docker (docker.md).

Installed clients

Tool	Version	Package
PostgreSQL client (psql)	18.4	postgresql
pg_dump / pg_restore	18.4	postgresql
MariaDB / MySQL client	11.8.8	mariadb
SQLite	3.51.2	sqlite

sudo dnf install postgresql mariadb sqlite

The Fedora postgresql / mariadb packages install the client binaries without pulling in or enabling a server.

Typical workflow

# Postgres server as a container
docker run -d --name pg -e POSTGRES_PASSWORD=dev -p 5432:5432 postgres:18

# connect with the host client
psql -h localhost -U postgres

# dump / restore with matching client major version
pg_dump -h localhost -U postgres appdb > appdb.sql

SQLTools in VS Code uses the same connection targets (vscode.md).

Keep the host client's major version aligned with the container server's major version for pg_dump/pg_restore compatibility.