Issues with Prisma <> Postgres <> Railway? | Railway | Page 1

nocturne heathBOT Mar 13, 2024, 2:57 AM

#

Project ID: 98f66160-ce86-4b15-a73b-cab912256208

supple locust Mar 13, 2024, 2:58 AM

#

98f66160-ce86-4b15-a73b-cab912256208

gleaming terrace Mar 13, 2024, 3:07 AM

#

how are you connecting to the database? try using the private network if you aren't already

supple locust Mar 13, 2024, 4:21 AM

#

I am using a conneciton_url through Prisma that is essentially just the pg user / password. Can you elabroate on the private network?

gleaming terrace Mar 13, 2024, 4:30 AM

#

try using DATABASE_PRIVATE_URL
https://docs.railway.app/guides/postgresql#variables
https://docs.railway.app/reference/private-networking

supple locust Mar 13, 2024, 4:20 PM

#

Testing now, but i was hoping to have a solution that works even when running on localhost. As far as I know, 1000 queries in a 10 second query per user isn't anything crazy, right?

#

Just tested using the private database URL, this did not fix the issue and we are still seeing long load time

#

Any other ideas? @gleaming terrace

gleaming terrace Mar 13, 2024, 4:33 PM

#

try making the same queries using raw SQL, as to eliminate prisma as the issue

supple locust Mar 13, 2024, 4:36 PM

#

I can try that. Do you have preferred typescript postgres client / lib that would be good to try this with?

gleaming terrace Mar 13, 2024, 4:37 PM

#

I think the go to pg npm package would be more than sufficient

supple locust Mar 13, 2024, 6:08 PM

#

@gleaming terrace was able to confirm the issue still happens when using pg raw over prisma

gleaming terrace Mar 13, 2024, 6:48 PM

#

and you are now connecting over the private network?

supple locust Mar 13, 2024, 7:00 PM

#

Yes! I set database_url to private_database_url in my env vars

gleaming terrace Mar 13, 2024, 7:23 PM

#

is there some postgres config you can tweak? the postgres databases railway deploys are not managed in any way, they are just the bog standard postgres docker images provided by postgres with SSL on top

supple locust Mar 13, 2024, 8:28 PM

#

I see. I just tried saving our data to a local postgres server and I'm still running into this issue, so I agree it's likely not a railway specific config thing. What sorts of postgres config hve you seen for issues like this? I'm absolutely baffled so any help would be appreciated

#Issues with Prisma <> Postgres <> Railway?