@maxhodges I’m sorry you’ve had a bad experience in the past with Prisma. We have chosen Prisma 2 specifically for developer ergonomics and their ambitious roadmap (plus migrations and other really nice things). I don’t have a crystal ball and can’t predict the future, but we are currently well aligned with Prisma on what we both want for its future.
As @guledali mentions, I do indeed have a small investment in Prisma, as I’m a believer in what they’re doing. I made the investment after we chose Prisma to be integrated into Redwood. Through this investment I hopefully will also have a bit more influence in making sure Prisma and Redwood play nice together! At the same time, if Redwood and Prisma grow apart, then my first priority is to make sure that Redwood does what is right for Redwood (not for my pocketbook).
As for the other options you mentioned, I’m not a fan of auto-generated full GraphQL APIs from a DB schema (a la Hasura). For long term maintainability, it’s important to handcraft your API to suit the needs of the client. Experience tells me that exposing too much of the DB implementation to the frontend is an anti-pattern. Regarding FaunaDB, we intend to support it via Prisma 2 (it’s on their roadmap). In fact, Fauna may be the ultimate DB for Redwood given its serverless focus and edge characteristics. But right now Fauna is too hard to use. They seem to be heavily focused on DX and I’m hoping that will lead to a bright future where Fauna is the best choice for Redwood.
Hopefully these explanations are helpful. I don’t believe that choosing Prisma 2 will result in Redwood being “stillborn”. Quite the opposite has been indicated from the feedback we’ve gotten so far. Have you had a chance to go through the Redwood Tutorial yet? I think that’s a nice indication of the DX we’re shooting for when it comes to Prisma 2. And we will endeavor to get the features out that people need. Being open source is a huge advantage for something like the Prisma 2 Client and Migrate. We can help from the outside to make it all happen!