prisma-database-setup

### Prisma ORM Setup Guide for PostgreSQL

**1. Initialize Prisma in Your Project**
Run the following command in your terminal to install Prisma and its CLI:
```bash
npm install prisma @prisma/client --save-dev
```

**2. Initialize Prisma Schema**
Generate the Prisma schema file:
```bash
npx prisma init
```

**3. Configure `schema.prisma`**
Edit the generated `prisma/schema.prisma` file to include your PostgreSQL connection and schema:
```prisma
// schema.prisma
datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

model User {
  id    Int     @id @default(autoincrement())
  name  String
  email String  @unique
}
```

**4. Set Up `.env` File**
Create a `.env` file in your project root and add your PostgreSQL connection string:
```env
DATABASE_URL="postgresql://postgres:password@localhost:5432/mydb?schema=public"
```

**5. Apply the Database Migration**
Run the migration to sync your schema with the database:
```bash
npx prisma migrate dev --name init
```

**6. Test the Connection**
Verify the setup by creating a simple test script in `index.js`:
```javascript
const { PrismaClient } = require('@prisma/client');
const prisma = new PrismaClient();

async function main() {
  const users = await prisma.user.findMany();
  console.log(users);
}
main()
  .catch(e => {
    throw e;
  })
  .finally(async () => {
    await prisma.$disconnect();
  });
```
Run it with:
```bash
node index.js
```

**Troubleshooting Tips:**
- Ensure your database server is running and accessible.
- Verify the `DATABASE_URL` in `.env` is correct.
- Check Prisma logs for errors during migration.