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.
3 Replies
Thanks, I have figured it out
So how did you attain this ? It will be awesome teaching others, is it?
I just figured out that
Transaction pooler is the right choice, since it does not need to stay live all the times.
"I just asked the AI", LOL