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
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.
Was this page helpful?