← Docs

SvelteKit

SvelteKit's src/lib/server/ directory ensures server-only modules never leak to the client. Gold Lapel fits right in.

Install

npm install @goldlapel/goldlapel

Setup

Create a connection module at src/lib/server/db.js:

import goldlapel from '@goldlapel/goldlapel';
const conn = await goldlapel.start(process.env.DATABASE_URL);
export default conn;

Load Function

Use the connection in a +page.server.js load function:

import conn from '$lib/server/db';

export async function load() {
  const result = await conn.query('SELECT * FROM users');
  return { users: result.rows };
}

API Endpoint

Use the connection in a +server.js endpoint:

import conn from '$lib/server/db';
import { json } from '@sveltejs/kit';

export async function GET() {
  const result = await conn.query('SELECT * FROM users');
  return json(result.rows);
}

ORMs

Using Prisma? See @goldlapel/prisma. Using Drizzle? See @goldlapel/drizzle.

GitHub · npm