General purpose admin GUI for relational databases
Bring up Postgres and Adminer
Here's a docker-compose.yml file to use for this
version: '3.1' services: db: image: postgres restart: always environment: POSTGRES_PASSWORD: example adminer: image: adminer restart: always ports: - 8080:8080
Now point a browser at localhost:8080
If we want to populate the database we can modify our docker-compose.yml file as follows:
version: '3.1' services: db: image: postgres restart: always environment: POSTGRES_PASSWORD: example volumes: - ./createdb.sql:/docker-entrypoint-initdb.d/createdb.sql adminer: image: adminer restart: always ports: - 9000:8080
Our createdb.sql file could look like this:
CREATE DATABASE bird_encyclopedia; \c bird_encyclopedia CREATE TABLE birds ( id SERIAL PRIMARY KEY, bird VARCHAR(256), description VARCHAR(1024) );