Configure the Kodi app

In this post we will learn how to develop a Kodi add-on in Python. You can run the add-on in OpenELEC or LibreELEC on the Orange Pi or Raspberry Pi, or as a matter of fact on any device that can run Kodi. The add-on will read data from various sources, such as an API for the current Bitcoin price, and show it on the main screen.

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.

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.