Store and visualize sensor data in SQLite

Store sensor data with SQLite

Very often as part of an Orange Pi or Raspberry Pi project involving sensors, it is useful to store the sensor data in some kind of way or another. A good way to store the data is in a database that you can manage and query. SQLite is a popular embedded database management system. SQLite comes in the form of a C library. Due to it’s low footprint on resources, it fits well with a device such as a Raspberry Pi or the Orange Pi.

Read more…

Web app with Flask & D3.js on Orange Pi

Create a Flask web page

In this tutorial I will show you how to build a simple web app using Flask for the server side scripting and D3.js for the data visualization.

Read more…

Install MySQL on the Orange Pi

Install MySQL and set up a database

In this post I will show you how to install MySQL sever on the Raspberry Pi or on an Orange Pi Plus 2e. Furthermore I will show you how to read and write data from Python to a MySQL database using SQLAlchemy.

Read more…