pg-ts

Typescript wrapper around node-postgres

Installing

``
yarn add pg-ts
`

Using

Using promises:

`ts
import getPool, { SQL } from "pg-ts";

const pool = getPool();
const { firstName, lastName } = person;

pool.transaction(tx =>
Promise
.all([
tx.none(SQLINSERT INTO people (first_name, last_name) VALUES (${firstName}, ${lastName}))),
tx.one(SQLSELECT * FROM people WHERE first_name = ${firstName})),
])
.then(([,person]) => person));
`

Using fp-ts Tasks:

`ts
import getPool, { SQL } from "pg-ts";

const pool = getPool();

pool.oneTask(SQLSELECT * FROM people WHERE first_name = ${firstName})).run();
``