Unify the adapter syntax.

[jy-joung-bitor]

Question

Please see this document. In first access, I saw this command for Postgresql:

const adapter = new PrismaPg({ connectionString: process.env.DATABASE_URL })

I thought the Mariadb code do the same thing, but connectionString is not defined in PrismaMariaDb configuration. There's a Mariadb code but too verbose:

const adapter = new PrismaMariaDb({
  host: "localhost",
  port: 3306,
  connectionLimit: 5
});

// It can reduce like this:
const adapter = new PrismaMariaDb(process.env.DATABASE_URL);

What is worse, there's a MSSQL Code like this:

import { PrismaMSSQL } from '@prisma/adapter-mssql';
import { PrismaClient } from './generated/prisma';

const sqlConfig = {
  user: process.env.DB_USER,
  password: process.env.DB_PASSWORD,
  database: process.env.DB_NAME,
  server: process.env.HOST,
  pool: {
    max: 10,
    min: 0,
    idleTimeoutMillis: 30000
  },
  options: {
    encrypt: true, // for azure
    trustServerCertificate: false // change to true for local dev / self-signed certs
  }
}

const adapter = new PrismaMSSQL(sqlConfig)
const prisma = new PrismaClient({ adapter });

It is too verbose! So I wish unifying all of adapters by one of the two options:

1. new Prisma*(process.env.DATABASE_URL)
2. new Prisma*({ url: process.env.DATABASE_URL })

Can I wish?

How to reproduce (optional)

Expected behavior (optional)

No response

Information about Prisma Schema, Client Queries and Environment (optional)

// Add your schema.prisma

// Add any relevant Prisma Client queries here

• OS:

• Database:

• Node.js version:

• Run prisma -v to see your Prisma version and paste it

[nurul3101]

Thank you for the suggestion. We will check this with the team to see if this is possible.

[github-actions[bot]]

Hi,

As we have not heard back from you, we are closing this discussion to keep our discussions organized.

Feel free to start a new discussion if this remains relevant.

Thank you for being part of the community!