{"library":"pg-cli","type":"library","category":null,"description":"pg-cli is a small library wrapping node-pg (pg) to provide a more user-friendly PostgreSQL client for Node.js. It offers callback, thunk, and promise API styles, supports multiple database connection pools, and enables single- and multi-database transactions. Version 2.0.1 is stable, with a release cadence of approximately one year. It differentiates from raw pg by providing simplified CRUD operations like select, insert, update, updateBatch, and JSONB support, reducing boilerplate for common PostgreSQL tasks.","language":"javascript","status":"active","version":"2.0.1","tags":["javascript","postgres","client","cli","postgres client","pg client","pg cli","pg-cli"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install pg-cli","imports":["const pgHelper = require('pg-cli');","const { jsonbSet } = require('pg-cli');","pgHelper.initPool(pgConf);","pgHelper.query('SELECT * FROM users WHERE id=$1', [1], (err, res) => {});","pgHelper.select('users', ['name','age'], {name:'admin'}, callback);"]},{"cmd":"yarn add pg-cli","imports":[]},{"cmd":"pnpm add pg-cli","imports":[]}],"homepage":"https://github.com/fantasticsoul/pg-cli#readme","github":"https://github.com/fantasticsoul/pg-cli","docs":null,"changelog":null,"pypi":null,"npm":"pg-cli","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}