tsooq

This project aims to provide a replacement for jOOQ from the java world.

I've always loved to use jOOQ in my java or kotlin projects. This has always been the missing part of the typescript eco system for me.

This library is experimental and in early stages. Don't use this in prodcution.

How do develop

Start the typescript compiler in watch mode

yarn watch

Run tests

docker-compose up -d
yarn test

Correct conversion of float values

Javascript number has some limitations since it's using IEEE 754 standard to encode all numbers

In some use cases you need a different type than number to store floating point values. pg offers a method to manipulate how database types are mapped to an result object

The default behaviour is to convert all floating point values to string.

so if you query something like select avg(salary) from persons you'll get a string as a result. usually that is not the expected behaviour

just use this snippet before connecting to the databse to convert all floating point values to number

import pg from 'pg';

pg.types.setTypeParser(pg.types.builtins.FLOAT4, parseFloat);
pg.types.setTypeParser(pg.types.builtins.FLOAT8, parseFloat);
pg.types.setTypeParser(pg.types.builtins.NUMERIC, parseFloat);