Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hey, I want to make public buckets so that it's easier to store links to files in the DB, but I am not sure if I can restrict access to view/open those links via RLS. Can someone confirm?

It becomes a hassle when you're working with dozens of files to show as preview with signed urls.

You cannot restrict the public bucket public URL.
You do have to have RLS for all other operations on it.