Repository navigation
Migration support using tools like sqlx migate or flyway #3448
Description
Activity
I did some research, and instead of making Manticore work with sqlx/flyway as if it were MySQL, it might make more sense to write a driver for something like https://github.com/amacneil/dbmate (or any other tool that makes it easy to add a new driver).
We can help if someone is willing to do it.
@sanikolaev Yeh I can have a look at implementing that, the logic for the driver seems pretty chill. However ideally we wait for the prepare statement feature so that we can use a statement to set the migration versions instead of statically implementing it using a string formater with manticore
https://github.com/amacneil/dbmate/blob/main/pkg/driver/mysql/mysql.go#L287
ideally we wait for the prepare statement feature so that we can use a statement to set the migration versions instead of statically implementing it using a string formater with manticore
That's right. I'll just put the link to your related PR here #3431
Proposal:
I want to be able to manage a manticore db schema using migration files so that I have a repeatable flow for different environment.
e.g a
migrationsdirectory with the SQL code to create / update tables likemigrations/1_init_tables.sql,migrations/2_update_table.sql.I use the rust sqlx library usually and flyway for some java repos but when I try to do a migration I will get the following error
Checklist:
To be completed by the assignee. Check off tasks that have been completed or are not applicable.
Details