Screen Shot 2018-01-03 at 8.25.37 PM.png

IoT Exploration

Project to collect, store, and aggregate data from sensor affixed to our refrigerator door. Final API endpoint returned vital aggregated stats like the number of times the refrigerator door was opened... to the number of times our cat decided to have batting practice with the sensor.  

 For this project, I used a  Particle Photon  fixed with 2 sensors to record my refrigerator activity for one month. Sensors consisted of an accelerometer measuring movement and a 'hall' sensor measuring the connection of a closed door to a magnet. 

For this project, I used a Particle Photon fixed with 2 sensors to record my refrigerator activity for one month. Sensors consisted of an accelerometer measuring movement and a 'hall' sensor measuring the connection of a closed door to a magnet. 

 Raw data was collected once per second and sent to Amazon Relational Database System (RDS).  By then end of the month, the data exceeded  3 million rows  in 2 tables.

Raw data was collected once per second and sent to Amazon Relational Database System (RDS).  By then end of the month, the data exceeded 3 million rows in 2 tables.

 Raw data was then aggregated to daily stats using PostgreSQL measuring the number of times the refrigerator door was opened, as well as tracking hardware faults caused by our beloved pet cat. 

Raw data was then aggregated to daily stats using PostgreSQL measuring the number of times the refrigerator door was opened, as well as tracking hardware faults caused by our beloved pet cat. 

 These daily stats were then available upon request to an  API endpoint  that returned the result of the query above. This endpoint was hosted on Amazon Elastic Compute Cloud

These daily stats were then available upon request to an API endpoint that returned the result of the query above. This endpoint was hosted on Amazon Elastic Compute Cloud