website production build issues
Hey everyone. So I'm currently running into issues with my production deployment and the database I'm using for a website for my work.
I have been using Prisma as my ORM with a sqlite db and deploying to Vercel (which is apparently not supported anymore?) which was working like 6 weeks ago with no issues. I have started working on it again and suddenly everything is broken on the deployment side.
I'm considering changing my db to be postgres instead as this is supported by Vercel but apparently I need to use a 3rd party db provider. I'm considering Supabase but I don't really understand why I need to use it in the first place. If I already have the DB setup in the files of the app why do I need to store it somewhere else instead? or have I missed something in my understanding of how the db works?
I have been using Prisma as my ORM with a sqlite db and deploying to Vercel (which is apparently not supported anymore?) which was working like 6 weeks ago with no issues. I have started working on it again and suddenly everything is broken on the deployment side.
I'm considering changing my db to be postgres instead as this is supported by Vercel but apparently I need to use a 3rd party db provider. I'm considering Supabase but I don't really understand why I need to use it in the first place. If I already have the DB setup in the files of the app why do I need to store it somewhere else instead? or have I missed something in my understanding of how the db works?

back-end