Flickr and mySQL

I have them now which is very exciting. The idea is to mirror what Esologic.com  did and have the Pi dump its sensor data, (that I am currently just tweeting) into a mySQL database then have pChart render a graph from that data and upload it to Flickr. From there, tweepy, my twitter API, can post the link to the Flickr photo yay :)

I got the Flickr API here:
http://stuvel.eu/flickrapi

And used a apt-get command to get mySQL

Here is a great intro to mySQL that I found extremely helpful to understanding exactly what I was doing:
https://www.digitalocean.com/community/articles/a-basic-mysql-tutorial


Also it seems that the internet is very happy about how well pChart and mySQL databases play with each other so once I get pChart up and running I will have another post about that.

A very rudimentary drawing...

This initial idea has the water reservoir being a ~10 gallon fish tank. The tank is elevated so that the water has less distance to travel vertically to reduce the strain on the pump. The growing tubes are gutter downspouts. The "humidity chimney" is simply a pipe that vents the atmosphere from the fish tank reservoir to the atmosphere in the greenhouse to conserve and transfer humidity. Water evaporation is going to happen and so the thought is to at least direct the water vapor into the greenhouse chamber where the plants can benefit from it!

And now for some timing

I had originally planned to use Advanced Python Scheduler (APS) to run the programs that periodically check all the sensors of the hydroponic set up. However, I struggled to get APS working quite the way I wanted so it seems like it will be easier just to use chrontab instead.

Here are two awesome websites with some basic background info on how chrontab works.

http://www.thegeekstuff.com/2009/06/15-practical-crontab-examples/

http://blog.davidsingleton.org/raspberry-pi-webcam-a-gentle-intro-to-crontab/



Code coming soon!