Prisma Examples

The project is organized as follows:

• src/index.ts: Defines the Hono server and all REST routes (/signup, /post, /feed, etc.).
• src/lib/prisma.ts: Contains lightweight middleware that initializes a Prisma Client using @prisma/adapter-pg and exposes it through Hono's context.
• prisma/schema.prisma: The Prisma schema defining the User and Post models.
• prisma/seed.ts: Script used to seed the database with sample users and posts.

The Prisma with Turso example consists of the following key files:

• prisma/schema.prisma: Defines the database schema for Users and Posts.
• src/script.ts: A Node.js script demonstrating CRUD operations using Prisma Client.
• .env: Stores environment variables (TURSO_DATABASE_URL and TURSO_AUTH_TOKEN) for database credentials.

The project is organized as follows:

• prisma/schema.prisma: Contains the database schema and Prisma configuration, including the prisma-client generator settings.
• generated/: The custom output location for the generated Prisma Client.
• db.ts: Handles the database connection using Prisma Postgres.
• index.ts: The main server file using Bun's built-in HTTP server.
• package.json: Project dependencies and scripts.
• .env.example: Template for required environment variables.

Prisma Compute examples demonstrate how to deploy Prisma ORM applications to Prisma Compute using the latest @prisma/cli. The available examples include:

• Hono: A Hono API running on Node.js.
• Next.js: A Next.js App Router application configured with standalone output for Prisma Compute compatibility.
• TanStack Start: A TanStack Start application using the Nitro Vite plugin output supported by Prisma Compute.

Each example provides a complete setup including Prisma ORM, a PostgreSQL schema, seed data, and scripts for both local development and deployment to Prisma Compute.

When using TypedSQL, the project structure includes a specific directory for your queries:

• prisma/sql/: Contains .sql query files. These files are type-checked by Prisma and included in the generated Prisma Client.
• prisma/schema.prisma: Defines the database schema.
• prisma/seed.ts: Contains logic for populating the database.
• src/index.ts: Demonstrates how to execute the generated SQL queries via the Prisma Client.

This example demonstrates how to connect Prisma to a CockroachDB database, create schemas using raw SQL, populate the Prisma schema using prisma db pull, and perform CRUD operations with Prisma Client.

Important Note: CockroachDB support is currently in Preview, and Prisma Migrate is not supported. You must create the database schema using raw SQL and then use prisma db pull to sync your Prisma schema.

Once your .env file is configured with your database URL, Clerk keys, and Clerk webhook signing secret, start the development server using:

npm run dev

The application will be available at http://localhost:3000.

To add new features (like a Profile model) to your application, follow these steps:

1. Update the Prisma Schema: Add the new model to prisma/schema.prisma.

   model Profile {
     id     Int     @id @default(autoincrement())
     bio    String?
     user   User    @relation(fields: [userId], references: [id])
     userId Int     @unique
   }

2. Run a Migration: Execute the following command to create the new table in your database:

   npx prisma migrate dev --name add-profile

3. Update Application Code: Use the newly generated types and the PrismaClient to interact with the new model in your controllers or services.

Access specialized backend-only implementations of Prisma ORM. These examples focus on server-side logic, API construction, and database interaction without a frontend layer.

Key Categories:

• GraphQL Servers: Implementations using Apollo Server, GraphQL Yoga, Nexus, TypeGraphQL, Pothos, and Mercurius. Covers patterns like SDL-first, code-first, subscriptions, and CRUD APIs.
• REST APIs: Implementations using Express, Fastify, Koa, Hapi, and NestJS.
• Specialized Protocols & Tools: gRPC APIs, PostGIS spatial queries with Express, and integration testing with Jest and Supertest.
• Scripts: Direct usage of Prisma Client JS in TypeScript scripts.

If you prefer not to use Docker, you can run the application using Node.js and a local PostgreSQL instance.

1. Create a .env file and set the DATABASE_URL to your local database connection string.
2. Install dependencies and generate the Prisma Client.
3. Apply migrations using npx prisma migrate dev.
4. Start the development server with npm run dev.

# 1. Setup environment
cp .env.example .env
# edit .env and set DATABASE_URL, e.g.:
# DATABASE_URL="postgresql://prisma:prisma@localhost:5432/prisma"

# 2. Install and migrate
npm install
npx prisma migrate dev

# 3. Start server
npm run dev