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
Project ID:
e7cc70ec-e047-497e-b91b-96ea9e6319a0You might find these helpful:
- postgres
- New Tables in Nextjs/Prisma and Nextjs/Railway/Postgres resource
- Railway PostgreSQL sometimes unable to connect
β οΈ experimental feature
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
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
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