prisma/qa-query-compiler-turso

Example usage of the `queryCompiler` preview feature. Manual quality assurance on Stackblitz for Prisma v6.9.0

Prisma QA Query Compiler Turso

This project demonstrates the use of Prisma with the Query Compiler and Driver Adapters preview features. It connects to a Turso database using the @prisma/adapter-libsql adapter.

Prerequisites

• Node.js (>= 18.x)
• pnpm (>= 8.x)
• Turso database (you can sign up at Turso)

Setup

1. Clone the repository:

git clone https://github.com/prisma/qa-query-compiler-turso.git
cd qa-query-compiler-turso

2. Install dependencies:

pnpm install

3. Generate Prisma Client:

pnpm prisma generate

4. Set up environment variables: Create a .env file in the root of the project with the following variables:

DATABASE_URL="your_turso_database_url"
DATABASE_AUTH_TOKEN="your_turso_auth_token"

Replace your_turso_database_url and your_turso_auth_token with your actual Turso database URL and authentication token.

Prisma Setup Description

• Schema: The Prisma schema is located at prisma/schema.prisma.
• Preview Features: This project uses the queryCompiler and driverAdapters preview features.

// prisma/schema.prisma
generator client {
  provider        = "prisma-client"
  output          = "../.generated/prisma"
  previewFeatures = ["queryCompiler", "driverAdapters"]
}

• Adapter: The project uses @prisma/adapter-libsql to connect to Turso. The adapter is configured in src/adapter.ts and integrated via prisma.config.ts for migrations and src/index.ts for the client.

Running the Project

• Development: To run the application (e.g., to execute queries defined in src/index.ts):

pnpm dev

Building the Project

• To compile the TypeScript source code:

pnpm build

Key Files

• prisma/schema.prisma: Defines the database schema and Prisma Client generator configuration.
• prisma.config.ts: Configures Prisma for features like migrations when using driver adapters.
• src/index.ts: The main entry point of the application, demonstrating Prisma Client usage.
• src/adapter.ts: Contains the setup for the LibSQL (Turso) adapter.
• src/env.ts: Defines the TypeScript types for environment variables.
• .env: Stores environment variables (DATABASE_URL, DATABASE_AUTH_TOKEN). Note: This file should be in .gitignore and not committed to version control.
• package.json: Lists project dependencies and scripts.