A Learning Project from Go Web Programming Book

Start the server (in Dev Container)

# from project root

# generate SSL certificate and private key
go run ./internal/gencert

go run .

Manage PostgreSQL database (from local machine)

# on local machine (from project root)
cd .devcontainer
docker container exec -it <database_container_name> sh

# in the postgres container
psql --username=$POSTGRES_USER --dbname=$POSTGRES_DB

\l                      # list databases
\c <database_name>      # connect to a database
\dt                     # list tables in the database
\d <table_name>         # describe a table
\g                      # run the previous command
\timing                 # turn on timing
\h DROP TABLE           # get help of a statement e.g. DROP TABLE

create database chitchat;

create table users (
    id         serial primary key,
    uuid       varchar(64) not null unique,
    name       varchar(255),
    email      varchar(255) not null unique,
    password   varchar(255) not null,
    created_at timestamp not null
);

create table sessions (
    id         serial primary key,
    uuid       varchar(64) not null unique,
    email      varchar(255),
    user_id    integer references users(id),
    created_at timestamp not null
);

create table threads (
    id         serial primary key,
    uuid       varchar(64) not null unique,
    topic      text,
    user_id    integer references users(id),
    created_at timestamp not null
);

create table posts (
    id         serial primary key,
    uuid       varchar(64) not null unique,
    body       text,
    user_id    integer references users(id),
    thread_id  integer references threads(id),
    created_at timestamp not null
);