While building the app, I am using Supabase for data storage and my own authentication. But, when I deploy the APP on my server (on-Premise) or AWS, I do not want to use Supabase, but instead direcltly use PosGreSQL instance on same backend-server. I am not planning for any middleware to expose PostGreSQL as the table structure and columns etc, will be same as that of Supabase.
Is it possible?
I don’t understand, you would have two identical DBs and storage with the same data (one in Supabase, one full-coded) and want to be to self-host two identical WeWeb frontends (each connected to one)?
I do not want to use Supabase in PROD … but in testing I want to use Supabase. I use SQL Editor to create tables, foreign keys, constraints, etc. So, I can create a standalone version of PostgreSQL on a docker container on same server and all the data will live there in PROD.
So, testing supabase, deployment/PROD just direct PostgreSQL.
Data will come from PROD… so conversion/data-migration will take care of populating the data. It will be scrambled and downsized for testing. It would be bulk uploaded manually.
Ok so if the question is can you self-host a WeWeb frontend with a fully-coded backend, the answer is yes.