{"library":"pg-essential","type":"library","category":null,"description":"Lightweight Node.js library on top of pg-spice that patches pg.Client with helper methods: fetchOne, fetchAll, execute, executeBulkInsertion, and executeTransaction. Version 1.0.2 is stable with no recent updates. It does not manage connection pooling, leaving that to the developer. Differentiators: bulk insertion and transaction handling without SQL injection via pg-promise internals.","language":"javascript","status":"active","version":"1.0.2","tags":["javascript","pg-essential","pg","pg-spice","postgres","bulk insert","bulk-insert","postgres node","postgres transaction"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install pg-essential","imports":["const { patch } = require('pg-essential'); patch(pg);","const client = new pg.Client(); // then patch first\nconst row = await client.fetchOne('SELECT * FROM users WHERE id=$1', [1]);","await client.executeBulkInsertion([{id:1,name:'a'}], ['id','name'], 'users');"]},{"cmd":"yarn add pg-essential","imports":[]},{"cmd":"pnpm add pg-essential","imports":[]}],"homepage":"https://github.com/ZiaDev/Pg-essential-dev#readme","github":"https://github.com/ZiaDev/Pg-essential-dev","docs":null,"changelog":null,"pypi":null,"npm":"pg-essential","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}