I am the father of a 2-year-old, extremely premature son with a complicated medical condition. We visit more than 15 doctors and I decided, as a volunteer, to create a project next year that should help all parents and doctors to effectively exchange information, medical reports, records and visualization of various growth or health information, etc. I have already received a promise of cooperation and confirmation of the contribution of this project from a number of leading doctors from various hospitals.

I am an architect, developer and server administrator, team leader with more than 20 years of experience and dozens of large projects from analysis, through frontend/backend, to database, network and hardware.

I am considering whether to use the PostgreSQL database directly for the project and program all my own backend, or to use self-hosted Supabase with row-level security, which would eliminate approx. 70-80% backend for GraphQL/REST API. The time saved on backend programming could be spent on other useful functions for end users - integrating AI into some processes, etc.

The entire solution will be run on our own powerful servers (AMD EPYC 9554, Intel Optane NVME drives, 768GB DDR5 RAM)

Does anyone have any current experience (not more than 6 months old) on the basis of which you would recommend or not recommend Supabase for such a project? I've read a couple of negative experiences from 2023, but I wonder if it has improved over the last year. If you answer, please provide specific experience and why YES/NO.

Thank you very much for any advice.