Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Clarify that the Planetscale Driverless Driver is compatible with Relational queries #82

Open
Jumaron opened this issue Aug 10, 2023 · 2 comments

Comments

@Jumaron
Copy link

Jumaron commented Aug 10, 2023

Hello Drizzle Team,
just like the title suggests, clarifying that you can use the Driverless Planetscale Driver without any adjustments on the drizzle connection would really be helpful since myself and other users where confused since it only shows mysql2 with a custom planetscale setting in the Docs.
That would be it :)
Keep up the great work!

@AlexBlokh
Copy link
Contributor

@Jumaron
Copy link
Author

Jumaron commented Aug 10, 2023

That's not what I mean; I meant this one: https://orm.drizzle.team/docs/rqb

[...]
Drizzle relational queries use lateral joins of subqueries under the hood, and for now, PlanetScale does not support them.

When using the MySQL2 driver with a regular MySQL database, you should specify mode as "default".
When using the MySQL2 driver with PlanetScale, you need to specify mode: "planetscale".

A quick text that the Planetscale serverless driver (with a link to the docs you sent above) would also work as an alternative would be enough or optimal in my opinion, since when you read it for the first time, you get misled into using MySQL2 since you cannot change the schema mode in the Planetscale serverless driver.

Sure, you could test it out, but for people migrating, not having the serverless driver be a dealbreaker would be too high a risk.

Let me know what you think.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants