Any plans to support Prisma/SQL Server? I know 🤦♂
I recently joined a team that uses sql server database. Now I cannot use wasp!
7 Replies
Hi @Rdiohd. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave:
----------------------
I understand your frustration with not being able to use Wasp due to your team's use of SQL Server. Currently, Wasp only supports SQLite and PostgreSQL as database backends. However, there are plans to expand database support in the future.
According to the Github issue on exploring new DB engines, the Wasp team is considering adding support for more database engines, including MySQL and MSSQL (SQL Server). This is possible because Wasp uses Prisma as its abstraction layer for the database.
However, it's important to note that there's no specific timeline for when SQL Server support might be added. The team needs to consider factors such as maintenance complexity and how to handle database-specific features.
In the meantime, if it's possible for your project, you might consider using PostgreSQL with Wasp, as it's a powerful and widely-used open-source database that Wasp fully supports.
I apologize that Wasp doesn't currently meet your needs with SQL Server, but the team is aware of the desire for broader database support and is exploring options for the future.
----------------------
Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:
----------------------
Sorry @Rdiohd, I seem to be having a bit of trouble. Don't worry though, I've pinged my support and they will try to fix me up! :technologist:
Perhaps try again in 15mins?
Hey @Rdiohd, are you talking about Microsoft's SQL server?
Yes. Microsoft sql server
Hmm, that's a good question. It seems Prisma already supports it. I'll create an issue, but before that...
@martinsos Any reason we're restricting databases specifically to postgreSQL and SQLite?
Thanks 🙏
We are restricting just to reduce the surface area of Wasp DB logic, while we are in Beta! Mostly for small stuff like
wasp db start and some deployment scripts, so that we don't have to deal with multiple databases at the moment, and then we will add it once Wasp is more polished (1.0). But it does suck that you can't use it right now hm. Maybe we should rethink this and enable it right now, and be ok with not having full support for some stuff hm, but still it is not trivial amount of work potentially.@Rdiohd Created an issue here: https://github.com/wasp-lang/wasp/issues/2536
In all honesty, his probably isn't happening before 1.0. That said, if you have ideas and ambitions to make it happen, PRs are welcome!
GitHub
Consider supporting multiple DB backends · Issue #2536 · wasp-lang/...
Prisma supports many DB backends: https://www.prisma.io/docs/orm/overview/databases Wasp only supports SQLite and PostgreSQL. We should investigate and consider supporting more of them. For example...