search

lyqht / Octokit-lite

🐙 Web UI to perform GitHub operations on multiple repositories
https://octokit-lite.vercel.app
MIT License
14 stars 12 forks source link

Create SQL migration scripts #24

Open lyqht opened 2 years ago

lyqht commented 2 years ago

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.

chinmaym07 commented 2 years ago

Hey @lyqht Can I do this ?

lyqht commented 2 years ago

Hi @chinmaym07 , before assigning you the issue, may I ask what's your plan to work on the issue? Are u gonna do what is suggested or would u be proposing an alternative flow?

lyqht commented 2 years ago

This issue is still available!