how can I add SQL code to create the tables in MySQL service?
I am trying to implement an API with NodeJS and a MySQL database, the problem arises when adding the queries to the database, the queries tab does not appear to add my SQL code, how can I add my SQL code to create the tables ?
24 Replies
Project ID:
N/AN/A
Solution
you would want to use desktop software like dbgate
In the documentation I saw that queries could be added to create the tables with SQL code.
railway doesn't have that particular feature anymore, you want to use software like dbgate to do that
what is dbgate?
dbgate is software to run queries and manage the data in your database
What I want is for railway to let me create the tables in my database that I create there
that feature never really worked well, it's a better idea to use dedicated software for it, like dbgate as previously mentioned
And dbgate lets me deploy my database to production?
you deploy the database on railway, and use dbgate to manage the data in the database you have on railway
Ok, how do I do that?
have a look at the dbgate website
https://dbgate.org/
ok, created my database in dbGate, then how can I link the database with railway?
you don't create a database in dbgate, you use dbgate to connect to the database you created on railway
ahhhh, ok
How to connect my railway database with dbGate?
some documentation
you go to the variables tab on your mysql service and copy the variables dbgate wants you to fill in
you can read dbgates own documentation on how to use that software
Is dbGate the only software I can do this with?
there's plenty, that's just the software I'm recommending
Can you mention a few more to try?
only mysql workbench and dbeaver are coming to mind for mysql
I really appreciate your help, thank you my question was solved
no problem