DB stuidio on fly.io
Hello,
Is there any easy way to get prisma studio avanible for postgres instance already deployed on flyio?
3 Replies
Hi @Kbk. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave:
----------------------
Yes, you can interact with your database on Fly.io using Prisma Studio. Here are the steps you can follow:
1. Open a tunnel to your Fly production database using the command
fly proxy 5432 -a <db-name>. This command will allow you to connect to your production database from your local machine. source (https://discord.com/channels/686873244791210014/1220423321422663820)
2. After opening the tunnel, you can run wasp db studio to interact with your database using Prisma Studio. source (https://discord.com/channels/686873244791210014/1220423321422663820)
3. If you have set the DATABASE_URL with the production database URL in your .env.server file, make sure to remove it after you're done to avoid accidentally making changes to your production database later. source (https://discord.com/channels/686873244791210014/1220423321422663820)
Please note that you need to replace <db-name> with the name of your database on Fly.io. Also, ensure that you have the flyctl CLI installed and you're logged into your Fly.io account. You can check if you're logged in with flyctl auth whoami, and if you're not, you can log in with flyctl auth login. source (https://wasp-lang.dev/docs/advanced/deployment/manually#flyio-server-and-database)
If you encounter any issues, you can refer to this Github issue (https://github.com/wasp-lang/wasp/issues/908) where similar steps were discussed.
----------------------
Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:
----------------------
Sorry @Kbk, 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?GitHub
Update the database docs on seeding the production DB on Fly · Issu...
We are looking to update this section of the docs to include instructions on how to seed a production db: https://wasp-lang.dev/docs/data-model/backends#seeding-the-database This is a tested workfl...
Wohooo @Kbk, you just became a Waspeteer level 3!