Replies: 2 comments 2 replies
-
First, I'm curious what's driving the move. Where did SQLite fall short for you? I would start by making a version of the Epic Stack with postgres so you can get an idea of what the end state looks like and what's required. Then you'll need to determine the ratio of service reliability to migration difficulty you're interested in. If you're ok with a little data loss, then it'll be much easier because you can ssh into your box, run a script to move everything from the SQLite db to the Postgres db, then deploy a version of the app that uses the postgres db instead. You would lose data added between running the script and deploying the app. You could probably run a secondary script to make up for that difference, but it wouldn't be perfect. If it's critical for you to have a seamless migration, then you'll want to deploy a version of the app that performs writes to both databases for a while, then run the migration script, then deploy a version that reads from the postgres db only, at which point you can remove the SQLite database. It's a bit more work, but it eliminates issues with data loss. There may be tools that make doing these things easier, but I've only gone the opposite direction and I was ok with a bit of data loss so this is as much help as I can offer. Good luck! |
Beta Was this translation helpful? Give feedback.
-
Thank you for the quick answer, it's only because of these issues (but I hate to switch). 10403 and all that. We ran so many times in those panic errors never able to really understand why, it just doesn't seem solid enough or at least maintained well enough from the Prisma team to fully rely on it. Now with Prisma Pulse not compatible on top, it's too many reasons. Data loss is completely fine, will go with the first option then and hope that will fix our issues. Now I guess we cannot store images in the db the same way it's done in the current Epic Stack right? Thank you for your help! Maxime |
Beta Was this translation helpful? Give feedback.
-
Hey guys 👋
We are looking to switch our epic-stack app from SQLite to PostgreSQL, and would like to do it the best way possible as we have active users. Any helpful links, or advices on how to do this best? We are using fly.io for hosting. And of course, we would make our version of the Epic Stack with PostgreSQL available to everyone.
Thanks a lot.
Maxime
Beta Was this translation helpful? Give feedback.
All reactions