drift icon indicating copy to clipboard operation
drift copied to clipboard

Add recommend migration tools for Postgres

Open exaby73 opened this issue 10 months ago • 2 comments

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

exaby73 avatar Jan 19 '25 09:01 exaby73

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.

simolus3 avatar Jan 19 '25 19:01 simolus3

@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?

momadvisor avatar May 25 '25 04:05 momadvisor