PG slow to connect

[prohoundsys]

Database connection is slow to connect, giving latency of ~1 second roundtrip to refresh UI in the second browser window after setNodeState job completes from a change in the first browser window.

[tombalaboba]

Upgrading to a pooler would help

[andraz]

@paulhuntr we can try supabase/supabase-js

We might add subscriptions https://supabase.com/docs/reference/javascript/subscribe in near future, to automate the updates.

[nuggetkio]

@paulhuntr wait with the pooler, local solution could be a better fit for now, supabase is still ok for backup cold storage

[andraz]

I am testing https://github.com/motherduckdb/duckdb-async because Supabase does not support PG h3 extensions like https://github.com/isaacbrodsky/h3-duckdb