Connect Appsheet to the Supabase database

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? 

hoanguyen_0-1714718671762.png

hoanguyen_1-1714720371342.png

hoanguyen_2-1714720386908.png

hoanguyen_3-1714720400902.png

hoanguyen_4-1714720413953.png

pool Size

hoanguyen_5-1714720444759.png

2 2 431
2 REPLIES 2

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?

Top Labels in this Space