1.0.0

Added

• PostgreSQL support (postgres:18) with compose service, example POSTGRES_* env vars and DATABASE_URL wiring.
• Database tooling and integration: Flask‑SQLAlchemy, Flask‑Migrate/Alembic and psycopg2.
• Alembic migration scaffolding and a migrations directory.
• Automatic DB migration run at container start.

Changed

• Docker: multi‑stage build; install build/runtime libs (libpq) and include migrations in the image.
• Docker Compose: app waits for db health, adds pg_data volume and healthcheck.
• App: initialize DB and migrate extensions; import models so migrations pick up metadata.
• Config/test: add SQLALCHEMY_DATABASE_URI and set tests to use in‑memory SQLite (and in‑memory rate limit) so unit tests don’t require Postgres.
• Tests updated to use the test config.
• Dependency updates: add/ pin alembic, sqlalchemy, flask‑migrate, flask‑sqlalchemy, psycopg2 and minor frontend dev dependency bumps.