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

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 statistincs 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.0
Updated 4 months, 3 weeks ago
License: Apache-2.0
Rating: not yet rated

Downloads

80 in the last week

Nodes

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

Keywords

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

Maintainers