a year 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?
0 Replies
a year 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
a year 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.
a year ago
I think that would be a question for vercel's documentation?
a year 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.'); }
a year 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
a year ago
railway does not run any user workloads on the edge