[feature] Migrate Library to supabase

[mariojsnunes]

An overview of what needs to be migrated

Database Schema

Projects
Categories (done)
Tags (done)
Images (done)
Useful (done)
Moderation
Steps
File download counters (separate table)

Migration

• Data and Images
• Comments

Moderation Flow

There are notifications and emails being sent on moderation status changes

Technical details

• Create the required tables locally
  • Decide between storing the steps in JSON or a separate table
  • Categories, tags and usefulVotes are already done for questions, the same tables/approach should be reused
  • For images, follow the same approach as questions
  • Create a table for storing file download counters (must be a way to tie the file to a project, can make it generic though)
• Generate the migration script supabase db diff --file [migration_name]
• Update the project page to supabase data
• Update the project edit form to use supabase data (use a service approach instead of store - check questionService.ts)
• Update library page (project list with text search and filters)
• Update comments to use the newer component (same as questions)
• Create endpoint to download a project file, and increment download count server-side