Post Overview

  • Further improvements to the IoT Hub to TimescaleDB Azure Function

    Further improvements to the IoT Hub to TimescaleDB Azure Function

    In the post Improving an Azure Function that writes IoT Hub data to TimescaleDB, we added some improvements to an Azure Function that uses the Event Hub trigger to write messages from IoT Hub to TimescaleDB: use of the Event Hub enqueuedTime timestamp instead of NOW() in the INSERT statement (yes, I know, using NOW() did… Read more

  • Revisiting Rancher

    Revisiting Rancher

    Several years ago, when we started our first adventures in the wonderful world of IoT, we created an application for visualizing real-time streams of sensor data. The sensor data came from custom-built devices that used 2G for connectivity. IoT networks and protocols such as SigFox, NB-IoT or Lora were not mainstream at that time. We… Read more

  • Improving an Azure Function that writes IoT Hub data to TimescaleDB

    Improving an Azure Function that writes IoT Hub data to TimescaleDB

    In an earlier post, I used an Azure Function to write data from IoT Hub to a TimescaleDB hypertable on PostgreSQL. Although that function works for demo purposes, there are several issues. Two of those issues will be addressed in this post: the INSERT INTO statement used the NOW() function instead of the enqueuedTimeUtc field;… Read more

  • Dashboard your TimescaleDB data with Grafana

    Dashboard your TimescaleDB data with Grafana

    In an earlier post, I looked at storing time-series data with TimescaleDB on Azure Database for PostgreSQL. To visualize your data, there are many options as listed here. Because TimescaleDB is built on PostgreSQL, you can use any tool that supports PostgreSQL such as Power BI or Tableau. Grafana is a bit of a special… Read more

  • Multi-Tier Bitnami Grafana Stack on Azure

    Multi-Tier Bitnami Grafana Stack on Azure

    After seeing some tweets about Bitnami’s multi-tier Grafana Stack, I decided to give it a go. On the page describing the Grafana stack, there are several deployment offerings: I decided to use the multi-tier deployment, which deploys multiple Grafana nodes and a shared Azure Database for MariaDB. On Azure, the Grafana stack is deployed via… Read more

  • Azure Functions with Consumption Plan on Linux

    Azure Functions with Consumption Plan on Linux

    In a previous post, I talked about saving time-series data to TimescaleDB, which is an extension on top of PostgreSQL. The post used an Azure Function with an Event Hub trigger to save the data in TimescaleDB with a regular INSERT INTO statement. The Function App used the Windows runtime which gave me networking errors… Read more