can i do let my worker run for 5 minutes f.ex with "waitUntil" and a promise timeout that resolve after 5 minutes or 4 minutes? (currently i have free plan if that is important), after that 5 minutes it would fetch something and send response

thats called cron job

ah thanks!

use alarms in Durable Objects

whats the recommended way for connecting to a postgres db from a worker? cloudflare seems to have articles pointing lots of different ways.. and i also see the neon stuff

atm you'll need to connect over HTTP somehow

Stuff might be coming soon 👀 https://twitter.com/CherryJimbo/status/1654505957316018177

wow, my exact need.

i've always found myself needing things 3-6 months ahead of when cloudflare is releasing something :/

i wonder how connection pooling will work there

gonna need a DO for that?

yea i've wondered about that myself for any db connection from a worker

iirc you can do it in a DO

personally I'd setup pgbouncer and use that

https://blog.cloudflare.com/neon-postgres-database-from-workers/ states

Even when Workers eventually support raw TCP communication, we will not have fully solved our problem, because database connections are expensive to set up and also have quite a bit of memory overhead.

A DO would solve that, since you save the connection between requests to it, and it'll keep it around for a while after each request

not fully solved though at least not without building a lot of connection pool logic. for example you don't want only a single connection, you would want multiple and you also would want a different number of db connections and client connections, etc. and this is just the tip of iceberg

The majority of users would get by completely fine on one lol

1 single connection? I dunno... it would work fine until very suddenly it doesn't and then you'd be asking yourself why you didn't just setup a proper connection pooler while your app is down in production and you are scrambling

pgbounce sounds better

the mystery for me is the word "soon" if this is out in a month i'll hold off. if its 6 months. i'll need another solution

do you already have a postgres db? because one option is to use Supabase. you get a dedicated Postgres db and can use their HTTP APIs (this is what we do)

we try to call Supabase directly from the client (browser) as much as possible but in a couple situations we call it from in a Worker and it is easy to do

yea i already have a postgresdb. I can just host the webhooks somewhere else. but i wanted to use cloudflare

another option is putting PostgREST in front of your db

yea i saw some cloudflare docs recommending that as well

actually I think Supabase uses this

it has built in connection pooler

so might as well do that since you'd have to setup a connection pooler anyways...

supabase does look interesting, seems like it can be selfhosted as well