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 - 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...
Project ID: e7cc70ec-e047-497e-b91b-96ea9e6319a0
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
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

Looking for more? Join the community!

Want results from more Discord servers?
Add your server
Recommended Posts
Cap costHi there, Is there a way we can set a cap to our cost on Railway? I understand that it's 'pay for whMongoDBThis is a very noob question. I'm understanding my pricing before getting started. Do I still have tinvite collaboratorsCan you invite people to your deployment and let them look at your logs?BullMQ (with Redis) on Railway keeps getting ECONNREFUSED errors when running locallyI used the BullMQ Template that is offered by Railway, which spun up a node codebase for BullMQ and Can't connect to postgres from inflight wifiI'm trying to dev my web application locally, but I can't connect to my railway postgres db. I keepi deployed my nodejs express app it is working but domain inst workingit says 'One Moment Your deployment should be live soon' when visiting the domain but in logs 'Semy service got stopped due to issue in paymentNow after payment I want to restart railway service what is need to be done?Periodic UI 404During a build, I keep getting a periodic 404. it disappears after a few seconds and I can see the bPrisma requires MongoDB to be run as replica setIs there functionality in Railway to deploy MongoDB as a replica set? Else, has anyone had success cGetting a static IP address to make requests from?So to access the NJT api, for whatever reason, you need to get a static IP whitelisted on their reveSetting up naked domain on Google DomainsMy understanding is that I need to create a new A record that points to the sites IP address. Where Env variables cannot be retrievedAfter setting my start command to `npm run start`, I can no longer retrieve env variables I set in mCreating an environment doesn't import servicesI'm creating a new `development` environment that will mirror our `production` environment pretty clAdjusting max number of threadsIs there a way to adjust the limit of threads through Nixpack? Currently using Pupeteer, and runniDisk space questionLet's say I have a shared monorepo and my build process for a service is like this: **Given: -I'm uDeployment Failed during build process - Error: Docker build failedThe last 3 deploys failed with this error: executor failed running [/bin/bash -ol pipefail -c bundl