Access MariaDB in Drizzle using node-mysql2?

Hi, Drizzle ORM does not support MariaDB officially (see https://github.com/drizzle-team/drizzle-orm/pull/1692). However, I have seen discussions of using Drizzle to access MariaDB (using node-mysql2 driver). Is this recommended? Is there any compatibility issue?
GitHub
Build software better, together
GitHub is where people build software. More than 100 million people use GitHub to discover, fork, and contribute to over 420 million projects.
From An unknown user
From An unknown user
From An unknown user
2 Replies
Aziz
Aziz2mo ago
That's what we are currently also trying to do. It was possible for us to use most of the stuff when you change the mode to "planetscale", because planetscale and mariadb both do not support lateral joins. But then we had other problems with using the query builder and one relationships. Small update: we switched to MySQL
TJ
TJ2mo ago
Uh ... simply because of the compatibility issues? I think we just have to give up of MariaDB if we want to use Drizzle.