Microsoft has opened the Azure Marketplace for IoT Edge modules. This makes it easy to find and install IoT Edge modules into your own IoT Edge devices.
At this moment a dozen or more modules are available:
We see a few well-known modules from Microsoft which support SQL Server, Modbus, OPC-UA or the Temperature sensor simulation.
One of these modules is supporting SQLite.
What is SQLite?
According to the homepage, SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is the most widely deployed database in the world with more applications than we can count, including several high-profile projects.
What does the module do?
This IoT Edge module is capable of accessing SQLite databases locally.
“Using this module, developers can build Azure IoT Edge solutions with the capability to access SQLite databases. The SQLite module is an Azure IoT Edge module, capable of executing SQL queries sent from other modules, and return the result to the senders or to the Azure IoT Hub via the Edge framework. Developers can modify the module tailoring to any scenario.”
The module is open source and both documentation and source code are put on GitHub.
Why should we use this module?
In the past, I checked out the SQL Server IoT module to persist IoT messages locally.
This SQLite module has a few advantages which you will like:
- It’s lightweight
- It’s based on a public domain framework
- It’s integrated with the routing of IoT Edge
For me, that last item, we can integrate the module directly in the routing is interested.
So let’s check out how we can use it.
Continue reading “Integrating SQLite in Azure IoT Edge for local storage”