Non-blocking streaming with pg-query-stream

[spimou]

I am using a node module to connect to an sql database, but when I do streaming, it gets the Node blocking by design. I cannot do a simple GET while its streaming. Streaming has to end, for new requests to work.

I am thinking about changing to PostgreSQL db and using pg-query-stream to stream.

Before I continue, I have to ask : is pg-query-stream non-blocking while streaming? Also does it give options to pause and resume the stream, in order to process data and not exhaust memory?

Thank you