@digitaloak/node-red-contrib-digitaloak-postgresql 0.3.2

Three Node-RED PostgreSQL nodes: connection manager, query and listen node. Support for simple and parameterized queries and transactions, async messaging, TLS connections, pool realtime usage statistics and custom type parsers.

npm install @digitaloak/node-red-contrib-digitaloak-postgresql

Node-RED PostgreSQL nodes:

  • query, for querying database
  • listen, for listening messages on specific channel
  • connection-manager, for database connections configuration

Features

  • pool realtime usage statistics
  • TLS support (using built in tls-config node)
  • async messaging
  • parameterized queries
  • custom type parsers
  • transactions
  • parameterized transactions

TODO

Install

Install using "Manage palette" or run the following command in your Node-RED user directory (in docker it's /usr/src/node-red):

npm install @digitaloak/node-red-contrib-digitaloak-postgresql

Additional info

  • The listen node works with its own client, independently of the query node pool

Usage

Import example data for test drive and use help tab for detailed information about each node.

Introduction

Transactions usage:

Transactions introduction

Node Info

Version: 0.3.2
Updated 3 years, 8 months ago
License: Apache-2.0
Rating: not yet rated
View on npm

Actions

Rate:

Downloads

226 in the last week

Nodes

  • digitaloak-postgresql-connection-manager
  • digitaloak-postgresql-query
  • digitaloak-postgresql-listen

Keywords

  • node-red
  • postgres
  • postgresql
  • listener
  • notifier

Maintainers