Regarding the software, this time the major part is covered by the web interface, which is the real core of the project, and the acquisition and controlling process to get the aquarium data and managing the actuators. Then, a dedicated monitor script will be used to implement the communication between the web interface and the internal database.
To manage the status of all devices and to do the data logging, we can use a database again to store all the relevant data, as we did in Chapter 1, Dangerous Gas Sensors. So, we can use the chapter_03/my_init.sh file in the book's example code repository to set up the database. The following snippet shows the relevant code where we define the tables used in the project:
# Select database
USE aquarium_mon;
#
# Create the system status table
#
CREATE TABLE status (
n VARCHAR(64) NOT NULL,
v VARCHAR(64) NOT NULL,
PRIMARY KEY (n)
) ENGINE=MEMORY;
# Setup default...