When I use AppSheet to connect to the Supabase database, I encounter an issue which is 'max client connections reached.'
The reason, as far as I understand, is due to the mechanism of AppSheet when performing CRUD operations asynchronously. Each time it does an async operation, AppSheet seems to async all tables on Supabase, leading to max connections being reached.
I've tried changing ports like 5432 and even 6543, but I still encounter similar errors. Has anyone on this forum encountered a similar situation and could share how to resolve it?
pool Size
I am facing similar issues
I too am facing similar issue: Unable to fetch app definition. Error: Data table โclaimsโ is not accessible due to: xx000: Maax client connections reached.
I am setting the app up, have almost no data & no other users. A simple edit & save results in this. Pretty much makes me think that Supabase & AppSheet will not be a good combination. Any thoughts anyone?
User | Count |
---|---|
18 | |
10 | |
5 | |
4 | |
3 |