pg module

[RekGRpth]

Why not use pg module in TFB?

[billywhizz]

Hi and welcome. I did indeed implement a wrapper around libpg here: https://github.com/just-js/modules/tree/master/pg but i could not get perf with it to be as good as i thought it should be. believe it or not the js version runs faster, especially for the multi query and multi update benchmarks. i think this is something to do with blocking reads or writes in libpg but i need to revisit it.

This should also come with a big caveat that it is alpha level code and likely has lots of bugs and cases it is not handling correctly. The goal for the moment for me is to establish a performance baseline and add features and functionality from there.

I am hoping to write up a a few articles on this over coming weeks. You can keep an eye on the main repo here: https://github.com/just-js and my currently empty blog here: https://billywhizz.io/.

[RekGRpth]

js version runs faster

Yes, I think so too!
There are 2 async libraries in python for postgres: one's libpq-wrapper and another uses raw connection, and second library works much faster!

[billywhizz]

you can see how well it does on the multi/pipeline tests here: https://www.techempower.com/benchmarks/#section=test&runid=3e069eac-3b1d-4f77-bb06-2bceb4172dea&hw=ph&test=query&a=2 and here https://www.techempower.com/benchmarks/#section=test&runid=3e069eac-3b1d-4f77-bb06-2bceb4172dea&hw=ph&test=update&a=2