Trying to connect with private database instead of public url (also sql editor question)
scottk16
HOBBYOP

2 months ago

Hi, I'm developing a discord bot and attempting to connect it to a Postgres database hosted on Railway but my code doesn't seem to be able to find the Database unless I have it set using the url and not the private placeholders. Any ideas?

Also in addition, just wondering how to open the SQL Editor so I can drop tables etc, thanks

0 Replies

adam
MODERATOR

2 months ago

Railway does not have a built in editor, you’ll have to use an external one like dbgate


adam
MODERATOR

2 months ago

as for why the discord bot isn’t able to connect through the private network, it could be any number of reasons.

What database are you using? Have you taken a read through this page? https://docs.railway.com/guides/private-networking


scottk16
HOBBYOP

2 months ago

Nope, haven't gone through this yet, will take a look now, thank you, and for the DbGate I assume I can do this? https://railway.com/deploy/dbgate


adam
MODERATOR

2 months ago

huh, didn’t know there was a template


adam
MODERATOR

2 months ago

personally I have it installed on my pc, but that works too


brody
EMPLOYEE

2 months ago

We don't? since when? 😆


adam
MODERATOR

2 months ago

Since the old one didn’t work, was it updated recently?


brody
EMPLOYEE

2 months ago

Yes lol


adam
MODERATOR

2 months ago

Ah great, I just use dbgate I didn’t know


scottk16
HOBBYOP

2 months ago

So where can I find the editor? :>


adam
MODERATOR

2 months ago

From the database tab in the database service!


adam
MODERATOR

2 months ago

1422627570536681500


Loading...