One of the primary goals for NuvIoT is to support a wide variety of different platforms, tools, and data stores. Today, we are officially announcing preview support for creating data streams with a PostgreSQL database.
Data streams are usable for inbound and outbound messages, information, and data. An example of an outbound message is one that is processed from within NuvIoT and delivered to PostgreSQL. An example of an inbound/input message is one that sources data from PostgreSQL for use within your workflows.
One of the more interesting facets of PostgreSQL adding is that we also add support for TimeScale.
TimescaleDB is an open-source time-series database optimized for fast ingest and complex queries. It speaks “full SQL” and is as easy to use as a traditional relational database. Yet, it scales in ways previously reserved for NoSQL databases. Compared to the trade-offs demanded by these two alternatives (relational vs. NoSQL), TimescaleDB offers the best of both worlds for time-series data.
For our on-premises solution, using TimeScale will open a whole new set of doors on the ability to do Time Series Analysis on raw sensor data. Contact Us to find out how you can quickly build a proof of concept to capture data and do time-series analyses on it for anomaly detection.