{"id":105,"date":"2016-12-24T16:05:21","date_gmt":"2016-12-24T16:05:21","guid":{"rendered":"http:\/\/bryceautomation.com\/?p=105"},"modified":"2017-05-17T15:02:42","modified_gmt":"2017-05-17T15:02:42","slug":"configuring-a-database-to-log-data-for-arduino-projects","status":"publish","type":"post","link":"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/","title":{"rendered":"Configuring a Database to log data for Arduino Projects"},"content":{"rendered":"<p>This document will walk you through my personal preference for creating an arduino database and tables to log data from your project to this\u00a0database. \u00a0In this particular example, we will set this database up to log level, temperature, and humidity. \u00a0 You will need to already have a server setup in a LAMP configuration. \u00a0 If you do not have this set up already, please use this procedure to configure a VPS.<\/p><div id=\"bryce-1507529267\" class=\"bryce-afterfirst bryce-entity-placement\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8316758073402323\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:block;\" data-ad-client=\"ca-pub-8316758073402323\" \ndata-ad-slot=\"7728240895\" \ndata-ad-format=\"auto\"><\/ins>\n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>\n<p><a href=\"https:\/\/bryceautomation.com\/index.php\/configuring-virtual-private-server\/\">https:\/\/bryceautomation.com\/index.php\/configuring-virtual-private-server\/<\/a><\/p>\n<p>Once you have a server set up, we will install webmin onto the server, and use webmin to configure our database graphically.<\/p>\n<p>&nbsp;<\/p>\n<h4>Step 1 &#8212; Webmin Download<\/h4>\n<p>Go to\u00a0<a href=\"http:\/\/webmin.com\">http:\/\/webmin.com<\/a>, and select the Debian Package<\/p>\n<h4>Step 2 &#8212; Copy the Link Location<\/h4>\n<p><img decoding=\"async\" class=\"alignright size-medium wp-image-76 lazyload\" data-src=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/webmindirectlink-300x144.png\" alt=\"Webmin Direct Link\" width=\"300\" height=\"144\" data-srcset=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/webmindirectlink-300x144.png 300w, https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/webmindirectlink.png 401w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/144;\" \/>We want to download the debian package onto the server, and not onto our computer. \u00a0 We will cancel the popup that prompts us to download the file to our computer, and <strong>right click<\/strong> the direct link, and copy the link location (or link address). \u00a0 We will use this link location to download the file onto our server.<\/p>\n<h4>Step 3 &#8212; Download the file onto our web server<\/h4>\n<p>Log into putty as root. \u00a0 We will type<strong> cd \/root<\/strong> to enter our root home folder. \u00a0then type: <strong>\u00a0wget:http:\/\/downloads.sourceforge.net\/project\/webadmin\/webmin\/1.820\/webmin_1.820_all.deb?r=http%3A%2F%2Fwebmin.com%2F&amp;ts=1482526185&amp;use_mirror=pilotfiber<\/strong><\/p>\n<p>That&#8217;s wget, then a space, and paste the link you copied from the download page. \u00a0 \u00a0This will download the file we need to install webmin.<\/p>\n<h4>Step 4 &#8212; Rename the file<\/h4>\n<p>Let&#8217;s rename the file, so it is a bit easier to work with&#8230; \u00a0Again, assuming this is the only webmin file in this directory. \u00a0 <strong>mv webmin* webmin.deb<\/strong><\/p>\n<h4>Step 5 &#8212; Install Webmin<\/h4>\n<p>To install webmin, type <strong>dpkg -i webmin.deb<\/strong><\/p>\n<h4>Step 6 &#8212; Fixing errors<\/h4>\n<p>We have some dependency errors that we need to fix. \u00a0 Type <strong>apt-get -f install<\/strong><\/p>\n<h4>Step 7 &#8212; Logging into Webmin<\/h4>\n<p>Now, in your web browser, you can go to https:\/\/learnautomation.com:10000, substituting your own domain name. \u00a0You might have to choose &#8220;advanced&#8221; on the initial page to confirm that you want to enter the site. \u00a0 Whatever browser, you are using, you will want to get past the security messages, and confirm that you want to enter the site. \u00a0 Then log in as root with your password for the server.<\/p>\n<h4>Step 8 &#8212; Select MySQL Database<img decoding=\"async\" class=\"size-full wp-image-78 alignleft lazyload\" data-src=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/selectmysql.png\" alt=\"Select MySQL\" width=\"192\" height=\"154\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 192px; --smush-placeholder-aspect-ratio: 192\/154;\" \/><\/h4>\n<p>Under &#8220;Servers&#8221;, we will open MySQL Database<\/p>\n<h4>Step 9 &#8212; Create the database<img decoding=\"async\" class=\"alignright size-medium wp-image-79 lazyload\" data-src=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/mysqlcreatedatabase-300x60.png\" alt=\"MySQL Database\" width=\"300\" height=\"60\" data-srcset=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/mysqlcreatedatabase-300x60.png 300w, https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/mysqlcreatedatabase.png 324w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/60;\" \/><\/h4>\n<p>Log in as &#8220;root&#8221; with your password if asked, and select &#8220;Create New Database&#8221;<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"size-medium wp-image-107 alignleft lazyload\" data-src=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinocreatedatabasejpg-300x77.png\" alt=\"Arduino Create Database\" width=\"300\" height=\"77\" data-srcset=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinocreatedatabasejpg-300x77.png 300w, https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinocreatedatabasejpg.png 592w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/77;\" \/>Now, Name your database, and press the &#8220;create&#8221; button.<\/p>\n<h4>Step 10 &#8212; User Permissions<img decoding=\"async\" class=\"alignright size-full wp-image-81 lazyload\" data-src=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/mysqluserpermissions.png\" alt=\"MySQL User Permissions\" width=\"214\" height=\"129\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 214px; --smush-placeholder-aspect-ratio: 214\/129;\" \/><\/h4>\n<p>Now, we will add a user to our database, so we will select &#8220;User Permissions&#8221;<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-82 alignleft lazyload\" data-src=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/mysqlcreateuser.png\" alt=\"Create user\" width=\"288\" height=\"63\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 288px; --smush-placeholder-aspect-ratio: 288\/63;\" \/>Now, choose to &#8220;Create new User&#8221;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Complete the user<br \/>\n<img decoding=\"async\" class=\"alignright size-medium wp-image-108 lazyload\" data-src=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinocreateuser-300x74.png\" alt=\"Arduino Create user\" width=\"300\" height=\"74\" data-srcset=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinocreateuser-300x74.png 300w, https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinocreateuser.png 512w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/74;\" \/>\u00a0permissions as follows. \u00a0 \u00a0We don&#8217;t need to give this user any privileges right now. \u00a0We will make them specific to the database later on. \u00a0Be sure to choose &#8220;localhost&#8221; for the user, though, and set the password for this user. \u00a0Here, I&#8217;ll just name the user &#8220;learnautomation&#8221;<\/p>\n<p>Press &#8220;Create&#8221; to finish creating the user.<\/p>\n<h4>Step 11 &#8212; Database Permissions<img decoding=\"async\" class=\"alignright size-full wp-image-84 lazyload\" data-src=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/databasepermissions1.png\" alt=\"Database permissions1\" width=\"191\" height=\"85\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 191px; --smush-placeholder-aspect-ratio: 191\/85;\" \/><\/h4>\n<p>Now, we will associate the new user to the database, so back on the main MySQL page, we will select &#8220;<strong>Database Permissions<\/strong>&#8220;, then &#8220;<strong>Create New Database Permissions<\/strong>&#8220;.<\/p>\n<p>&nbsp;<br \/>\n<img decoding=\"async\" class=\"size-medium wp-image-109 alignleft lazyload\" data-src=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinodatabasepermissions-300x244.png\" alt=\"Arduino Database permissions\" width=\"300\" height=\"244\" data-srcset=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinodatabasepermissions-300x244.png 300w, https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinodatabasepermissions.png 399w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/244;\" \/>Complete the form similar to the one shown. \u00a0 Again, here we are mainly concerned with just getting the page running. \u00a0 You can always research more secure settings. \u00a0 To give this user all privileges, click the top privilege, scroll to the bottom of the privilege list. \u00a0 Hold down shift and click the bottom privilege to select all privileges. \u00a0 \u00a0Then press &#8220;<strong>Create<\/strong>&#8220;.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Step 12 &#8212; Creating the initial table<\/p>\n<p><img decoding=\"async\" class=\"alignright size-full wp-image-110 lazyload\" data-src=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduiondatabaseicon.png\" alt=\"Arduino Database Icon\" width=\"112\" height=\"83\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 112px; --smush-placeholder-aspect-ratio: 112\/83;\" \/>Next, we will create a table. \u00a0 In this table, we will have a unique ID to identify entries, and level, temperature, and humidity. \u00a0Back on the main MySQL Database page in Webmin, we will click on our &#8220;arduino&#8221; database.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-111 alignleft lazyload\" data-src=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduionocreatetable.png\" alt=\"Arduino Create Table\" width=\"207\" height=\"81\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 207px; --smush-placeholder-aspect-ratio: 207\/81;\" \/>In this example, we will create 5 fields. \u00a0 The number of fields you use will depend on your project, and how much data you want to log. \u00a0 Please modify this accordingly.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"alignright wp-image-112 size-full lazyload\" data-src=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinotableproperties.png\" alt=\"Arduino Table Properties\" width=\"906\" height=\"274\" data-srcset=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinotableproperties.png 906w, https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinotableproperties-300x91.png 300w, https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinotableproperties-768x232.png 768w\" data-sizes=\"(max-width: 906px) 100vw, 906px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 906px; --smush-placeholder-aspect-ratio: 906\/274;\" \/>For logging our level, temperature, and humidity, we will set the table up as follows. \u00a0 Please modify these fields according to your project.<\/p>\n<p>Press &#8220;Create&#8221; and that&#8217;s it!!! \u00a0 You are ready to start using the table with your arduino project!!<\/p>\n<p>&nbsp;<\/p>\n<p><em>&#8212; \u00a0Ricky Bryce<\/em><\/p>\n<div id=\"bryce-1331002317\" class=\"bryce-after-content bryce-entity-placement\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8316758073402323\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:block;\" data-ad-client=\"ca-pub-8316758073402323\" \ndata-ad-slot=\"4667596182\" \ndata-ad-format=\"auto\"><\/ins>\n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>This document will walk you through my personal preference for creating an arduino database and tables to log data from your project to this\u00a0database. \u00a0In this particular example, we will set this database up to log level, temperature, and humidity. \u00a0 You will need to already have a server setup in a LAMP configuration. \u00a0 <a class=\"moretag btn btn-primary\" href=\"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/\">Read More \u00bb<\/a><\/p>\n","protected":false},"author":1,"featured_media":112,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,5],"tags":[],"class_list":{"0":"post-105","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-advanced","8":"category-arduino-other-microprocessors","9":"czr-hentry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating an Arduino database using MySQL for your projects.<\/title>\n<meta name=\"description\" content=\"This document will guide you through creating a database for your Arduino projects. We will use this to log and display project data.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating an Arduino database using MySQL for your projects.\" \/>\n<meta property=\"og:description\" content=\"This document will guide you through creating a database for your Arduino projects. We will use this to log and display project data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/\" \/>\n<meta property=\"og:site_name\" content=\"Bryce Automation\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ricky.bryce.7\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-24T16:05:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-05-17T15:02:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinotableproperties.png\" \/>\n\t<meta property=\"og:image:width\" content=\"906\" \/>\n\t<meta property=\"og:image:height\" content=\"274\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ricky\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/index.php\\\/2016\\\/12\\\/24\\\/configuring-a-database-to-log-data-for-arduino-projects\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/index.php\\\/2016\\\/12\\\/24\\\/configuring-a-database-to-log-data-for-arduino-projects\\\/\"},\"author\":{\"name\":\"Ricky\",\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/#\\\/schema\\\/person\\\/5d5b0f6f6ad768f1ee52968338e63af7\"},\"headline\":\"Configuring a Database to log data for Arduino Projects\",\"datePublished\":\"2016-12-24T16:05:21+00:00\",\"dateModified\":\"2017-05-17T15:02:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/index.php\\\/2016\\\/12\\\/24\\\/configuring-a-database-to-log-data-for-arduino-projects\\\/\"},\"wordCount\":750,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/index.php\\\/2016\\\/12\\\/24\\\/configuring-a-database-to-log-data-for-arduino-projects\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bryceautomation.com\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/arduinotableproperties.png\",\"articleSection\":[\"Advanced\",\"Arduino and other microprocessors\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/bryceautomation.com\\\/index.php\\\/2016\\\/12\\\/24\\\/configuring-a-database-to-log-data-for-arduino-projects\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/index.php\\\/2016\\\/12\\\/24\\\/configuring-a-database-to-log-data-for-arduino-projects\\\/\",\"url\":\"https:\\\/\\\/bryceautomation.com\\\/index.php\\\/2016\\\/12\\\/24\\\/configuring-a-database-to-log-data-for-arduino-projects\\\/\",\"name\":\"Creating an Arduino database using MySQL for your projects.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/index.php\\\/2016\\\/12\\\/24\\\/configuring-a-database-to-log-data-for-arduino-projects\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/index.php\\\/2016\\\/12\\\/24\\\/configuring-a-database-to-log-data-for-arduino-projects\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bryceautomation.com\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/arduinotableproperties.png\",\"datePublished\":\"2016-12-24T16:05:21+00:00\",\"dateModified\":\"2017-05-17T15:02:42+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/#\\\/schema\\\/person\\\/5d5b0f6f6ad768f1ee52968338e63af7\"},\"description\":\"This document will guide you through creating a database for your Arduino projects. We will use this to log and display project data.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/index.php\\\/2016\\\/12\\\/24\\\/configuring-a-database-to-log-data-for-arduino-projects\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/bryceautomation.com\\\/index.php\\\/2016\\\/12\\\/24\\\/configuring-a-database-to-log-data-for-arduino-projects\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/index.php\\\/2016\\\/12\\\/24\\\/configuring-a-database-to-log-data-for-arduino-projects\\\/#primaryimage\",\"url\":\"https:\\\/\\\/bryceautomation.com\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/arduinotableproperties.png\",\"contentUrl\":\"https:\\\/\\\/bryceautomation.com\\\/wp-content\\\/uploads\\\/2016\\\/12\\\/arduinotableproperties.png\",\"width\":906,\"height\":274,\"caption\":\"Arduino Table Properties\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/index.php\\\/2016\\\/12\\\/24\\\/configuring-a-database-to-log-data-for-arduino-projects\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/bryceautomation.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Configuring a Database to log data for Arduino Projects\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/#website\",\"url\":\"https:\\\/\\\/bryceautomation.com\\\/\",\"name\":\"Bryce Automation\",\"description\":\"Automating Home and Industry...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/bryceautomation.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/#\\\/schema\\\/person\\\/5d5b0f6f6ad768f1ee52968338e63af7\",\"name\":\"Ricky\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/bryceautomation.com\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/a8f\\\/a8fe6bf79d292b388ffee281ccb12488x96.jpg\",\"url\":\"https:\\\/\\\/bryceautomation.com\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/a8f\\\/a8fe6bf79d292b388ffee281ccb12488x96.jpg\",\"contentUrl\":\"https:\\\/\\\/bryceautomation.com\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/a8f\\\/a8fe6bf79d292b388ffee281ccb12488x96.jpg\",\"caption\":\"Ricky\"},\"sameAs\":[\"http:\\\/\\\/bryceautomation.com\",\"https:\\\/\\\/www.facebook.com\\\/ricky.bryce.7\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/ricky-bryce-4367a416\\\/\"],\"url\":\"https:\\\/\\\/bryceautomation.com\\\/index.php\\\/author\\\/ricky\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating an Arduino database using MySQL for your projects.","description":"This document will guide you through creating a database for your Arduino projects. We will use this to log and display project data.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/","og_locale":"en_US","og_type":"article","og_title":"Creating an Arduino database using MySQL for your projects.","og_description":"This document will guide you through creating a database for your Arduino projects. We will use this to log and display project data.","og_url":"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/","og_site_name":"Bryce Automation","article_author":"https:\/\/www.facebook.com\/ricky.bryce.7","article_published_time":"2016-12-24T16:05:21+00:00","article_modified_time":"2017-05-17T15:02:42+00:00","og_image":[{"width":906,"height":274,"url":"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinotableproperties.png","type":"image\/png"}],"author":"Ricky","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/#article","isPartOf":{"@id":"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/"},"author":{"name":"Ricky","@id":"https:\/\/bryceautomation.com\/#\/schema\/person\/5d5b0f6f6ad768f1ee52968338e63af7"},"headline":"Configuring a Database to log data for Arduino Projects","datePublished":"2016-12-24T16:05:21+00:00","dateModified":"2017-05-17T15:02:42+00:00","mainEntityOfPage":{"@id":"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/"},"wordCount":750,"commentCount":0,"image":{"@id":"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/#primaryimage"},"thumbnailUrl":"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinotableproperties.png","articleSection":["Advanced","Arduino and other microprocessors"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/","url":"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/","name":"Creating an Arduino database using MySQL for your projects.","isPartOf":{"@id":"https:\/\/bryceautomation.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/#primaryimage"},"image":{"@id":"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/#primaryimage"},"thumbnailUrl":"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinotableproperties.png","datePublished":"2016-12-24T16:05:21+00:00","dateModified":"2017-05-17T15:02:42+00:00","author":{"@id":"https:\/\/bryceautomation.com\/#\/schema\/person\/5d5b0f6f6ad768f1ee52968338e63af7"},"description":"This document will guide you through creating a database for your Arduino projects. We will use this to log and display project data.","breadcrumb":{"@id":"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/#primaryimage","url":"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinotableproperties.png","contentUrl":"https:\/\/bryceautomation.com\/wp-content\/uploads\/2016\/12\/arduinotableproperties.png","width":906,"height":274,"caption":"Arduino Table Properties"},{"@type":"BreadcrumbList","@id":"https:\/\/bryceautomation.com\/index.php\/2016\/12\/24\/configuring-a-database-to-log-data-for-arduino-projects\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bryceautomation.com\/"},{"@type":"ListItem","position":2,"name":"Configuring a Database to log data for Arduino Projects"}]},{"@type":"WebSite","@id":"https:\/\/bryceautomation.com\/#website","url":"https:\/\/bryceautomation.com\/","name":"Bryce Automation","description":"Automating Home and Industry...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bryceautomation.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/bryceautomation.com\/#\/schema\/person\/5d5b0f6f6ad768f1ee52968338e63af7","name":"Ricky","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bryceautomation.com\/wp-content\/wphb-cache\/gravatar\/a8f\/a8fe6bf79d292b388ffee281ccb12488x96.jpg","url":"https:\/\/bryceautomation.com\/wp-content\/wphb-cache\/gravatar\/a8f\/a8fe6bf79d292b388ffee281ccb12488x96.jpg","contentUrl":"https:\/\/bryceautomation.com\/wp-content\/wphb-cache\/gravatar\/a8f\/a8fe6bf79d292b388ffee281ccb12488x96.jpg","caption":"Ricky"},"sameAs":["http:\/\/bryceautomation.com","https:\/\/www.facebook.com\/ricky.bryce.7","https:\/\/www.linkedin.com\/in\/ricky-bryce-4367a416\/"],"url":"https:\/\/bryceautomation.com\/index.php\/author\/ricky\/"}]}},"_links":{"self":[{"href":"https:\/\/bryceautomation.com\/index.php\/wp-json\/wp\/v2\/posts\/105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bryceautomation.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bryceautomation.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bryceautomation.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bryceautomation.com\/index.php\/wp-json\/wp\/v2\/comments?post=105"}],"version-history":[{"count":0,"href":"https:\/\/bryceautomation.com\/index.php\/wp-json\/wp\/v2\/posts\/105\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bryceautomation.com\/index.php\/wp-json\/wp\/v2\/media\/112"}],"wp:attachment":[{"href":"https:\/\/bryceautomation.com\/index.php\/wp-json\/wp\/v2\/media?parent=105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bryceautomation.com\/index.php\/wp-json\/wp\/v2\/categories?post=105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bryceautomation.com\/index.php\/wp-json\/wp\/v2\/tags?post=105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}