{"library":"node-red-contrib-postgresql","type":"library","category":null,"description":"node-red-contrib-postgresql is a Node-RED contribution that provides a node for interacting with PostgreSQL databases. It is currently at version 0.15.4 and has a relatively steady release cadence, primarily focused on bug fixes, dependency updates, and minor enhancements. Key features include robust support for parameterized SQL queries (both numeric $1/$2 and emulated named $id parameters), efficient handling of large datasets through resultset splitting and backpressure (flow control), and flexible dynamic SQL query input via `msg.query`. It provides database responses in `msg.payload`, with additional metadata in `msg.pgsql`. The node integrates directly into the Node-RED flow editor, abstracting away direct `node-postgres` client management for most use cases, though advanced users can dynamically configure client settings via `msg.pgConfig` for specific scenarios.","language":"javascript","status":"active","version":"0.15.4","tags":["javascript","backpressure","node-red-contrib","node-red","nodered","postgres","postgresql","timescale"],"install":[{"cmd":"npm install node-red-contrib-postgresql","imports":["Install 'node-red-contrib-postgresql' via Node-RED palette manager.","// In a preceding Function node:\nmsg.query = 'SELECT * FROM my_table WHERE id = $1';","// In a preceding Function node:\nmsg.params = [msg.payload.id];"]},{"cmd":"yarn add node-red-contrib-postgresql","imports":[]},{"cmd":"pnpm add node-red-contrib-postgresql","imports":[]}],"homepage":null,"github":"https://github.com/alexandrainst/node-red-contrib-postgresql","docs":null,"changelog":null,"pypi":null,"npm":"https://www.npmjs.com/package/node-red-contrib-postgresql","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"18–22","success_rate":0,"avg_install_s":null,"avg_import_s":null,"wheel_type":null},"url":"https://checklist.day/v1/registry/node-red-contrib-postgresql/compatibility"},"provenance":{"verified_status":null,"verified_at":null,"last_verified":"Wed Jun 17","next_check":"Sat Jul 18","install_tag":null}}