Datastore PG

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

Actions4

Clear All

AI-generated

Overview

This node acts as a configurable key-value datastore that supports clearing all stored data either in-memory or in a PostgreSQL database. It is useful for scenarios where you need to reset or wipe all stored data in the selected storage backend. For example, clearing all cached data or resetting a datastore before a new batch of data processing.

Use Case Examples

  1. Clearing all stored data in a PostgreSQL database to reset the datastore.
  2. Clearing all in-memory stored data to free up memory during workflow execution.

Properties

Name Meaning
Storage Backend Choose where to store the data, either in-memory (lost on restart) or in a persistent PostgreSQL database.
Output for Set/Clear Define what the node should output after a Set or Clear operation, including options to pass through input data or output status, key, or value information.

Output

JSON

  • success - Indicates if the clearAll operation was successful (true/false)
  • operation - The operation performed, which is 'clearAll' in this case

Dependencies

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

Troubleshooting

  • If the node throws an error about missing credentials, ensure the PostgreSQL credentials are correctly configured when using the PostgreSQL backend.
  • If no data is cleared, verify that the storage backend is correctly selected and accessible.
  • Errors related to key names do not apply to the 'clearAll' operation since it clears all data without requiring keys.

Discussion