I built the first version of this stuff a decade ago as ethanolus (c2h5oh). And I've used it for most of my projects as a backend layer since then.

The main motive is to eliminate unnecessary complexity from backend layers.

How it works: a rust nginx module calls postgresql functions via non-blocking libpq io. There is an optional patch for libpq. It provides zero-copy for nginx-chained memory buffers - to avoid request body copies between nginx and libpq.

Pgxio supports http2 and websockets. Realtime listen/notify updates from postgres without polling.

How to try - code on github. Tested on Debian - FreeBSD validation in progress.

It's alpha - so any feedback is welcome.