Prisma database works but Railway Tables UI has no tables
I had reset my database using npx prisma migrate reset and it works with my new schema but I noticed that the Railway UI says I have no tables. This is strange because before I reset it I had all my tables and I could see the data, but now after resetting and migrating to new database schema, I can access new data but I have no tables in the UI
13 Replies
Project ID:
N/A
the data view for plugins is not the best, please don't rely on it for data observations or data entry
Okay but how can I query the data if I dont have a table
please don't rely on either the data or query tabs for plugins
use
railway connect Postgres
alright where do I use that command?
in a local terminal
you can find installation instructions for the railway cli here
https://docs.railway.app/develop/cli
I'm a beginner so I may get this entirely wrong but I don't use the cli because its handled by prisma, are you saying that I should just do the queries in there instead and there should be a table there for me?
Solution
something like pgadmin might suit you more
okay I will look into it thanks. and there is not future fix for the web UI?
but if you can do everything you need with prisma then for sure just use prisma
not any time soon, its not that big of a priority since tools like pgadmin exist
alright thank you