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.<p>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.<p>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.<p>The entire solution will be run on our own powerful servers (AMD EPYC 9554, Intel Optane NVME drives, 768GB DDR5 RAM)<p>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.<p>Thank you very much for any advice.
You didn't say if you'll have a front end.<p>Supabase works best with single page apps. However a lot of the frameworks are moving towards server side react, so the need for having a rest API is going away.<p>So I would actually say use nextjs and get an AI such as bolt to generate an MVP.<p>If you are running AI such as LLM's you need GPU's. LLM's are constrained by memory bandwidth not CPU and GPUS have a ton of memory bandwidth.<p>Postgres is always a sold choice and RLS is defence in depth anyway.
Hey there, supabase ceo here. I did a cmd+f for "HIPAA" and didn't find it anywhere in your description. I don't mind whether you use supabase or not, but please make sure that you take care of patient data. Everything you do should be HIPAA compliant.<p>The number 1 feature of your project should be security. Supabase is just Postgres + tools - it will be as secure as you decide to make it.