lyqht/Octokit-lite

Create SQL migration scripts

Open

#24 opened on Oct 4, 2022

View on GitHubContributor guide
 (3 comments) (0 reactions) (0 assignees)TypeScript (11 forks)auto 404
backendenhancementgood first issue

Repository metrics

Stars
 (17 stars)
PR merge metrics
 (PR metrics pending)

Description

Description

At the moment, I have been adding migration scripts manually to CONTRIBUTING.md for users that are helping out with the project to set up the DB.

Suggested solution

Ideally, we should use a migration script manager like sequelize/ prisma to manage these scripts to create and update databases. Since there isn't a lot of scripts (you can have just 1 script for creating both tables) now, this task should be relatively straight forward for anyone who wants to try out adding either of the above packages to manage the Supabase Postgres table.

Contributor guide

Research direction
Research how to set up Prisma migrations for the existing Supabase Postgres tables, then create a migration script that replicates the current table creation logic from CONTRIBUTING.md.
Tech stack
typescriptpostgresqlsql
Domain
backenddatabasedevops
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
GitSQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
75