Automatically generate migration scripts for schema changes
- Dominant language
- Python
- Stars
- 485
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
Currently, when making schema changes in Postico, it's possible to display the SQL preview for the change.
A customer suggested to expand this featue:
1. It would be nice if Postico allowed a way to group multiple schema changes even when they affect more than one table.
2. Postico should not only show the SQL to perform the changes, but optionally also code that reverts the changes. (eg. "ALTER TABLE xxx ADD COLUMN yyy" and its inverse "ALTER TABLE xxx DROP COLUMN yyy").
These two features would allow using Postico to generate code for automatic database migration (eg. using Sqitch)
Contributor guide
No contributing guide indexed for this repository
Research direction
No files or tests are named. Start by tracing the existing SQL-preview flow and how schema changes are represented. Done means grouped changes across multiple tables can produce migration SQL and optional reverse SQL, including the examples described in the issue.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sql
- Domain
- database
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100