search

wasp-lang / wasp

The fastest way to develop full-stack web apps with React & Node.js.
https://wasp-lang.dev
MIT License
13.47k stars 1.18k forks source link

Explore options for new DB engines (MySQL, MSSQL and similar) #1261

Open infomiho opened 1 year ago

infomiho commented 1 year ago

Since Wasp uses Prisma as its abstraction layer for the database, it should be possible for us to expand our support for SQLite and PostgreSQL to more database engines.

We should take into account if our maintenance surface area will increase too much or not.

One caveat to note is: we already support some PostgreSQL specific features (PgBoss executor for jobs) and we should see how do we deal with these DB engine specific features.

Martinsos commented 1 year ago

Nice job capturing this @infomiho ! Slightly related to #1265 -> external db hosting.

infomiho commented 5 months ago

Some more info about SQLite (Turso):

It's a fork designed for the cloud. The coolest thing is that you can run it wherever you want and it has such low latency that you would still have consitent data like if it was running locally. By default it runs distributed to the edge on Fly.io infra.

https://ptb.discord.com/channels/686873244791210014/1204466958150537256/1235537458926718976