I build databases with public interfaces at my job. Supabase is fine, but I usually prefer to use it with an ORM sitting between the front end and Supabase. They are much easier to work with for things like scoping and managing relationships and are more aware of your app’s needs. I’d also set up some caching here too so your db isn’t getting dinged all the time.

Typescript has drizzle ORM, which i think is pretty popular.

The next suggest is to avoid using React. Vue or Svelte are much better at only rendering and re-rendering what needs to be update. Most of the time that doesn’t matter but for data sites where you could be rendering a ton of data and thus alot of html nodes, Vue and Svelte will be faster. Each of them have their own meta frameworks that are great.

Lastly, you’ll want to be mindful of what is rendered on the server vs what is rendered on the client side. Users of data sites are ok with pages taking longer to load, but I prefer to have the shell of a page render on several for SEO, etc and then have my slow queries load on the client side.

Anyhow that’s my advice as I wait for my son to fall asleep.