Summary
Add a CLI command for database migrations that supports multiple database backends, particularly useful for migrating between SQLite (local development) and PostgreSQL/Neon (production).
Proposed Command
taskflow migrate --to neon
taskflow migrate --to postgres --url "postgresql://..."
taskflow migrate --to sqlite --path "./local.db"
Context
This emerged from Phase 2 backend API development. The team needs a way to:
- Migrate local SQLite development databases to production Neon/PostgreSQL
- Support the development → staging → production workflow
- Export/import data between environments
Acceptance Criteria
Technical Notes
- Should leverage existing SQLModel/SQLAlchemy models
- Consider using Alembic for schema migrations
- Data migration separate from schema migration
Priority
Future enhancement - not blocking current phase work
Labels
Summary
Add a CLI command for database migrations that supports multiple database backends, particularly useful for migrating between SQLite (local development) and PostgreSQL/Neon (production).
Proposed Command
Context
This emerged from Phase 2 backend API development. The team needs a way to:
Acceptance Criteria
taskflow migratecommand with--totarget optionTechnical Notes
Priority
Future enhancement - not blocking current phase work
Labels