-
Pull image: docker pull postgres
-
Create persistent volume: docker volume create my_postgres_data
-
Run container: docker run --name my-postgres-container -e POSTGRES_PASSWORD=mysecretpassword -v my_postgres_data:/var/lib/postgresql/data -d postgres
-
Access the cli of the database in the container: docker exec -it my-postgres-container psql -U postgres
-
Create: CREATE DATABASE mydatabase;
-
Connect: \c mydatabase
-
Create table: CREATE TABLE users ( id SERIAL PRIMARY KEY, username VARCHAR(50) UNIQUE NOT NULL, email VARCHAR(100) UNIQUE NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
-
Insert: INSERT INTO users (username, email) VALUES ('john_doe', '[email protected]');
-
Select: SELECT * FROM users;
docker stop my-postgres-container docker rm my-postgres-container
docker volume rm my_postgres_data
For some reason docker-compose not working.
- Tests
- Abstractions (db controller layer)
- Middleware (auth cookie, rate limit)
- Restructure database for different tables