How to Store Data on Raspberry PI running Windows IoT Core Using SQLite Database
“There’s nothing special about IIoT, we’ve been collecting data from control systems for eons”
I’m sure you’ve heard this before.
True, data collection is nothing new in industry.
But that’s hardly what makes IIoT special.
Rather, it is the unique set of circumstances we have today that make it possible for sensors, machines, PLCs, microcontrollers, servers, analytics apps, and web browsers e.t.c to share and process the stream of information passing through them.
Case in point: at a time when the proliferation of sensors is generating vast amounts of data at the factory-floor, innovation has also opened doors for devices that are powerful enough to run full-fledged operating systems to process the data, right at its source.
Enabling complex computation to be carried out on-site, without leaving the physical world. And other benefits such as:
✔️Increasing availability & usability of data-driven insights.
✔️Pre-processing of data before transmitting to cloud
✔️Receiving and storing configuration data from the cloud.
In the video below I demonstrate how to use Windows IoT OS, running a C# UWP IoT App on Raspberry Pi to store data locally using SQLite, a light version of SQL server database.
THE HALF LIFE OF A LEARNED SKILL USED TO BE 30 YEARS. TODAY IT'S 5.
And it will continue to decrease exponentially. The only way to avoid becoming irrelevant is to get in the habit of reinventing yourself every single day.