In order to run the project we need the following software binaries installed on our development machines:
node>=16.7.0
npm>=8.0.0
docker>=20.10.12
supabase>=0.18.0
First thing we have to do for local development is start the studio locally at localhost:54321:
npm run db:start
If we are adding a new table structure, first do it visually in the Supabase Studio and test locally.
Check the migration difference with the following command:
npm run db:changes
If everything is fine we can run the following command to apply the changes to the database:
npm run db:commit add_table_name
Simplest way to test the migrations are working is to reset the local database:
npm run db:reset
If everything is fine we can push the changes to the remote database:
npm run db:push
Click the image to see the schema diagram full documentation.
We encourage you to contribute to Open Sauced! Please check out the Contributing guide for guidelines about how to proceed.
Got Questions? Join the conversation in our Discord.
Find Open Sauced videos and release overviews on our YouTube Channel.
MIT © Open Sauced