{"id":386,"date":"2013-11-22T15:42:27","date_gmt":"2013-11-22T14:42:27","guid":{"rendered":"http:\/\/www.verelec.nl\/?page_id=386"},"modified":"2013-11-22T15:42:27","modified_gmt":"2013-11-22T14:42:27","slug":"collecting-data-from-remote-sensors-over-the-internet","status":"publish","type":"page","link":"https:\/\/www.verelec.nl\/?page_id=386","title":{"rendered":"Collecting data from remote sensors over the internet"},"content":{"rendered":"<p>22-11-2013<\/p>\n<p>Having seen a number of solutions where data is sent from an Arduino (or any sensor with internet connectivity) I was still having trouble of getting them installed in my own hosting environment. Either the solutions are not open source of have such a complicated environment that it will take too much effort to implement. So time to develop something simple but effective fo my own and make it available eventually in GITHUB.<\/p>\n<p>And while I am busy with the design I might as well use UML and other modern methodologies to stay in practice :).<\/p>\n<p>I built a Proof of Concept where I have my WiFi Arduino shield send data as $POST to a server application and store the data in a MySQL database. While playing around with it, I used Codeigniter for building the code. It is a great tool for building MVC apps.<\/p>\n<p>So the basic functionality to focus on short term will be\u00a0 :<\/p>\n<ul>\n<li>maintain Users (add\/create\/delete\/modify)<\/li>\n<li>maintain tables for data (each table has a unique stream-key)<\/li>\n<li>the fields accepted from sensors are the columns in the tables<\/li>\n<li>Each user owns a number of unique tables (=streams of data)<\/li>\n<li>data can be downloaded.<\/li>\n<\/ul>\n<p>Fancy stuff like graphs etc will be a future thing.<\/p>\n<p>The technical environment will be:<\/p>\n<ul>\n<li>PHP 5<\/li>\n<li>MySQL5<\/li>\n<li>Codeigniter<\/li>\n<li>maybe GroceryCrud<\/li>\n<li>HTML\/CSS<\/li>\n<\/ul>\n<p>Will be continued&#8230;.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>22-11-2013 Having seen a number of solutions where data is sent from an Arduino (or any sensor with internet connectivity) I was still having trouble of getting them installed in my own hosting environment. Either the solutions are not open &hellip; <a href=\"https:\/\/www.verelec.nl\/?page_id=386\">Lees verder <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/www.verelec.nl\/index.php?rest_route=\/wp\/v2\/pages\/386"}],"collection":[{"href":"https:\/\/www.verelec.nl\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.verelec.nl\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.verelec.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.verelec.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=386"}],"version-history":[{"count":1,"href":"https:\/\/www.verelec.nl\/index.php?rest_route=\/wp\/v2\/pages\/386\/revisions"}],"predecessor-version":[{"id":387,"href":"https:\/\/www.verelec.nl\/index.php?rest_route=\/wp\/v2\/pages\/386\/revisions\/387"}],"wp:attachment":[{"href":"https:\/\/www.verelec.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}