R
Railwayβ€’2y ago
nikivi

Change to EU based Postgres from US and help connect with Postico

I created a Postgres db with railway and am trying to connect to it from Prisma. Code here: https://github.com/learn-anything/learn-anything I have difficulty making the sync work though. I read through https://dev.to/nextdev/how-to-connect-railway-app-with-nextjs-using-prisma-1eo8 But when I try to sync, there are no relations found. I don't know what to do. Also as I am based in EU, I would like my Postgres to be based in EU too, currently it's in US.
GitHub
GitHub - learn-anything/learn-anything: Organize world's knowledge,...
Organize world's knowledge, explore connections and curate learning paths - GitHub - learn-anything/learn-anything: Organize world's knowledge, explore connections and curate learning paths
DEV Community πŸ‘©β€πŸ’»πŸ‘¨β€πŸ’»
How to connect railway. app with nextjs using Prisma.
Welcome πŸ‘‹ friends to this new blog post where I will teach you how to connect railway and nextjs with...
7 Replies
Percy
Percyβ€’2y ago
Project ID: e7cc70ec-e047-497e-b91b-96ea9e6319a0
Percy
Percyβ€’2y ago
nikivi
nikiviβ€’2y ago
e7cc70ec-e047-497e-b91b-96ea9e6319a0/plugin/dc5fd8bc-a83c-4233-8a3f-2e95ea8f40cb/Settings
nikivi
nikiviβ€’2y ago
the schema I want to sync to railway and make queries to is here: https://github.com/learn-anything/learn-anything/blob/main/packages/db/prisma/schema.prisma
GitHub
learn-anything/schema.prisma at main Β· learn-anything/learn-anything
Organize world's knowledge, explore connections and curate learning paths - learn-anything/schema.prisma at main Β· learn-anything/learn-anything
nikivi
nikiviβ€’2y ago
I did put DATABASE_URL=postgresql://postgres:88.. in .env but for some reason it doesn't seem to apply 😦
Adam
Adamβ€’2y ago
All Railway services are based in the US. I heavily suggest hosting both your app and your database in the same region, whether that be both in the US on Railway or on another platform in the EU
nikivi
nikiviβ€’2y ago
unfortunate I wanted my db geo replicated on both eu and us but start with eu as I am based there going to use supabase as it supports eu data centers I did like the UI on railway though sadly
Want results from more Discord servers?
Add your server