From 864ce67d89c77d8ef9c3361f80d619853abcf91c Mon Sep 17 00:00:00 2001 From: Pinapelz Date: Sun, 29 Jun 2025 11:41:51 -0700 Subject: backend: migrate to postgres --- backend/.env.example | 3 +-- backend/dev.db | Bin 28672 -> 0 bytes backend/schema.prisma | 2 +- backend/src/index.ts | 2 +- 4 files changed, 3 insertions(+), 4 deletions(-) delete mode 100644 backend/dev.db diff --git a/backend/.env.example b/backend/.env.example index f3d872f..f570912 100644 --- a/backend/.env.example +++ b/backend/.env.example @@ -1,5 +1,4 @@ -DATABASE_URL="file:./dev.db" +DATABASE_URL="postgresql://postgres@localhost:5432/mirage" SESSION_SECRET="your-very-secure-secret-key-change-this-in-production-make-it-long-and-random" PORT=5000 NODE_ENV=development -FRONTEND_URL="http://localhost:3000" diff --git a/backend/dev.db b/backend/dev.db deleted file mode 100644 index 7bda866..0000000 Binary files a/backend/dev.db and /dev/null differ diff --git a/backend/schema.prisma b/backend/schema.prisma index 3872cc4..e5c4039 100644 --- a/backend/schema.prisma +++ b/backend/schema.prisma @@ -3,7 +3,7 @@ generator client { } datasource db { - provider = "sqlite" + provider = "postgresql" url = env("DATABASE_URL") } diff --git a/backend/src/index.ts b/backend/src/index.ts index 52a7a33..37b64a8 100644 --- a/backend/src/index.ts +++ b/backend/src/index.ts @@ -11,7 +11,7 @@ const port = 5000; app.use(cors({ origin: [ - 'http://localhost:5173', // Vite dev server default port + process.env.FRONTEND_URL || "http://localhost:5173" ], credentials: true })); -- cgit v1.2.3