Hi! I have two Next.js sites that share a Supabase database with a products table. Most products are shared, but if a user uploads a product on site_a, it should only be visible there. Users should also only be logged in on the site they signed into — auth is not shared.
What’s the best approach: separate Supabase projects per site, or one project with shared DB but separate auth? Or something else?