PostgresSQL Queries Tab...
Hi there, I'm following a tutorial through a bootcamp I previously attended in hopes of deploying the database used for a project at that time. In this tutorial it says I can just copy the SQL queries I already have into the Queries tab in the Railway Postgres deployment I have created. The problem is there is no Queries tab. Am I missing something here? Even the Railway documentation includes this Queries tab. Has something changed since this tutorial was created? I'd like to reproduce this database to get the entire project deployed to show to potential employers. Thoughts?
Project ID: e74d4599-d384-4005-ad2f-fd9ca6a3176c
Solution:Jump to solution
yes, railway has changed their database strategies, the databases are now just a service with a volume deployed from a docker image. for running operations on the database you would want to use a proper database client like dbgate or pgadmin
10 Replies
Project ID:
e74d4599-d384-4005-ad2f-fd9ca6a3176cSolution
yes, railway has changed their database strategies, the databases are now just a service with a volume deployed from a docker image. for running operations on the database you would want to use a proper database client like dbgate or pgadmin
Sorry, I'm still a bit new to this. Before I dig in further, you're saying dbgate or pgadmin are compatible with the Postgres deployment on Railway? They're used to manage queries and such?
indeed, the postgres databases on railway are plain only postgres databases, there is nothing special going on
Would it not be possible to just set the schema of the database with queries in a *.sql file, similar to what I'm already doing locally, or is that counterproductive/impossible/unwise?
i dont see why that wouldn't be possible
Okay. If I did go the dbgate/pgadmin route, do you yourself have a preference? This is a simple interview scheduler app I've built, so once the schema has been set it's just a matter of updating the data as appointments are scheduled or deleted. Nothing crazy.
i use dbgate myself
but you cant go wrong with either option
think dbgate is a much smaller install though, if that matters
Okay, I'll check it out. Thanks for your help Brody π
no problem π