klart

Klart

About

Klart is a wrapper around node-postgres. It provides a simple interface to make queries towards a PostgreSQL database. Feel free to reach out with any suggestions on how it could be expanded!

Development Setup

The best way to get a working dev environment is to run use docker compose.

command	purpose
docker-comopse up -d	start environment
yarn ssh	enter the dev environment
docker-compose down	tear the development environment down

Installation

yarn add klart

How to use

All examples use a common Dog-type, looking like this:

type Dog = { name: string; age: number };

Get the first row

import { first } from 'klart';

const fluffy = await first<Dog>('SELECT * FROM dogs WHERE name = $1', ['fluffy']);
console.log(`Retrieved a dog called ${fluffy.name} aged ${fluffy.age}`);

Get all rows

import { rows } from 'klart';

const dogs = await rows<Dog>('SELECT * FROM dogs');
dogs.forEach((dog) => {
  console.log(`Retrieved a dog called ${dog.name} aged ${dog.age}`);
});

Just execute a query

import { run } from 'klart';

//NOTE: no result returned when using `run`
await run('INSERT INTO dogs (name, age) VALUES($1, $2)', ['Fido', 5]);

Configuration

Klart, like node-postgres, picks up the same environment variables as lipq. If you want to ovverride this, you can import withConfiguration from Klart and use that instead (see example below). As Klart really just hands of configuration to node-postgres, details on this page is the best source of information for configuration.

import { withConfiguration } from 'klart';
const { first, rows } = withConfiguration({
  user: 'dbuser',
  host: 'database.server.com',
  database: 'mydb',
  password: 'secretpassword',
  port: 3211,
});