A place for developers to talk about building on Farcaster.

/dev

⚠️ FarcasterUserStats.com is down

i really need help, this is frustrating

‼️ postgres db connection limit maxed, i have a pool in place, not sure if that actually works or not

sql queries to the db should be less than 1-2s max, but now they're going over 15s timing out

building reel.farm and farcasterstudio.com

so the issue is the connections, not the query timeouts? As already stated, how are connections being released? Does each query open a new connection, and does that connection get released after the query? Kind of need to know the setup

simplified version of what im doing, feel free to correct me if i'm wrong

import { pool } from '../db'
const client = await pool.connect();
const response = await pool.query(`query here`);
client.release()

if you are able to look over how im pooling connections and see whats going on that would be amazing

https://github.com/mattwelter/farcaster-user-stats

kind of tough not to know the infra, I am mostly on aws infra these days. Clearly the above is not working 🤣 , or it may be correct but isn't working with your infra.
Can you verify that the connections are in fact being released? I will just be asking annoying questions at this point