Trouble Connecting AppSheet to Supabase Database

AppSheet AppSheet Q&A
, ,
1

Hi everyone,

I’m trying to connect my AppSheet app to a Supabase PostgreSQL database, but I keep getting the error:

“Failed to connect to database.”

I’ve gone through multiple settings on both sides, but nothing seems to work. I was told that AppSheet only uses IPv4 connections, so I specifically tried using Supabase’s Session Pooler endpoint (since the Direct Connection is IPv6-only), but I still can’t get AppSheet to connect.

Has anyone here successfully connected AppSheet to Supabase PostgreSQL, especially using the Session Pooler for IPv4? Any guidance would be greatly appreciated.

Thanks,
Glen

2

If you are not aware, many database providers require a white list of servers/IP’s allowed to connect to the database instance - maybe that’s what is meant by Session Pooler?

Have you supplied this white list to the database?

You can find that list of IP’s here. Note that this list is regionalized. Choose the list that applies to your geographic region, copy the list and simply paste into the property within the database provider.

I hope this helps!!

2 Likes
3

thank you, i will look into that !

2 Likes