feat: add local PostgreSQL mode and Docker Compose setup

↗ view on GitHub · Glauco · 2026-05-10 · b8efde9f

Adds an optional AUTH_MODE=local that replaces Supabase with:
- Local PostgreSQL (via pg) for all data storage
- Custom JWT auth (bcrypt + jsonwebtoken) via /auth/login and /auth/register
- PgAdapter: a thin Supabase-compatible query builder over pg.Pool
- DbClient abstraction so all route files work in both modes unchanged

Infrastructure:
- backend/Dockerfile and frontend/Dockerfile for containerised builds
- compose.yml: frontend + backend + postgres with named volumes for persistence
- docker/postgres/init.sql: full schema without Supabase-specific auth tables
- .env.example at repo root with compose variables

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
Repository rglauco/mike
Author Glauco <37829079+rglauco@users.noreply.github.com>
Authored
Parents 10d12e77
Stats 32 files changed , +1643 , -228
Part of Docker Compose + Local Postgres (Supabase-Optional Mode)

Capture this commit into my fork

Download a Markdown prompt that tells Claude how to port this exact commit into your working tree. Run it via claude -p < capture-commit-b8efde9f.md from inside the repo you want the change in.

⬇ Download capture-commit-b8efde9f.md