"The connection string ... has no supporting driver"

[roberte777]

Hey there, I've had a lot of experience using ORM's in Javascript, this is my first step into it with Rust, so forgive me if I don't know several rust specific things. When trying to initialize my database with some starting migrations, I get the error:
The connection string 'postgresql://user:pass@localhost:5432/db has no supporting driver.
I took out any specific info relating to my implementation from the string. Any ideas why this would be happening? Thanks for any help!

[billy1624]

Hey @roberte777, welcome to Rust!

You need to enable the database feature and runtime.

https://www.sea-ql.org/SeaORM/docs/install-and-config/database-and-async-runtime

[roberte777]

never uploaded an image from clipboard to github, so hopefully this works. I had this in my main Cargo.toml, something in here not correct?

[billy1624]

This is correct!

However, you need to structure the cargo workspace by following the steps below.

https://www.sea-ql.org/SeaORM/docs/migration/setting-up-migration#workspace-structure

[billy1624]

Gonna sleep now loll
Talk to you tmr

[roberte777]

Cool, I didn't see specifically in the docs that it says to list database driver in the toml file for the entity folder. Just thought it was the same as the core toml command. For documentation purpose, it could be helpful if small, easy to miss changes like that between locations were mentioned specifically, making them harder to miss. That aspect is working now, thank you!

[billy1624]

Good suggestions! Definitely have room for improvements. You can also click on the Edit this page button to propose changes! :P

[CPoncet]

I can attest to the lack of precision in the docs. It took me a while to figure out I had to adjust Cargo.toml in the migration folder to specify runtime and db driver. I thought it was enough to stipulate it in the main crate's Cargo.toml. It worked perfectly afterwards.

[billy1624]

Hey @CPoncet, thanks for raising this issue up! We've added some comments on the generated migration crate (sea-orm-cli migrate init)

sea-orm/sea-orm-cli/template/migration/_Cargo.toml

Lines 14 to 22 in bb8a8bc

	[dependencies.sea-orm-migration]
	version = "<sea-orm-migration-version>"
	features = [
	# Enable at least one `ASYNC_RUNTIME` and `DATABASE_DRIVER` feature if you want to run migration via CLI.
	# View the list of supported features at https://www.sea-ql.org/SeaORM/docs/install-and-config/database-and-async-runtime.
	# e.g.
	# "runtime-tokio-rustls", # `ASYNC_RUNTIME` featrure
	# "sqlx-postgres", # `DATABASE_DRIVER` feature
	]

However, as you've said we didn't mention it specifically on the documentation site. I guess we can add these comments to this section: https://www.sea-ql.org/SeaORM/docs/migration/setting-up-migration/#workspace-structure

[dependencies]
async-std = { version = "^1", features = ["attributes", "tokio1"] }
sea-orm-migration = { version = "^0" }

Would that be enough?

[CPoncet]

I figured out about the comments on the generated migration crate, but only when I read this discussion.

So yeah adding it in the docs is way better in my opinion.

[billy1624]

Added! SeaQL/seaql.github.io@2792e49