Auth and Databases

OAuth (Discord)

sign in with Discord; you get a token, not a password.

Magic link

one-time email sign-in link.

Session

how long a user stays logged in.

JWT

signed token proving identity.

Scopes/permissions

access levels requested at sign-in.

Table/column/row

DB basics; primary key (unique ID), foreign key (relation).

Index

speeds up queries; transaction

ACID

reliable transaction guarantees.

Join

query across related tables.

Normalization/denormalization

reduce duplication / speed reads.

Sensitive table

separate, encrypted store for optional private answers.

Idempotent writes

repeat-safe (prevents duplicates on retries).