How to enable migrations correctly?

[muturgan]

It annoys me that I have to download mysq dependencies for my project.
I decided try to disable the default features:

sqlx = { version = "0.8.4", default-features = false, features = ["derive", "migrate", "runtime-tokio", "tls-none", "postgres"] }
sqlx-postgres = { version = "0.8.4", features = ["chrono", "uuid"] }

This works almost well and removes mysq from a lock file.
But I get the error:

|     sqlx::migrate!("./migrations").run(&pool).await?;
|           ^^^^^^^ could not find `migrate` in `sqlx`

How to purge mysql and enable runtime migrations in a right way?

[abonander]

#3211

[muturgan]

#3211

interesting

[muturgan]

After several attempts, I found a solution.
I adding dependencies like this:

sqlx = { version = "0.8.4", default-features = false, features = ["derive", "runtime-tokio", "tls-none", "postgres"] }
sqlx-core = { version = "0.8.4", features = ["migrate"] }
sqlx-postgres = { version = "0.8.4", features = ["migrate", "chrono", "uuid"] }

and I replace a migrate! call with:

use sqlx_core::migrate::Migrator;

let migrator = Migrator::new(Path::new("./migrations")).await?;
migrator.run(&pool).await?;

that works correct and cleanup dependencies.

[abonander]

https://docs.rs/sqlx-core/latest/sqlx_core/#note-semver-exempt-api