drift
drift copied to clipboard
Add recommend migration tools for Postgres
Since alterTable doesn't work with Postgres, I'd want an automatic migration tool that can handle this with Postgres. I'm not sure if the schema exports that Drift generates via make-migrations are of any standard that other tools would understand, which is why I'd like the docs to give some pathways on how we can get similar devx with Postgres and 3rd party migration tools that work well with Drift
It's worth noting that alterTable is sort of a catch-all commonly used with SQLite because most advanced ALTER statements aren't supported. Postgres has supporting for changing column types or constraints, for instance.
But since we already recommend an external migration tool for now, I agree that we should document what's available and how it can be used with drift.
@exaby73 Any tools you've found good for being compatible with drift? I am in a same situation so I should try to search and find a 3rd party migration tool. So if you've successfully managed your database using both Drift and Postgres, and you've found a solid migration tool that works well with them, would you mind sharing which tool you're using?