Does PGlite work with pg-promise and node-postgres?

[joswarmer]

Hi,

I am using the pg-promise library, which is based on the node-progresslibrary in the lionweb-server.

For testing purposes, and for easier deployment I am interested in using PGLite as well.

Doe libraries like pg-promise and node-postgres work with pglite? Ot do I need to use the pglite specific API?

[slaskis]

i have only used this for tests so not sure about running it in a production environment but i made this adapter package to be able to use pglite where node-postgres is used:

https://www.npmjs.com/package/@middle-management/pglite-pg-adapter

[joswarmer]

Nice!. Not sure I can use this easily, as pg-promise uses node-progress internally, I can't change this. It miught work if I create my own fork of pg-promise, but I hesitate doing this.

[tdrz]

Doe libraries like pg-promise and node-postgres work with pglite? Ot do I need to use the pglite specific API?

Have a look at the pglite-socket docs.

You can also use it through an ORM like Prisma. See docs.

[joswarmer]

I understand that I can use pglite as a database process this way and access it through the network. In the client I can then use any postgres library I want. I prefer to embed pglite inside the client, having only one process instead of two. Maybe this can still be done in one process bur go through the network calling pglite ending up in the same process?