search

andraz / OpenAGI

DIY AI landscape growing safely in the privacy of your own computer
MIT License
8 stars 3 forks source link

PG slow to connect #5

Open prohoundsys opened 3 weeks ago

prohoundsys commented 3 weeks ago

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 commented 3 weeks ago

Upgrading to a pooler would help

andraz commented 3 weeks ago

@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 commented 3 weeks ago

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

andraz commented 3 weeks ago

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