Configure Supabase bucket and RLS policies for project pitch deck files

[coderabbitai]

Overview

We need to configure a Supabase bucket to store project pitch deck files uploaded through the project pitch page. We also need to implement Row Level Security (RLS) policies to ensure secure access to these files.

Requirements

1. Create a new Supabase bucket called 'project_pitch_decks'
2. Configure appropriate content types (PDF, PPT, etc.)
3. Set up RLS policies to:
   • Allow authenticated users to upload files to their own projects
   • Allow only project owners and collaborators to view files
   • Prevent unauthorized access and deletion

Related Issues

• Issue for creating the 'project_pitch' table (to be linked once created)
• Create "Pitch & Story" View #191 - Implement project pitch page with story editor and media upload (addressed in PR Feat/pitch and story view #220)

Notes

• The UI for file uploads has been implemented in PR Feat/pitch and story view #220
• The project_pitch table will reference files stored in this bucket
• Maximum file size should be limited to 10MB as implemented in the UI

[Godsmiracle001]

I'm interested in working on this issue as I have hands-on experience with Supabase, PostgreSQL RLS, and secure file storage configurations. I can efficiently set up the project_pitch_decks bucket with the correct content types, implement RLS policies to ensure secure access, and enforce file size limits.

Additionally, I’ll ensure that project owners and collaborators have controlled access while preventing unauthorized actions. Since the UI for file uploads is already implemented, I'll focus on seamless backend integration.

Looking forward to contributing!.

[Kingsuite]

I'd like to handle this task.

[AndlerRL]

Hey @Godsmiracle001 how is the issue going? Anything please just let us know!