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.

Connect the ultrasonic sensor to the Orange Pi

In this tutorial we will learn how to connect a HC-SR04 ultrasonic range sensor to the Orange Pi. This sensor measures distance from the sensor to an object by using ultrasounds. This is similar to how animal echolocation works, for example bats navigating in total darkness. Also, it’s how the submarine’s sonar detects objects under the sea.

Connect the sensor to the Pi

Time for some physical computing on the Orange Pi Plus 2e! We will connect a temperature and humidity sensor to the Orange Pi and write and compile a C code snippet to display the sensor readings. Additionally, you will learn about the GPIO pins.