database

Database — SQLite + Prisma

This command is part of the VibeHarness framework. Node.js/TypeScript projects only. For Python projects, use SQLite + SQLAlchemy. Record schema design decisions in docs/ai-dev/. Verify stack matches PROJECT_RULES.md.

File-based DB that works without any installation, signup, or server setup.

Why SQLite + Prisma

• SQLite: A single file (dev.db) is the entire database. Nothing to install
• Prisma: Write schemas like markdown, auto-generate type-safe queries
• No external service signup or server needed
• npm install once and done

Initial Setup

npm install prisma @prisma/client
npx prisma init --datasource-provider sqlite

This creates prisma/schema.prisma.

Schema Example

prisma/schema.prisma:

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

datasource db {
  provider = "sqlite"
  url      = "file:./dev.db"
}

model User {
  id        String   @id @default(cuid())
  email     String   @unique
  name      String?
  password  String
  posts     Post[]
  createdAt DateTime @default(now())
}

model Post {
  id        String   @id @default(cuid())
  title     String
  content   String?
  author    User     @relation(fields: [authorId], references: [id])
  authorId  String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

After schema changes:

npx prisma db push

Prisma Client

// src/lib/db.ts
import { PrismaClient } from '@prisma/client'

const globalForPrisma = globalThis as unknown as { prisma: PrismaClient }

export const db = globalForPrisma.prisma || new PrismaClient()

if (process.env.NODE_ENV !== 'production') globalForPrisma.prisma = db

CRUD Patterns

import { db } from '@/lib/db'

// Create
const user = await db.user.create({
  data: { email: '[email protected]', name: 'John', password: hashedPassword }
})

// Read (all)
const posts = await db.post.findMany({
  include: { author: true },
  orderBy: { createdAt: 'desc' }
})

// Read (single)
const post = await db.post.findUnique({
  where: { id: postId },
  include: { author: true }
})

// Update
const updated = await db.post.update({
  where: { id: postId },
  data: { title: 'Updated title' }
})

// Delete
await db.post.delete({ where: { id: postId } })

// Search
const results = await db.post.findMany({
  where: { title: { contains: 'keyword' } }
})

// Pagination
const posts = await db.post.findMany({
  skip: 0,
  take: 10,
  orderBy: { createdAt: 'desc' }
})