DT
Drizzle Team•4mo ago
TJ

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
Aziz•4mo 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
TJ•4mo ago
Uh ... simply because of the compatibility issues? I think we just have to give up of MariaDB if we want to use Drizzle.
Want results from more Discord servers?
Add your server
More Posts
SQLite: set fk constraint to be "DEFERRABLE INITIALLY DEFERRED"I would like to use [this](<https://www.sqlite.org/foreignkeys.html#fk_deferred>) feature of sqlite,Drizzle wants to truncate my tables when not neededI have this schema: ```ts export const users = sqliteTable('users', { id: text('id').notNull().pran npm run db:studio fine but localhost is still loading....SQLean's uuid4() in SQLite CREATE TABLEI'm using Turso, enabled SQLean uuid extension and I would like to generate a table via drizzle-kit How can we specify COLLATE on the schema?There is a feature request here: https://github.com/drizzle-team/drizzle-orm/issues/638 For adding Drizzle pg client throwing `scanner_yyerror` on pushGetting the following error upon running `drizzle-kit push:pg` to my local postgres. Drizzle-Kit verDrizzleError: Rollback is being rethrown unexpectedlyNo matter which error I throw for the rollback - it doesn't work as indented because it bleeds outsiId being required in types when using insert and valuesHello! I' been following the tutorial and I'm having a issue with the following function: ```js expo