What is the proper way to use the node.js postgresql module?

• PostgreSQL

  57 11,891 8.0 JavaScript

  PostgreSQL client for node.js.

I am writing a node.js app on Heroku and using the pg module. I can't figure out the "right" way to get a client object for each request that I need to query the database.

• node_chat

  1 10 10.0 JavaScript

  A fork of @ry's node_chat sample to add message persistence (via postgres) and heartbeat messages

pg.connect(conString, function(err, client) { // Use the client to do things here}); But surely you don't need to call pg.connect inside every function that uses the database right? I've seen other code that does this:

• SurveyJS

  surveyjs.io sponsored

  Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

  

Suggest a related project