P

Prisma•2w ago•

12 replies

mdnts

Prisma ORM with TURSO not working

ORM✅Solved

Hey guys, i need your help.

I did a backend app with Nest.js, Prisma ORM and Turso but production Prisma tell has an error with URL, someone did get this problem before?

pnpx prisma db push
Loaded Prisma config from prisma.config.ts.

Prisma schema loaded from prisma\schema.prisma.
Datasource "db": SQLite database

Error: P1013: The provided database string is invalid. The scheme is not recognized in database URL. Please refer to the documentation in https://pris.ly/d/config-url for constructing a correct connection string. In some cases, certain characters must be escaped. Please check the string for any illegal characters.

import { Injectable, OnModuleDestroy, OnModuleInit } from "@nestjs/common";
import { PrismaClient } from "../../generated/prisma/client.js";
import { PrismaLibSql } from "@prisma/adapter-libsql";

@Injectable()
export class PrismaService
extends PrismaClient
implements OnModuleDestroy, OnModuleInit
{
constructor() {
const adapter = new PrismaLibSql(
{
url: process.env.TURSO_DATABASE_URL as string,
authToken: process.env.TURSO_AUTH_TOKEN as string
}
);
super({ adapter });
}
async onModuleInit() {
await this.$connect();
}
async onModuleDestroy() {
await this.$disconnect();
}
}

Reference documentation for the prisma config file

This page gives an overview of all Prisma config options available for use.