Feature request - Optional PostgreSQL provider #19
Description
Category: Database & Storage
add a Storage:Provider env var (sqlite | postgres); register the correct EF Core provider at startup in both WebUI and CLI (UseSqlite vs UseNpgsql); guard BackupService to SQLite-only (no-op or error for postgres); generate a separate set of EF Core migrations for PostgreSQL; update docker-compose.yml with an optional postgres profile; document Azure Database for PostgreSQL Flexible Server as the recommended Azure backend when using Container Apps; SQLite remains the default (no breaking change)
Managed automatically from BACKLOG.md