{"library":"node-pg-helper","type":"library","category":null,"description":"A small wrapper around node-postgres providing simplified CRUD helper functions (insert, update, upsert, selectAllRows) for PostgreSQL. Version 1.0.5, released once, no active development observed on GitHub. It relies on the 'pg' Pool client, which must be configured and set via setClient(). Avoids raw SQL for basic operations but offers no query builder flexibility, migrations, or connection pooling of its own. Suitable for quick prototypes but not production-grade; alternatives like Knex, Slonik, or pg-promise are more feature-rich and maintained.","language":"javascript","status":"maintenance","version":"1.0.5","tags":["javascript","nodejs","postgres"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install node-pg-helper","imports":["const db = require('node-pg-helper');","db.setClient(pool);","await db.insert('users', { id: 100, firstname: 'john' });","await db.upsert('users', { id: 100, firstname: 'john' }, 'id');","await db.update('users', { lastname: 'snow' }, { id: 100 });"]},{"cmd":"yarn add node-pg-helper","imports":[]},{"cmd":"pnpm add node-pg-helper","imports":[]}],"homepage":"https://github.com/wherrera/node-pg-helper#readme","github":"https://github.com/wherrera/node-pg-helper","docs":null,"changelog":null,"pypi":null,"npm":"node-pg-helper","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}