This pull request introduces several key changes to integrate Prisma with a PostgreSQL database and configure our inital baseline migration from which all of our data model stems off.
Breakdown of the most important updates:
Database Setup and Configuration:
I added a docker-compose.yml file to set up a PostgreSQL service with the necessary configurations (docker-compose.yml).
I created the initial Prisma schema to define the database models and relationships (prisma/schema.prisma).
Dependency and Script Updates:
I updated package.json to include Prisma dependencies and scripts for database operations (package.json).
Database Migrations:
I added the initial migration SQL file to create the necessary tables and indexes in PostgreSQL (prisma/migrations/20241027013233_baseline_init/migration.sql).
I included a migration lock file to ensure consistent migrations across environments (prisma/migrations/migration_lock.toml).
Prisma Integration:
I integrated Prisma with NextAuth for authentication (src/lib/auth.ts).
I created a Prisma client instance for handling database operations (src/lib/prisma.ts).
This pull request introduces several key changes to integrate Prisma with a PostgreSQL database and configure our inital baseline migration from which all of our data model stems off.
Breakdown of the most important updates:
Database Setup and Configuration:
docker-compose.ymlfile to set up a PostgreSQL service with the necessary configurations (docker-compose.yml).prisma/schema.prisma).Dependency and Script Updates:
package.jsonto include Prisma dependencies and scripts for database operations (package.json).Database Migrations:
prisma/migrations/20241027013233_baseline_init/migration.sql).prisma/migrations/migration_lock.toml).Prisma Integration:
src/lib/auth.ts).src/lib/prisma.ts).