Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add recommend migration tools for Postgres #3421

Open
exaby73 opened this issue Jan 19, 2025 · 1 comment
Open

Add recommend migration tools for Postgres #3421

exaby73 opened this issue Jan 19, 2025 · 1 comment
Labels
docs Related to the documentation (dartdoc or website)

Comments

@exaby73
Copy link

exaby73 commented Jan 19, 2025

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 exaby73 added the docs Related to the documentation (dartdoc or website) label Jan 19, 2025
@simolus3
Copy link
Owner

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
docs Related to the documentation (dartdoc or website)
Projects
None yet
Development

No branches or pull requests

2 participants