Connection type: Direct or Transaction pooler
Hi everyone,
I can't decide which type to choose for my web-application:
Please tell me which type of connection that best fit my website.
Supabase already document those types of connection as:
Direct connection
Transaction pooler Shared Pooler
I can't decide which type to choose for my web-application:
- It is a simple website that host some kind of stories for users to read,
- And a form page where visitors could submit a new story.
Supabase already document those types of connection as:
Direct connection
Ideal for applications with persistent, long-lived connections, such as those running on virtual machines or long-standing containers.
Transaction pooler Shared Pooler
Ideal for stateless applications like serverless functions where each interaction with Postgres is brief and isolated.