nodejs-postgresql-azure VS pg-promise

{ "name": "crud-nodejs-psql", "version": "1.0.0", "description": "Aplicação CRUD com Node.js & PostgreSQL", "main": "server.js", "scripts": { "dev": "nodemon", "lint": "eslint --ext .js,.html -f ./node_modules/eslint-friendly-formatter . --fix", "prepush": "npm run lint", "start": "node server.js" }, "keywords": [ "node.js", "javascript", "postgresel", "azure", "serverless", "azure-functions", "azure-devops", "azure-storage", "github-actions", "app-service", "express" ], "author": "Glaucia Lemos", "license": "MIT", "bugs": { "url": "https://github.com/glaucia86/nodejs-postgresql-azure/issues" }, "homepage": "https://github.com/glaucia86/nodejs-postgresql-azure#readme", "devDependencies": { "eslint": "^6.8.0", "eslint-config-airbnb-base": "^14.0.0", "eslint-plugin-import": "^2.20.1", "husky": "^4.2.3", "nodemon": "^2.0.2" }, "dependencies": { "cors": "^2.8.5", "dotenv": "^8.2.0", "eslint-friendly-formatter": "^4.0.1", "eslint-plugin-html": "^6.0.0", "express": "^4.17.1", "express-promise-router": "^3.0.3", "pg": "^7.18.2" } }

Personally with more time I would also use JavaScript so I can improve it. Last time I wrote something with Express and a database connection is a long time ago and not for work, only for my personal testing. But for JavaScript database connection to PostgreSQL I recommend pg-promise. That works like a charm.

I've always loved this project / product:

https://github.com/outline/outline

I think the guy who built it posts here. There's also pg-promise, a "Postgres interface for Node.js":

https://github.com/vitaly-t/pg-promise

Raw pgPromise with string templating.

i do have a couple of them like websocket server using ws, bullmq for sending emails and postgres listen/notify to push data to websocket clients. Would you happen to have any ideas on how to go about these? I did some research

Yes. You can also take at the pg-promise library. https://github.com/vitaly-t/pg-promise

Is there any difference to the named parameters already supported? https://github.com/vitaly-t/pg-promise#named-parameters

During my years as a dev i have really started to dislike ORMs. They always fail in the end. SQL is universal, and transfers between languages and tech fields. This is why im pro-sql, and always try to avoid unnecessary abstractions.

I have actually went back to writing pure SQL in files, and using those as params for whatever db engine i use, this makes it even possible to reuse the code in other projects (even its unlikely that you can use the exact same query, but just as a "it would work" in theory).

For node based projects i have used and would probably still choose pg-promise (https://github.com/vitaly-t/pg-promise).

Since I'm decent at writing SQL queries and I don't want to learn additional syntax to work with ORMs/query builders, I stay as close as possible to the database driver. pg-promise is an excellent library built on top of the Node.js driver for PostgreSQL. It's built with promises in mind, it's well-tested and typed.

dont believe me? look at how many open issues they have https://github.com/vitaly-t/pg-promise/issues

I just used pg-promise - it handles the connections for you, up to you to write the SQL.