CrateDB is a hyper-fast opensource distributed database technology that combines the best out of the SQL and NoSQL worlds. It supports the PostgreSQL wire protocol for easy integration with many data engineering tools.
Node-RED is a programming tool for wiring together hardware devices, APIs and online services in new and interesting ways. It allows orchestrating message flows and transformations through an intuitive web interface.
The combination of CrateDB and Node-RED serve an important purpose. In certain database operations, there is a need to run the same queries repeatedly. This can lead to the need of a scheduling mechanism to automate the process. Solutions like Node-RED that serve this purpose perfectly. With CrateDB it also enables the user to read messages from an MQTT broker and seamlessly insert them into CrateDB and build scalable applications.