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.

e7cc70ec-e047-497e-b91b-96ea9e6319a0/plugin/dc5fd8bc-a83c-4233-8a3f-2e95ea8f40cb/Settings

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

I did put DATABASE_URL=postgresql://postgres:88.. in .env

but for some reason it doesn't seem to apply 😦

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

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