pg-server icon indicating copy to clipboard operation
pg-server copied to clipboard

Using with pg-mem?

Open dforsber opened this issue 4 years ago • 6 comments

Would you mind giving an example on how to create pg-server proxy against pg-mem?

I tried with passing () => newDb().adapters.createPgNative() for createSimpleProxy, but it gives an error when trying to call setNoDelay().

dforsber avatar Jul 19 '21 07:07 dforsber

This is not yet implemented 😑

It requires a refactoring on pg-mem side, which I started, but I did not have the time to finish.

I dont have much time to work on OSS these days, unfortunately. That might change in the future, but I cant tell exactly when this will be supported

oguimbal avatar Jul 19 '21 09:07 oguimbal

Hey @oguimbal, thx for all of your hard work. This is a very wanted feature, please find the time to complete it or at least draft an orderly request for help...

Asaf-S avatar Jul 30 '22 17:07 Asaf-S

Hi @Asaf-S, preliminary work on pg-mem is still ongoing (little by little... I'm dedicating time to OSS when I can, which is not that often).

Any help is always welcome, of course (I'm often receiving PRs on pg-mem and pgsql-ast-parser).

The feature that is needed to make this work is pretty hard to implement, though: It is statement preparation & parameters binding. Long story short: Work is ongoing (parameterized statements parsing & some preliminary work on the executor have been finalized), but it is still requiring a bit of refactoring.

Rest assured that I still have this issue in mind when working on pg-mem (mainly to support connecting Prisma to pg-mem)

oguimbal avatar Aug 27 '22 13:08 oguimbal

has there been any progress on this? I'd absolutely love to use this for testing prisma

Foxious avatar Jan 17 '23 23:01 Foxious

+1

how can I help? How far did you come? Which specific branches would be WIP on this topic for pg-server and pg-mem?

I see https://github.com/oguimbal/pg-mem/issues/360 should be connected.

anyway this is how far I came setting up a stand-alone database server; it doesn't respond ok to a connect command:

https://github.com/rkristelijn/pg-mem-server

rkristelijn avatar Sep 14 '23 07:09 rkristelijn

@oguimbal can we please discuss how to move forward on this issue?

E.g. could you share your work so far in a WIP merge request, so I can see what the solution direction is?

rkristelijn avatar Oct 11 '23 07:10 rkristelijn