Unable to use postgres in middleware

[tardy lagoon]

See title, not much else to report apart from it doesn't work due to various limitations on the edge runtime. Is there a workaround?

[tardy wyvern]

Post created!

🔎 This post has been indexed in our web forum and will be seen by search engines so other users can find it outside Discord

🕵️ Your user profile is private by default and won't be visible to users outside Discord, if you want to be visible in the web forum you can add the "Public Profile" role in id:customize

✅ You can mark a message as the answer for your post with Right click -> Apps -> Mark Solution
(if you don't see the option, try refreshing Discord with Ctrl + R)

[tardy lagoon]

For reference, we host our own postgres and don't want to use a different host like Vercel Database

[nimble lake]

Why are you trying to run pg in your middleware is my first question @tardy lagoon

[tardy lagoon]

Need to validate/renew sessions in cookies

[nimble lake]

Make an api route, and call that from your middleware

[tardy lagoon]

🥲 then i'll have to make that protected somehow too, i guess

[hollow bone]

you can deploy a ws proxy in front of your db instance to access the data in the edge runtime https://github.com/neondatabase/serverless/blob/main/DEPLOY.md