Troubles with prisma when deploying to fly.io
Im just finish my backend built with Bun, Elysia and Prisma and im about to deploy it on fly.io, but when i try to start my server i get the error of the image and my VM is shutdowned
Prisma keeps generating same migrations
Hmm, I am having some weird issue with my "Invoice" model.. whenever I generate a migration, it keeps adding these lines to the migrations, over and over... What could be the cause of this?
``SQL
-- AlterTable
ALTER TABLE Invoice MODIFY amountTotal DOUBLE NOT NULL DEFAULT (round(amountSubtotal + amountTax`, 2)),...Solution:
Solution: After using
prisma db pull I saw that the database returned these formulas without spaces, so I had to change those values in the prisma schema and now it seems to be okay 🙂
First time migration!
I'm workin on a project that's in production on a few servers (not all are in my control).
I want to add migrations to this project, and I'm wondering about 'Applying the initial migrations'.
Is the idea that I run this
npx prisma migrate resolve --applied 0_init in all of my production databases, or is this for the local one when I create the migration?...
SQLite with Prisma problems
Hello! I have app hosted on my VPS, its using Prisma with SQLite (before migrating to Postgres) but im getting some problems. When im trying to do operations after scraping (its using Puppeteer so its consuming a lot of resources on my VPS) and after scrapping process im trying to save data in DB, then im often getting these errors (On the screenshot). After reload apps with pm2 everything is ok. What may be issue? Its because i have too weak VPS (2core, 2gb Ram + 4gb swapped) or its just SQLite thing and Postgres should handle that?
If you need any more informations to help, please, tell me
Thanks 🙏...
