I am the creator and the main maintainer of
Slonik, the PostgreSQL client for Node.js, and I've implemented it across a wide range of projects. I talk a lot about the best practices in my writings, however, if your case isn't covered or you have special requirements, I am keen to help devise the plan of action.