In this tutorial we will look at how you retrieve and display data from a node-red database. The tutorial uses data I collect for monitoring several of my websites. The data consists of a timestamp site name page load speed We have a web form that lets us select a website a time range and a page speed range and is shown below: The results are displayed in a table. The flow is shown below: Besides the dashboard nodes there are two function nodes. The store data node builds the database query based on the user selection and the convert time function converts the timestamp from a millisecond time to a human readable time before displaying it. Notes about the store data node: Stores data in a context variable called data until you click submit The time is stored in milliseconds and the select time drop downs use milliseconds The results are limited to 100 results and ordered by timestamp in descending order. The query is shown below: Data from the SQL node is passed to the convert time function which changes the time to a more user friendly form before sending it to the display. Video Reading
Continue readingCategory: Dashboards
A list of node-red dashboard related posts
Using The Table DashBoard UI Widget Node
The table dashboard ui widget node is used to add tabular data to a dashboard. The node is based on the tabulator module which you can read about here and see examples here. Click to rate this post! [Total: 1 Average: 2]
Continue readingUsing the UI Dashboard Template Node (Widget)
The Dashboard UI template node is used for mainly used for displaying data but it can also be used for data input. The template widget can contain any valid html and Angular/Angular-Material directives. If you aren’t familiar with angular then take a look at the w3 schools tutorial. Click to rate this post! [Total: 4 Average: 4]
Continue readingNode-Red Dashboard -Beginners Guide
You can create a node-red dashboard for IOT and Home automation and for a myriad of other applications. However the nodes that allow you to do this aren’t part of the core nodes and need to be installed separately. Click to rate this post! [Total: 3 Average: 3.7]
Continue reading