What's the best way to make live updates to the deployed prisma database?
I want to update my admin user to test some bits. What's the best way to do this?
6 Replies
Hi @josh. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave:
----------------------
To interact with your deployed Prisma database, you can use the
wasp db studio command. This command opens the Prisma Studio, a GUI for inspecting your database. However, before you can connect to your production database, you need to open up a tunnel with fly proxy 5432 -a <db-name>.
Here are the steps:
1. Open a tunnel to your Fly production database: fly proxy 5432 -a <db-name>.
2. Run wasp db studio.
Please be careful when making changes to your production database. If you have set the DATABASE_URL with the production database URL in your .env.server file, remember to remove it after you're done to avoid accidentally making unwanted changes to your production database later.
Here are the sources for more information:
- Discord support thread: How to interact with database in prisma studio after deployment? (https://discord.com/channels/686873244791210014/1220423321422663820)
- Wasp CLI Reference (https://wasp-lang.dev/docs/general/cli#database-commands)
----------------------
Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:
----------------------
Sorry @josh, 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?Hey, not a dev, but I might be able to help. What do you mean by "update my admin user"?
I have a credit field which lets you use the service. I want to bypass the payments stuff and top up my credits directly to test
Then I think going to your User table, than manually changing your credits is your best bet
Alternatively, you could alter it through your db's terminal if db studio is giving you trouble. If you're using postgresql, I can help you there, but wasp db studio is your easiest option
This might help, if you are using Fly: https://github.com/wasp-lang/learning-materials?tab=readme-ov-file#running-wasp-db-studio-on-production-db
GitHub
GitHub - wasp-lang/learning-materials: A place to collect some usef...
A place to collect some useful learning materials for Wasp - wasp-lang/learning-materials
Thanks!