Hydrook is a lightweight script that uses a Raspberry Pi with 2.8" TFT Resistive touch screen to display real-time values of pH, EC & Temperature values of a hydroponic or aquaponic system via a sqlite database.
(This is what we used - it may work with other specs too)
- Raspberry Pi B+
- 2.8" TFT resistive Touchscreen
- Raspbian Jessie (https://learn.adafruit.com/adafruit-pitft-28-inch-resistive-touchscreen-display-raspberry-pi/easy-install)
- Sqlite database with the values that you want to display
Its easiest if its in the same format as in /dashboard/data/sql_www_ap.sqlite >(use http://inloop.github.io/sqlite-viewer/ to display format)
- Follow the Adafruit tutorial to set up your screen https://learn.adafruit.com/adafruit-pitft-28-inch-resistive-touchscreen-display-raspberry-pi/easy-install
- Clone this repo
git clone https://github.com/pbieberstein/dashboard.git- Set up Cron job to continually update database (see our way below)
- Set up Cron job to start script at reboot (see our way below)
- Set up ssh keys between raspberry pi and computer where database is stored to prevent the need to enter password for every update
You can modify which pH, EC and Temperature values are acceptable inside the /scripts/monitor.py script. In the 'setup variables' section, simply insert the range of values you see as Stable or Unstable.
sudo crontab -eadd the line (our script needs to be run as root)
@reboot cd /home/pi/dashboard/scripts && python monitor.py &
crontab -eadd the line (update of database doesn't have to be root)
*/1 * * * * cd /home/pi/dashboard/scripts && scp [email protected]:/path/to/database
Philipp v. Bieberstein ([email protected])
- Built during Summer School project at Institute of Complex Systems in Nové Hrady, Czech Republic