R

Railway

✋|help

Join Server

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

Nnikivi1/22/2023
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.
Nnikivi1/22/2023
e7cc70ec-e047-497e-b91b-96ea9e6319a0/plugin/dc5fd8bc-a83c-4233-8a3f-2e95ea8f40cb/Settings
Nnikivi1/22/2023
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
Nnikivi1/22/2023
I did put DATABASE_URL=postgresql://postgres:88.. in .env
Nnikivi1/22/2023
but for some reason it doesn't seem to apply 😦
ADA Dumb1/22/2023
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
Nnikivi1/22/2023
unfortunate
Nnikivi1/22/2023
I wanted my db geo replicated on both eu and us
Nnikivi1/22/2023
but start with eu as I am based there
Nnikivi1/22/2023
going to use supabase as it supports eu data centers
Nnikivi1/22/2023
I did like the UI on railway though sadly