MariaDB not supported ?

[bennyszantar]

Hey,

I wanted to use Bob in my new project which uses MariaDB but unfortunetely I hit roadblock that I cannot bypass.
I've created bobgen.yaml with mysql property.

mysql:
  dsn: "blabla:blabla@tcp(localhost:3306)/default"
except:
  default.schema_migrations:

after running command

go run github.com/stephenafamo/bob/gen/bobgen-mysql@latest -c bobgen.yaml

im getting error:

2024/07/22 16:30:11 unable to fetch table data: unable to load indexes: Error 1054 (42S22): Unknown column 's.expression' in 'field list'
exit status 1

This error still happens even if I delete all my tables... Did I misconfigure something or MariaDB is not supported via MYSQL driver ?

[stephenafamo]

MariaDB is not supported. So far no effort has been made to test if the MySQL integration works with MariaDB at all.

In the future, I would like to make a dedicated driver for MariaDB. As MariaDB diverges more and more from MySQL, it is not sensible to reuse the same driver.
The reasons why we have created dedicated drivers for each dialect is the same reason why MariaDB should have it's own drivers.

As with many things, the primary blocker is time.

[bennyszantar]

Got it ! Im very early into project so I will just swap to Postgres and call it a day.

Maybe it would be good to mention it in documentation that MariaDB is not supported trough MySQL integration ? I think a lot of people (like me) still thinks that MariaDB = MySQL, which as you mentioned is not the case anymore.

Thank you for your time :)