MySQL issue 42000

[NoxRare]

I'm trying to setup ryot using mysql and getting this error:

thread 'main' panicked at 'called `Result::unwrap()` on an `Err` value: Exec(SqlxError(Database(MySqlDatabaseError { code: Some("42000"), number: 1059, message: "Identifier name 'fk_partial-metadata-to-metadata-group_id-metadata-partial-metadata_id' is too long" })))', apps/backend/src/main.rs:137:35 note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace

any ideas?

[IgnisDa]

BruH MySql always be disappointing. I will probably drop support for it next major release. Will it be possible for you to switch to Postgres?

[NoxRare]

BruH MySql always be disappointing. I will probably drop support for it next major release. Will it be possible for you to switch to Postgres?

I can switch to postgres, however all my currently hosted projects use mariadb and I would like to keep the containers to a minimum. If you like I can def look into switching to postgres.

[IgnisDa]

I would definitely suggest you do. I won't be able to fix this anyway without #294 (comment) being resolved.

[IgnisDa]

Blocked by SeaQL/sea-orm#1839

[NoxRare]

Quick question, would this affect SQLite aswell? and what are the downsides of using SQlite, I've heard a lot of bad things about it lol.

[IgnisDa]

I haven't really used Sqlite all that much. During development mode I noticed sqlite allows you to create foreign kys to tables that do not exist.