3 commits

Author	SHA1	Message	Date
Wuesteon	8af01724d7	✨ feat(db): add production-safe migration system with advisory locks ... - Add migrate.ts script with PostgreSQL advisory locks to prevent concurrent migrations - Add retry logic with exponential backoff for transient connection errors - Update CI/CD workflows to run migrations before deployment with health polling - Create comprehensive DATABASE_MIGRATIONS.md documentation covering: - Drizzle ORM internals (push vs generate/migrate modes) - Migration tracking (journal files, __drizzle_migrations table) - Advisory lock architecture and timeout handling - Zero-downtime migration patterns (expand-contract) - Troubleshooting guide - Update .claude/guidelines/database.md with migration quick reference - Remove stale migration files that caused schema conflicts	2025-12-09 02:13:11 +01:00
Wuesteon	8de629dd2d	🚀 ci: add dev branch workflow with PR validation ... - Rename ci-main.yml to ci.yml for clarity - Add PR-based validation (type-check, lint) for dev and main branches - Add path filtering to skip CI on docs-only changes - Trigger staging deployment only on push to dev branch - Keep production deployment manual with confirmation	2025-12-08 12:54:25 +01:00
Wuesteon	74dc6892ab	first implementation	2025-11-27 17:26:18 +01:00