DuolearnHQ / wealthwise

A Personal Finance Tracker that helps with understanding of multiple technologies on the front end.
2 stars 4 forks source link

Setup PG migrations to allow people to quickly bootstrap their supabase tables with the project pre-defined schema #5

Closed pavankpdev closed 10 months ago

pavankpdev commented 11 months ago

Description

The project aims to enhance the onboarding experience for users by providing a streamlined process to set up Supabase tables with the predefined schema. This will be achieved through the implementation of PostgreSQL (PG) migrations.

Goals

  1. Bootstrap Supabase Tables: Create PG migrations that define the necessary tables and relationships in Supabase based on the project's schema.

  2. Seamless Onboarding: Enable users to quickly set up Supabase tables by running the provided migrations, reducing the time and effort required for initial project setup.

  3. Maintainability: Implement a structure for PG migrations that ensures ease of maintenance and scalability as the project evolves.

Tasks

Important Considerations

  1. Ensure compatibility with the project's current Supabase configuration.
  2. Provide a comprehensive guide on executing migrations to accommodate users with varying levels of technical expertise.
  3. Include any necessary steps for handling potential migration conflicts or issues.

Expected Outcome

Users should be able to initiate the PG migrations effortlessly, resulting in a fully set up Supabase database that aligns with the project's schema.