Prisma/Slonik Usage Example

prisma-slonik-usage.ts

import { PrismaClient } from '@prisma/client';
import type { User } from '@prisma/client';
import { createPool, sql } from 'slonik';

export const buildBaseConnectionURL = (config) => {
  return (
    'postgresql://' +
    config.DB_USER +
    ':' +
    config.DB_PASS +
    '@' +
    config.DB_HOST +
    ':' +
    config.DB_PORT +
    '/' +
    config.DB_NAME
  );
};

export const buildPrismaDatabaseURL = (config) => {
  return buildBaseConnectionURL(config) + '?schema=' + config.DB_SCHEMA;
};

export const buildSlonikConnectionURL = (config) => {
  return buildBaseConnectionURL(config) + '?options=-csearch_path=%3d' + config.DB_SCHEMA;
}

// Prisma Client
const prisma = new PrismaClient({
  datasources: { db: { url: buildPrismaDatabaseURL(config) } },
});

// Slonik Client
const db = createPool(buildSlonikConnectionURL(config));

// Example Prisma query:
const users = await prisma.user.findMany();

// Example Slonik query:
const users = await db.any<User>(sql`SELECT * FROM "User"`);