{"id":42181,"date":"2020-09-14T08:35:35","date_gmt":"2020-09-14T06:35:35","guid":{"rendered":"https:\/\/botland.com.pl\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/"},"modified":"2021-05-04T12:50:16","modified_gmt":"2021-05-04T10:50:16","slug":"a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1","status":"publish","type":"post","link":"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/","title":{"rendered":"A simple smart home system for everyone based on Raspberry Pi Zero \u2013 Part 1"},"content":{"rendered":"<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Reading time:<\/span> <span class=\"rt-time\"> 4<\/span> <span class=\"rt-label rt-postfix\">min.<\/span><\/span><p><b>Smart home systems are becoming increasingly common in our households. Control of appliances, security and monitoring of our four walls is an interesting and convenient solution, but due to high prices of ready-made systems, many people choose to install only modules for controlling appliances at home.<\/b><\/p>\n<p><strong>Today, we will build a system that will allow you to control your home over the Internet!<\/strong><\/p>\n<p>The main assumptions of the project:<\/p>\n<ul>\n<li>Controlling devices connected to the power grid,<\/li>\n<li>Temperature measurement,<\/li>\n<li>Simple and comfortable design,<\/li>\n<li>Controlling and checking the status of devices from anywhere in the world.<\/li>\n<\/ul>\n<h2>What will we need?<br \/>\n<\/h2>\n<p>\nTo make the system easy to use via the website, we will be using the <strong>Raspberry Pi Zero W<\/strong> &#8211; a minicomputer worshipped by the electronics industry &#8211; a device that will surprise you with a positive price\/quality ratio. The model with the letter &#8220;W&#8221; is equipped with Wi-Fi and Bluetooth, so we do not have to worry about connecting to the Internet. In addition to the minicomputer, we will have to buy relays for controlling network devices &#8211; here we will use ready-made Grove modules, which we will connect to the Raspberry Pi shield. This way we will minimise the problem of wiring. To measure the temperature at home (or outside, the choice is up to you), you need a temperature sensor. We will use the popular DS18B20.\n<\/p>\n<p>\nYou will find the exact shopping list below:\n<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/botland.store\/rpi-zero-modules-and-kits\/8330-raspberry-pi-zero-w-wifi-bluetooth-512mb-ram-1ghz.html\" data-wpel-link=\"internal\">Raspberry Pi Zero W<\/a><\/strong>\n<li><strong><a href=\"https:\/\/botland.store\/microsd-sd-cards\/2123-memory-card-m1aa-goodram-microsd-16gb-60mbs-uhs-i-class-10-with-adapter-5908267930137.html\" data-wpel-link=\"internal\">Memory card <\/a><\/strong>\n<li><strong><a href=\"https:\/\/botland.store\/socket-power-supply\/14515-power-supply-for-raspberry-pi-3b3b2bzero-microusb-black-5v25a-5903351241410.html\" data-wpel-link=\"internal\">5V power supply, microUSB<\/a><\/strong>\n<li><strong><a href=\"https:\/\/botland.store\/grove-base-hats\/15459-grove-base-hat-for-raspberry-pi-zero-shield-for-raspberry-pi-zero.html\" data-wpel-link=\"internal\">Grove Base Hut for Raspberry Pi Zero<\/a><\/strong>\n<li><strong><a href=\"https:\/\/botland.store\/grove-relays\/11347-grove-relay-module-v12.html\" data-wpel-link=\"internal\">Grove relays<\/a> <\/strong>&#8211; 4 pieces\n<li><strong><a href=\"https:\/\/botland.store\/grove-cables\/15451-grove-female-female-4-pin-2mm-20cm-cable.html\" data-wpel-link=\"internal\">Cables connecting relays to the RPi cover<\/a> <\/strong>&#8211; 4 pieces\n<li><strong><a href=\"https:\/\/botland.store\/waterproof-probes\/1713-waterproof-probe-with-temperature-sensor-ds18b20-1m-5903351242226.html\" data-wpel-link=\"internal\">DS18B20 temperature sensor<\/a><\/strong>\n<li><strong><a href=\"https:\/\/botland.store\/various-wires\/9733-connecting-cables-female-female-10cm-40pcs.html\" data-wpel-link=\"internal\">The cables to connect the DS18B20 with RPi<\/a><\/strong>\n<li><strong><a href=\"https:\/\/botland.store\/through-hole-resistors-tht\/3973-tht-cf-carbon-resistor-1-4w-47k-30pcs.html\" data-wpel-link=\"internal\">4.7k Ohm resistor<\/a><\/strong>\n<li><strong><a href=\"https:\/\/botland.store\/connectors-goldpin\/12659-goldpin-2x20-straight-raster-254mm.html\" data-wpel-link=\"internal\">2 \u00d7 20 male Goldpins<\/a><\/strong>\n<\/li>\n<\/ul>\n<p>\nIn addition to the electronic components, we need a soldering iron, wire cutters and of course the enthusiasm to create our own system!\n<\/p>\n<h2>Preparing Raspberry Pi for the work<br \/>\n<\/h2>\n<p>\nLike PCs or laptops, Raspberry requires an operating system. However, we do not upload the system to the hard disk, but to the microSD card. Let&#8217;s start by downloading the system image from the <strong><a href=\"https:\/\/www.raspberrypi.org\/software\/\" data-wpel-link=\"external\" target=\"_blank\" rel=\"nofollow external noopener noreferrer\">Raspberry Pi website<\/a><\/strong>.\n<\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"413\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika2-1024x528.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika2-1024x528.jpg 1024w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika2-300x155.jpg 300w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika2-768x396.jpg 768w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika2-640x330.jpg 640w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika2.jpg 1350w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption>Available system versions<\/figcaption><\/figure>\n<p>\nWe have three versions available here. In the lower left corner is the Lite version, the minimal version without graphical interface. The upper right corner shows the version with graphic interface, and the upper left corner &#8211; with graphic interface and recommended software. We download the latter because most of the programs we will need are already installed on the system by default, so we do not waste time downloading and installing additional software. When the package with the system image is downloaded, we can then insert the microSD card into the slot so that it can be seen by the computer to which the package was downloaded.\n<\/p>\n<p>\nNow we want to upload the system to the memory card. Again, the operation is very simple. We start by downloading Etcher. Etcher is a software that allows you to seamlessly upload system images to memory cards. Once you have downloaded and installed the program, click on &#8220;Select Image&#8221; and select the location of the downloaded file with the system. Then click on &#8220;Select Drive&#8221; and choose our memory card. Finally, click on &#8221; Flash! &#8221; and wait until the system image is uploaded to the memory card.\n<\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"796\" height=\"477\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika5.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika5.jpg 796w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika5-300x180.jpg 300w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika5-768x460.jpg 768w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika5-640x384.jpg 640w\" sizes=\"(max-width: 796px) 100vw, 796px\" \/><figcaption>Etcher &#8211; software for uploading images to external media<\/figcaption><\/figure>\n<p>\nAfter uploading the system, start the wireless communication. We open the Boot directory stored on the memory card and create there an empty file without an extension, named ssh. To avoid problems, make sure that the system shows file extensions. We can change it by clicking &#8220;View&#8221; and then &#8220;Options&#8221;. Deselect &#8220;Hide extensions for known file types&#8221;.\n<\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"95\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika6-1024x122.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika6-1024x122.jpg 1024w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika6-300x36.jpg 300w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika6-768x91.jpg 768w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika6-640x76.jpg 640w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika6.jpg 1178w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption>Here we right-click on &#8220;Options&#8221;\u2026<\/figcaption><\/figure>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"385\" height=\"487\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika7.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika7.jpg 385w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika7-237x300.jpg 237w\" sizes=\"(max-width: 385px) 100vw, 385px\" \/><figcaption>\u2026and uncheck \u201cHide extensions for known file types\u201d.<\/figcaption><\/figure>\n<p>\t\tNow we can right-click in the folder, choose &#8220;New&#8221;, then select &#8220;Text Document&#8221; and name it &#8220;ssh&#8221; and then delete the .txt extension.<br \/>\nThe final step in establishing proper communication is to connect to the Wi-Fi network, i.e. to tell your Raspberry which network it should connect to. This process is also simple &#8211; in the Boot folder we create a text file wpa_supplicant.conf. We open it with a text editor (we can do this with the system&#8217;s notebook) and enter this content:<\/p>\n<p><i>country=PL<\/i><\/p>\n<p><i>update_config=1<\/i><\/p>\n<p><i>ctrl_interface=DIR=\/var\/run\/wpa_supplicant GROUP=netdev<\/i><\/p>\n<p><i>network={<\/i><\/p>\n<p><i>\u00a0 \u00a0 ssid=&#8221;Wpisz tutaj swoj\u0105 nazw\u0119 sieci&#8221;<\/i><\/p>\n<p><i>\u00a0 \u00a0 psk=\u201dTutaj wpisz swoje has\u0142o&#8221;<\/i><\/p>\n<p><i>\u00a0 \u00a0 key_mgmt=WPA-PSK<\/i><\/p>\n<p><i>}<\/i><\/p>\n<p>In &#8220;ssid&#8221; we enter the name of the network, and in &#8220;psk&#8221; &#8211; the password. Be careful not to make any typos here, because if any occurs, Raspberry Pi will not be able to connect to the network. Then save the file and insert the card into your Raspberry, and connect the power supply first to the socket and then to the Raspberry microUSB connector provided for the power supply. Now the magic begins!\t\t<\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"639\" height=\"101\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika8.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika8.jpg 639w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika8-300x47.jpg 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><figcaption>Two files necessary to establish wireless connection.<\/figcaption><\/figure>\n<h2>Connecting the Raspberry to your PC<br \/>\n<\/h2>\n<p>\nAlthough you can connect a monitor, keyboard and mouse to your Raspberry Pi, in this project we will control this minicomputer via its bigger brother, i.e. a PC or a laptop.\n<\/p>\n<p>\nLet&#8217;s check if Raspberry has already connected to the wireless network! To do this, we need to go to the router&#8217;s configuration panel (usually at 192.168.1.1) and look at the devices connected via Wi-Fi. If you see a device called &#8220;raspberrypi&#8221;, the connection is fine. If Raspberry did not connect, check if you did not mistype anything in the wpa_supplicant.conf file &#8211; this is usually the cause of the connection problem.\n<\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"483\" height=\"46\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika9.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika9.jpg 483w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika9-300x29.jpg 300w\" sizes=\"(max-width: 483px) 100vw, 483px\" \/><figcaption>The correct configuration<\/figcaption><\/figure>\n<p>\nLet&#8217;s install Putty now. It is a client of the Telnet and SSH services, which allows us to connect to Raspberry and control it using a terminal. The program can be downloaded from the software page. After installation, turn on the program, enter the local address of your Raspberry under &#8220;Host Name&#8221;, enter 22 under &#8220;Port&#8221; and then click on &#8220;Open&#8221;.\n<\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"449\" height=\"439\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika16.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika16.jpg 449w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika16-300x293.jpg 300w\" sizes=\"(max-width: 449px) 100vw, 449px\" \/><figcaption>Putty configuration screen.<\/figcaption><\/figure>\n<p>\nWhen we click &#8220;Open&#8221; we will see the login screen. The default login details are:\n<\/p>\n<p>\nlogin \u2013 <strong>pi<\/strong>\n<\/p>\n<p>\npassword \u2013 <strong>raspberry<\/strong>\n<\/p>\n<p>\nWe enter these details to log in and then we should be welcomed by this view:\n<\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"660\" height=\"416\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/01\/grafika15.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/01\/grafika15.jpg 660w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/01\/grafika15-300x189.jpg 300w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/01\/grafika15-640x403.jpg 640w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><figcaption>Putty&#8217;s terminal after logging in.<\/figcaption><\/figure>\n<p>Now we install Apache. It is a web server with a database and a PHP interpreter. To install the necessary programs we have to update the system. We do this by entering three commands one after the other:<\/p>\n<p><i>sudo apt update<\/i><\/p>\n<p><i>sudo apt upgrade<\/i><\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"656\" height=\"415\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika14.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika14.jpg 656w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika14-300x190.jpg 300w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika14-640x405.jpg 640w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><figcaption>If the installed system is not up-to-date, the update may take up to an hour.<\/figcaption><\/figure>\n<h2>Server configuration<\/h2>\n<p>\nNow we have to install Apache. To do this, simply type the command below into the terminal:\n<\/p>\n<p><i>sudo apt install apache2 -y<\/i><\/p>\n<p>\nWhen we get a message in the terminal that the installation is complete, we can check if the server is working. To do this, enter the local address of your Raspberry &#8211; in my case it is &#8220;192.168.1.2&#8221; &#8211; and confirm with Enter. We should see the following view:\n<\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"207\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika13-1024x265.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika13-1024x265.jpg 1024w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika13-300x78.jpg 300w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika13-768x199.jpg 768w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika13-640x166.jpg 640w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika13.jpg 1357w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption>Correctly functioning website on the server.<\/figcaption><\/figure>\n<p>\nTo be able to read PHP script pages now, we need to install a PHP interpreter. We type into the terminal:\n<\/p>\n<p><i>sudo apt install php -y<\/i><\/p>\n<p>\nOnce the installation is complete, we recommend restarting Apache. To do this, enter the command below:\n<\/p>\n<p><i>sudo service apache2 restart<\/i><\/p>\n<p>\nAfter restarting, install the software with which the databases are to be operated. The way we use the database is trivial, but thanks to the use of databases we can add various conveniences and statistical tools later. To add a database tool together with the software that allows you to manage them in php, we need to type the commands:\n<\/p>\n<p><i>sudo apt install mariadb-server -y<\/i><\/p>\n<p><i>sudo apt install php-mysql -y<\/i><\/p>\n<p>\nIf the installation is successful, we will need to reset the server again for the changes to take effect. Now we have to create a new user for the database. To do this, we need to log in to the default user account root. To log in, we use the following command:\n<\/p>\n<p><i>sudo mysql &#8211;user=root<\/i><\/p>\n<p>\nNow we see that the system console moves to MariaDB, our database interpreter. Let&#8217;s create a new user &#8211; we will call them &#8220;domownik&#8221; with the password &#8220;domek&#8221;.\n<\/p>\n<p>\nCREATE USER &#8216;domownik&#8217;@&#8217;localhost&#8217; IDENTIFIED BY &#8216;domek&#8217;;<\/p>\n<p>\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"659\" height=\"416\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika17.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika17.jpg 659w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika17-300x189.jpg 300w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika17-640x404.jpg 640w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/p>\n<p>\nIn order for our newly created user to be able to manage the databases, we need to give him permissions, so enter the command:\n<\/p>\n<p><i>GRANT ALL PRIVILEGES ON *.* TO &#8216;domownik&#8217;@&#8217;localhost&#8217;;<\/i><\/p>\n<p>\nNow click CTRL +C to exit the program (this shortcut terminates the running process; we can safely use it in other situations as well).\n<\/p>\n<p>\nNow we will install a graphical interpreter to process databases. It is called phpMyAdmin and will make our work with databases much easier. Thanks to the phpMyAdmin software, we can create databases using a convenient graphical interface. For the installation we use the already known command &#8220;sudo apt install&#8221;, but this time we add &#8220;phpmyadmin&#8221; at the end, so that the command looks like this:\n<\/p>\n<p><i>sudo apt install phpmyadmin<\/i><\/p>\n<p>\nThe installer will now start. In the first window we select our environment, i.e. apache2, in the next window we click on &#8220;ok&#8221;, and in the last window we select &#8220;no&#8221;.\n<\/p>\n<p>\nNow let&#8217;s perform one more operation that will give us access to phpMyAdmin under \/phpmyadmin. To do this, type the command:\n<\/p>\n<p><i>sudo ln -s \/usr\/share\/phpmyadmin \/var\/www\/html\/phpmyadmin<\/i><\/p>\n<p>\nFinally, we reset the server and go from the second computer connected to the same network to the address: rpi_local_address\/phpmyadmin (of course we have to enter our real address, in my case 192.168.1.2\/phpmyadmin). We confirm the operation with Enter. Now we should see a screen like below. We will use the data of our &#8220;domownik&#8221; to log in.\n<\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"499\" height=\"520\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika18.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika18.jpg 499w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika18-288x300.jpg 288w\" sizes=\"(max-width: 499px) 100vw, 499px\" \/><figcaption> PhpMyAdmin view.<\/figcaption><\/figure>\n<p>\nNow let&#8217;s create a database. Click on &#8220;New&#8221; in the upper left corner, fill in the fields as below, call the base &#8220;control&#8221; and set the character encoding to utf8_general_ci.\n<\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"784\" height=\"223\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika19.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika19.jpg 784w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika19-300x85.jpg 300w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika19-768x218.jpg 768w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika19-640x182.jpg 640w\" sizes=\"(max-width: 784px) 100vw, 784px\" \/><figcaption>Database creation tool<\/figcaption><\/figure>\n<p>\nWe will now see the table creation tool. Set &#8220;przekazniki&#8221; as the name and choose &#8220;2&#8221; as the number of columns.\n<\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"522\" height=\"185\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika20.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika20.jpg 522w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika20-300x106.jpg 300w\" sizes=\"(max-width: 522px) 100vw, 522px\" \/><figcaption>Table creation tool<\/figcaption><\/figure>\n<p>\nAfter approval, the program will take you to the setting of columns that should be completed as below.\n<\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"205\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika21-1024x263.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika21-1024x263.jpg 1024w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika21-300x77.jpg 300w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika21-768x197.jpg 768w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika21-640x164.jpg 640w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika21.jpg 1462w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption>Correctly filled setting of columns<\/figcaption><\/figure>\n<p>\nOnce you have created the table, click the &#8220;SQL&#8221; button on the top bar and enter the following query into the text field. Then click &#8220;Go&#8221;.\n<\/p>\n<p><i>INSERT INTO `przekazniki`(`przekaznik`, `stan`) VALUES (&#8216;przekaznik1&#8242;,&#8217;0&#8217;), (&#8216;przekaznik2&#8242;,&#8217;0&#8217;), (&#8216;przekaznik3&#8242;,&#8217;0&#8217;), (&#8216;przekaznik4&#8242;,&#8217;0&#8217;)<\/i><\/p>\n<figure>\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"205\" src=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika22-1024x262.jpg\" alt=\" loading=\"lazy\" srcset=\"https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika22-1024x262.jpg 1024w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika22-300x77.jpg 300w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika22-768x197.jpg 768w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika22-1536x394.jpg 1536w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika22-640x164.jpg 640w, https:\/\/botland.store\/blog\/sandbox\/wp-content\/uploads\/2021\/02\/grafika22.jpg 1670w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><figcaption>SQL query<\/figcaption><\/figure>\n<p>\nToday we set up the server, configured the database and created the table that allows us to check the status of the relays. The next part of the guide will help you create a test layout and upload a working website.\n<\/p>\n<p><b>The second part of the guide can be <a href=\"https:\/\/botland.store\/blog\/sandbox\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-2\/\" data-wpel-link=\"internal\">found here<\/a><\/b>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ready-to-implement smart home system possible with Raspberry Pi Zero. Our tutorial comes in three parts available at Botland store blog.<\/p>\n","protected":false},"author":13,"featured_media":42182,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[339,342,21,343,345],"tags":[376,100,402],"class_list":["post-42181","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-electronics","category-programming","category-programowanie","category-raspberry-pi-en","category-smart-home-en","tag-grove-en","tag-raspberry-pi-tag","tag-raspberry-pi-en-tag"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>A simple smart home system for everyone based on Raspberry Pi Zero \u2013 Part 1 - Botland<\/title>\n<meta name=\"description\" content=\"Ready-to-implement smart home system possible with Raspberry Pi Zero. Our tutorial comes in three parts available at Botland store blog.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A simple smart home system for everyone based on Raspberry Pi Zero \u2013 Part 1 - Botland\" \/>\n<meta property=\"og:description\" content=\"Ready-to-implement smart home system possible with Raspberry Pi Zero. Our tutorial comes in three parts available at Botland store blog.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Botland\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/Botland\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-14T06:35:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-04T10:50:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/botland.store\/blog\/wp-content\/uploads\/2022\/07\/rpi1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1510\" \/>\n\t<meta property=\"og:image:height\" content=\"1510\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Marcin Lesi\u0144ski\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marcin Lesi\u0144ski\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/botland.store\\\/blog\\\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/botland.store\\\/blog\\\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\\\/\"},\"author\":{\"name\":\"Marcin Lesi\u0144ski\",\"@id\":\"https:\\\/\\\/botland.com.pl\\\/blog\\\/#\\\/schema\\\/person\\\/802076b13f8a358284688d7634c1bfe7\"},\"headline\":\"A simple smart home system for everyone based on Raspberry Pi Zero \u2013 Part 1\",\"datePublished\":\"2020-09-14T06:35:35+00:00\",\"dateModified\":\"2021-05-04T10:50:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/botland.store\\\/blog\\\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\\\/\"},\"wordCount\":1060,\"publisher\":{\"@id\":\"https:\\\/\\\/botland.com.pl\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/botland.store\\\/blog\\\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/botland.store\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/rpi1.jpg\",\"keywords\":[\"Grove\",\"Raspberry Pi\",\"Raspberry Pi\"],\"articleSection\":[\"Electronics\",\"Programming\",\"Programowanie\",\"Raspberry Pi\",\"Smart home\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/botland.store\\\/blog\\\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\\\/\",\"url\":\"https:\\\/\\\/botland.store\\\/blog\\\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\\\/\",\"name\":\"A simple smart home system for everyone based on Raspberry Pi Zero \u2013 Part 1 - Botland\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/botland.com.pl\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/botland.store\\\/blog\\\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/botland.store\\\/blog\\\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/botland.store\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/rpi1.jpg\",\"datePublished\":\"2020-09-14T06:35:35+00:00\",\"dateModified\":\"2021-05-04T10:50:16+00:00\",\"description\":\"Ready-to-implement smart home system possible with Raspberry Pi Zero. Our tutorial comes in three parts available at Botland store blog.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/botland.store\\\/blog\\\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/botland.store\\\/blog\\\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/botland.store\\\/blog\\\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\\\/#primaryimage\",\"url\":\"https:\\\/\\\/botland.store\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/rpi1.jpg\",\"contentUrl\":\"https:\\\/\\\/botland.store\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/rpi1.jpg\",\"width\":1510,\"height\":1510},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/botland.store\\\/blog\\\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\\\/\\\/botland.store\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A simple smart home system for everyone based on Raspberry Pi Zero \u2013 Part 1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/botland.com.pl\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/botland.com.pl\\\/blog\\\/\",\"name\":\"Botland\",\"description\":\"Blog Raspberry Pi, Arduino, elektronika i robotyka - Botland\",\"publisher\":{\"@id\":\"https:\\\/\\\/botland.com.pl\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/botland.com.pl\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/botland.com.pl\\\/blog\\\/#organization\",\"name\":\"Botland\",\"url\":\"https:\\\/\\\/botland.com.pl\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/botland.com.pl\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/botland.store\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/logo_kolor_WP_2-1.png\",\"contentUrl\":\"https:\\\/\\\/botland.store\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/logo_kolor_WP_2-1.png\",\"width\":250,\"height\":57,\"caption\":\"Botland\"},\"image\":{\"@id\":\"https:\\\/\\\/botland.com.pl\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/facebook.com\\\/Botland\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/botland.com.pl\\\/blog\\\/#\\\/schema\\\/person\\\/802076b13f8a358284688d7634c1bfe7\",\"name\":\"Marcin Lesi\u0144ski\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/botland.store\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/MarcinL-150x150.jpg\",\"url\":\"https:\\\/\\\/botland.store\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/MarcinL-150x150.jpg\",\"contentUrl\":\"https:\\\/\\\/botland.store\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/MarcinL-150x150.jpg\",\"caption\":\"Marcin Lesi\u0144ski\"},\"description\":\"Mi\u0142o\u015bnik elektroniki, druku 3D i nauk stosowanych, swoj\u0105 wiedz\u0119 gromadzi od 14-tego roku \u017cycia. W Botlandzie tworzy projekty i poradniki dla klient\u00f3w, a w wolnym czasie zajmuje si\u0119 automatycznymi uprawami i prototypowaniem. Fan muzyki rockowej i brytyjskiego kina.\",\"url\":\"https:\\\/\\\/botland.store\\\/blog\\\/author\\\/marcin-l\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"A simple smart home system for everyone based on Raspberry Pi Zero \u2013 Part 1 - Botland","description":"Ready-to-implement smart home system possible with Raspberry Pi Zero. Our tutorial comes in three parts available at Botland store blog.","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:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/","og_locale":"en_US","og_type":"article","og_title":"A simple smart home system for everyone based on Raspberry Pi Zero \u2013 Part 1 - Botland","og_description":"Ready-to-implement smart home system possible with Raspberry Pi Zero. Our tutorial comes in three parts available at Botland store blog.","og_url":"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/","og_site_name":"Botland","article_publisher":"https:\/\/facebook.com\/Botland\/","article_published_time":"2020-09-14T06:35:35+00:00","article_modified_time":"2021-05-04T10:50:16+00:00","og_image":[{"width":1510,"height":1510,"url":"https:\/\/botland.store\/blog\/wp-content\/uploads\/2022\/07\/rpi1.jpg","type":"image\/jpeg"}],"author":"Marcin Lesi\u0144ski","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marcin Lesi\u0144ski","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/#article","isPartOf":{"@id":"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/"},"author":{"name":"Marcin Lesi\u0144ski","@id":"https:\/\/botland.com.pl\/blog\/#\/schema\/person\/802076b13f8a358284688d7634c1bfe7"},"headline":"A simple smart home system for everyone based on Raspberry Pi Zero \u2013 Part 1","datePublished":"2020-09-14T06:35:35+00:00","dateModified":"2021-05-04T10:50:16+00:00","mainEntityOfPage":{"@id":"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/"},"wordCount":1060,"publisher":{"@id":"https:\/\/botland.com.pl\/blog\/#organization"},"image":{"@id":"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/#primaryimage"},"thumbnailUrl":"https:\/\/botland.store\/blog\/wp-content\/uploads\/2022\/07\/rpi1.jpg","keywords":["Grove","Raspberry Pi","Raspberry Pi"],"articleSection":["Electronics","Programming","Programowanie","Raspberry Pi","Smart home"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/","url":"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/","name":"A simple smart home system for everyone based on Raspberry Pi Zero \u2013 Part 1 - Botland","isPartOf":{"@id":"https:\/\/botland.com.pl\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/#primaryimage"},"image":{"@id":"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/#primaryimage"},"thumbnailUrl":"https:\/\/botland.store\/blog\/wp-content\/uploads\/2022\/07\/rpi1.jpg","datePublished":"2020-09-14T06:35:35+00:00","dateModified":"2021-05-04T10:50:16+00:00","description":"Ready-to-implement smart home system possible with Raspberry Pi Zero. Our tutorial comes in three parts available at Botland store blog.","breadcrumb":{"@id":"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/#primaryimage","url":"https:\/\/botland.store\/blog\/wp-content\/uploads\/2022\/07\/rpi1.jpg","contentUrl":"https:\/\/botland.store\/blog\/wp-content\/uploads\/2022\/07\/rpi1.jpg","width":1510,"height":1510},{"@type":"BreadcrumbList","@id":"https:\/\/botland.store\/blog\/a-simple-smart-home-system-for-everyone-based-on-raspberry-pi-zero-part-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/botland.store\/blog\/"},{"@type":"ListItem","position":2,"name":"A simple smart home system for everyone based on Raspberry Pi Zero \u2013 Part 1"}]},{"@type":"WebSite","@id":"https:\/\/botland.com.pl\/blog\/#website","url":"https:\/\/botland.com.pl\/blog\/","name":"Botland","description":"Blog Raspberry Pi, Arduino, elektronika i robotyka - Botland","publisher":{"@id":"https:\/\/botland.com.pl\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/botland.com.pl\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/botland.com.pl\/blog\/#organization","name":"Botland","url":"https:\/\/botland.com.pl\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/botland.com.pl\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/botland.store\/blog\/wp-content\/uploads\/2018\/04\/logo_kolor_WP_2-1.png","contentUrl":"https:\/\/botland.store\/blog\/wp-content\/uploads\/2018\/04\/logo_kolor_WP_2-1.png","width":250,"height":57,"caption":"Botland"},"image":{"@id":"https:\/\/botland.com.pl\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/Botland\/"]},{"@type":"Person","@id":"https:\/\/botland.com.pl\/blog\/#\/schema\/person\/802076b13f8a358284688d7634c1bfe7","name":"Marcin Lesi\u0144ski","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/botland.store\/blog\/wp-content\/uploads\/2021\/02\/MarcinL-150x150.jpg","url":"https:\/\/botland.store\/blog\/wp-content\/uploads\/2021\/02\/MarcinL-150x150.jpg","contentUrl":"https:\/\/botland.store\/blog\/wp-content\/uploads\/2021\/02\/MarcinL-150x150.jpg","caption":"Marcin Lesi\u0144ski"},"description":"Mi\u0142o\u015bnik elektroniki, druku 3D i nauk stosowanych, swoj\u0105 wiedz\u0119 gromadzi od 14-tego roku \u017cycia. W Botlandzie tworzy projekty i poradniki dla klient\u00f3w, a w wolnym czasie zajmuje si\u0119 automatycznymi uprawami i prototypowaniem. Fan muzyki rockowej i brytyjskiego kina.","url":"https:\/\/botland.store\/blog\/author\/marcin-l\/"}]}},"_links":{"self":[{"href":"https:\/\/botland.store\/blog\/wp-json\/wp\/v2\/posts\/42181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/botland.store\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/botland.store\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/botland.store\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/botland.store\/blog\/wp-json\/wp\/v2\/comments?post=42181"}],"version-history":[{"count":0,"href":"https:\/\/botland.store\/blog\/wp-json\/wp\/v2\/posts\/42181\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/botland.store\/blog\/wp-json\/wp\/v2\/media\/42182"}],"wp:attachment":[{"href":"https:\/\/botland.store\/blog\/wp-json\/wp\/v2\/media?parent=42181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/botland.store\/blog\/wp-json\/wp\/v2\/categories?post=42181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/botland.store\/blog\/wp-json\/wp\/v2\/tags?post=42181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}