Connection type: Direct or Transaction pooler
Hi everyone,
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.
It may look silly question (I don't know actually), but I have no experience in back-end development, I had to do this on my own since I have no choice.
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.
It may look silly question (I don't know actually), but I have no experience in back-end development, I had to do this on my own since I have no choice.
Please tell me which type of connection that best fit my website.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.
