2 years ago
I am try trying to use railway postgress db with @vercel/postgres. Is it compatible? How do I map railway variables to required vercel env varaibles?
17 Replies
2 years ago
I would just use the standard pg node library
hm i like vercel api and it says that it is fully compatible with pg node. so i assume i can use it with railway postgress just need to figure out connection string
2 years ago
You should be able to use the DATABASE_URL environment variable.
i tried to but i am getting error: VercelPostgresError - 'invalidconnectionstring': This connection string is meant to be used with a direct connection. Make sure to use a pooled connection string or try createClient() instead.
2 years ago
I think that would be a question for vercel's documentation?
2 years ago
if I'm not mistaken pg has a pooled client
hm they seem to be just checking url to determine connection string type:export function isPooledConnectionString(connectionString: string): boolean { return connectionString.includes('-pooler.'); }
2 years ago
yeah. thank you. i guess i'll go with pg. not a big deal just wanted to use vercel's package
ah seems like pg is not edge compatbile, so there is a benefit of vercel/postgres
2 years ago
railway does not run any user workloads on the edge