Datastore PG

A configurable key-value datastore with support for in-memory and PostgreSQL storage.

Actions4

Clear

AI-generated

Overview

This node provides a key-value datastore with support for in-memory and PostgreSQL storage backends. The 'Clear' operation allows users to delete a specific key and its associated value from the chosen storage backend. This is useful for managing and cleaning up stored data programmatically within workflows, such as removing outdated or unnecessary entries.

Use Case Examples

  1. Clearing a specific key-value pair from PostgreSQL storage to free up space or remove sensitive data.
  2. Using the in-memory storage backend to clear a key during a workflow execution where persistence is not required.

Properties

Name Meaning
Storage Backend Choose where to store the data, either in-memory (temporary) or PostgreSQL (persistent).
Key Name The unique key for the data to be cleared. Required for the Clear operation.
Output for Set/Clear Defines what the node outputs after a Clear operation.

Output

JSON

  • success - Indicates if the clear operation was successful (true/false).
  • operation - The operation performed, which is 'clear'.
  • key - The key that was cleared.
  • cleared - Boolean indicating if the key was successfully deleted.
  • value - The value that was cleared, included only if 'Output Value' or 'Output Key-Value' is selected and the key existed.

Dependencies

  • Requires a PostgreSQL database credential if PostgreSQL storage backend is selected.

Troubleshooting

  • Error if 'Key Name' is not provided for the Clear operation.
  • Error if invalid storage backend configuration or connection issues with PostgreSQL.
  • If 'continueOnFail' is enabled, errors for individual items will be captured in the output instead of stopping execution.

Discussion