Database

In MVPinMinutes, we use the Neon postgres database to store the data. And we use the Drizzle ORM to interact with the database.

Set up the Neon

Head to the Neon Dashboard and create a new project. In there, you can find the Connection String

Set up the Supabase in the application

Copy that Connection String and paste it in the .env.local file.

DATABASE_URL=

Add the changes to the database

To add the changes to the database, you need to run the following command:

npm run push

This will create a new migration file and apply it to the database.

Run the migrations (not needed)

To run the migrations, you need to run the following command:

npm run migrate

All the shemas can be found in the utils/database/schema.ts file.

Video Tutorial

Coming soon...