Does Wasp support MySQL?
Clearly PrismaJS does. Looking at wasps docs on databases: https://wasp-lang.dev/docs/language/features#database
It says clearly that either
sqlite or postgresqlcan be used. Is the documentation just missing or is MySQL truly not supported by wasp?
My hope is to use planetscale.com to host our database. And it is based on MySQL so that may be an issue.10 Replies
Hey, welcome to the Wap Discord 🙂 yes, currently we don't support MySQL ... but it should be possible for to do so. We focused on PostgreSQL to minimise the testing area, but since Prisma is our abstraction layer there shouldn't be a major issue to support MySQL as well.
That being said, I'm not sure what's our plan and how far out is MySQL support for us, @martinsos could maybe provide a better answer on this.
Another thing to note is, for jobs we have a job executor PgBoss which is PostgreSQL specific, but that's not a blocker tbh
TLDR: not yet, but we could and should explore expanding our DB support in the near future 🤞
Have you considered Neon as nice managed PostgreSQL solution?
Thanks for the response, haven't seen neon yet. I'll take a look at it. Totally understand trying to minimize a testing surface area.
It sounds like I could use MySQL if I want still. Nothing in wasp would stop me? Do you mind elaborting on the PgBoss? By jobs do you mean cron jobs?
yep. cron jobs! it's a killer feature
Why not use Postgres instead of MySQL?
Planetscale is a great easy to use and robust service. One that I am familiar with and confident in using. So the thought of having to not use it or learn/use a new external service is a bit disappointing.
I totally understand you all having limitations while in beta and thats okay. It does feel like a like a regression or loss of functionality given that Prisma fully supports MySQL.
Does that mean that Wasp cron jobs will not work at all with MySQL?
Yeah because pgboss is a postgres extension.
But if you like planet scale, try railway with postgres. Railway is even easier and the dx is great
@Hunter thanks for the feedback!
We should certainly look more in the future into supporting services like PlanetScale. As you said, currently it is about minimizing testing surface, but I believe it should be a viable option in the future. Just curious, when you used PlanetScale before, did you do it via Prisma, or some other way?
Hey @martinsos, no worries and hope it doesn’t come off the wrong way!
Yes my use of planet scale has primarily been with with Prisma.
@Hunter thanks, and we are always glad for the feedback!
We opened two GH issues for this stuff -> one to enable Prisma to support other db than postgres, and one to support external db hosting providers. Both of these won't be handled super soon, for the reasons you and us mentioned above, but we will be tracking them and accumulating ideas on them until they are ready to be taken on.
this is super unfortunate, is there a temporary way to use MySQL / postgres even without pgboss?
we were really hoping to use this with planetscale
You can certainly use PostgreSQL! But you can't use MySQL at the moment. We will be opening that up in the future, once Wasp becomes more stable.