[MVP]: Supabase integration

[HMarzban]

Use Supabase as a back-end service,
We need two instances of Supabae! one for production, the other one for the stage.

Resource: https://supabase.com/docs/guides/self-hosting/docker

Note: Recommended to use a separate Postgress database for each instance.

[HMarzban]

Supabase studio (admin dashboard) in production mode needs to protect via Authentication,
Therefore the easiest way to restrict access is to set auth_basic in the Nginx config.

Resource: How To Set Up Password Authentication with Nginx

[HMarzban]

Does 1 visitor = 1 connection?

No. With connection pooling, many users can share a few database connections, you can have 10 connections serving a 1000 users. This is because in a web application the web users are not hitting the database constantly(GUI work, idleness, etc) and when they need to, they "borrow" a connection, fulfill a request and then "return" the connection to the pool.

There are some more details on https://supabase.com/docs/guides/database/connecting-to-postgres

Resource: Performance Tuning

Resource: Understanding performance, response time & connection limits from a newbie point of view