{"id":239,"date":"2021-03-14T20:21:47","date_gmt":"2021-03-14T20:21:47","guid":{"rendered":"https:\/\/andrejacobs.org\/?p=239"},"modified":"2022-04-11T20:24:23","modified_gmt":"2022-04-11T20:24:23","slug":"100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas","status":"publish","type":"post","link":"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/","title":{"rendered":"100 Days of Learning: Day 6 \u2013 Let&#8217;s build our own Lego database using MariaDB in AWS RDS and OpenFaaS"},"content":{"rendered":"\n<p class=\"has-small-font-size\">Photo by <a href=\"https:\/\/unsplash.com\/@lennartschneider?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText\">brickset.com<\/a><\/p>\n\n\n\n<div class=\"wp-block-jetpack-markdown\"><p>Here is my <a href=\"https:\/\/github.com\/andrejacobs\/100DayChallenges\/blob\/main\/2021%20March\/100DaysOfLearning\/100DaysOfLearning.md\">Log book<\/a><\/p>\n<p>In <a href=\"https:\/\/gumroad.com\/l\/serverless-for-everyone-else\">Severless for Everyone Else<\/a> Alex shows an example of using a node.js function that uses <a href=\"https:\/\/www.postgresql.org\/\">Postgre<\/a> as a database.<\/p>\n<p>I am going to see if I can setup MariaDB (MySQL) in my free tier of AWS.<\/p>\n<p>For this little project I want to have a Lego set database. I will be using Python for the function coding (most likely I will be using <a href=\"https:\/\/flask.palletsprojects.com\/en\/1.1.x\/\">Flask<\/a> and <a href=\"https:\/\/www.sqlalchemy.org\/\">SQLalchemy<\/a>).<\/p>\n<p>This learning \/ development will span over a few days depending on how much free time I get.<\/p>\n<p>I want to be able to:<\/p>\n<ul>\n<li>Post new entries and persist them to a MariaDB database hosted in AWS RDS.<\/li>\n<li>Get all entries from the database.<\/li>\n<li>The OpenFaaS functions will be using secrets and environment variables.<\/li>\n<li>Fetch and persist the product image into the table.<\/li>\n<li>Run a scheduled <code>cron<\/code> (I guess) job to do the above (fetch image).<\/li>\n<\/ul>\n<h2>Setting up a MariaDB database in AWS<\/h2>\n<p>First hurdle was trying to log in with my non-root admin user and was asked to change the password. The first thing you must do once you create an AWS account is to create a new admin user that is not the root user account. You should practically never use the root user on AWS. The problem for me was that I setup a strict password policy and it was trial and error (and logging in as root user) before I could reset the expired password. P.S. Symbol did not include the character &gt; that was generated by 1Password.<\/p>\n<p>I will be following the official <a href=\"https:\/\/aws.amazon.com\/products\/databases\/learn\/\">AWS documentation<\/a> and <a href=\"https:\/\/aws.amazon.com\/getting-started\/hands-on\/create-mariadb-db\/\">tutorial for RDS<\/a><\/p>\n<ul>\n<li>Open up the <a href=\"https:\/\/eu-west-2.console.aws.amazon.com\/console\/home?region=eu-west-2\">AWS Console<\/a><\/li>\n<li>I am using the eu-west2 region which is London<\/li>\n<li>Search for RDS and select it<\/li>\n<li>Scrolled down a bit until I found this. Doubled checked the region is correct.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/andrejacobs.org\/wp-content\/uploads\/2021\/03\/rds_create.png\" alt=\"\"><\/p>\n<ul>\n<li>Create database<\/li>\n<li>Select MariaDB as the engine<\/li>\n<li>Select the Template to be Free tier<\/li>\n<li>DB instance identifier: openfaas<\/li>\n<li>Generated the master password in 1Password<\/li>\n<li>DB instance class: db.t2.micro &#8212; 1vCPU, 1 GIB RAM.<\/li>\n<li>Disabled Storage autoscaling<\/li>\n<li>Under Connectivity<\/li>\n<li>Enabled Public Access<\/li>\n<li>Select Create new VPC security group (this should allow my current IP to access the instance)<\/li>\n<li>Entered a name for this new VPC<\/li>\n<li>Additional configuration<\/li>\n<li>Initial database name: openfaasdb<\/li>\n<li>Disabled automatic backups since I won&#8217;t need it for this learning exercise<\/li>\n<li>Create Database!<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/andrejacobs.org\/wp-content\/uploads\/2021\/03\/rds1.png\" alt=\"\"><\/p>\n<ul>\n<li>Now we just sit and wait till it has been created.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/andrejacobs.org\/wp-content\/uploads\/2021\/03\/rds2.png\" alt=\"\"><\/p>\n<h2>Installing MySQLWorkbench as GUI<\/h2>\n<p>Incase you did not know, MySQL was acquired by Oracle a good while ago. MariaDB sprung up as a fork from MySQL (we won&#8217;t get into the politics here).<\/p>\n<p>The best GUI I have found to use on Mac with MySQL \/ MariaDB is MySQLWorkbench (owned by Oracle).<\/p>\n<p>You can download the installer <a href=\"https:\/\/dev.mysql.com\/downloads\/workbench\/\">here<\/a>. Select &quot;No thanks, just start my download.&quot;<\/p>\n<ul>\n<li>Add a new connection. + button next to MySQL Connections.<\/li>\n<li>On the RDS console, select the newly created database.<\/li>\n<li>Look for the Endpoint and Port values.<\/li>\n<li>Copy the Endpoint value and paste it as the Hostname in MySQLWorkbench.<\/li>\n<li>Do the same with the port if you changed the default to not be 3306.<\/li>\n<li>Enter the username (default is admin).<\/li>\n<li>Store the password in your keychain.<\/li>\n<li>Set a name for this new connection: openfaasdb &#8211; amazon rds<\/li>\n<li>Click the Test Connection button.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/andrejacobs.org\/wp-content\/uploads\/2021\/03\/workbench_error.png\" alt=\"\"><\/p>\n<ul>\n<li>Continue Anyway. You get this warning whenever you connect to MariaDB servers.<\/li>\n<li>If the connection succeeded then you will get the following message.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/andrejacobs.org\/wp-content\/uploads\/2021\/03\/workbench_succeed.png\" alt=\"\"><\/p>\n<ul>\n<li>Click Ok<\/li>\n<li>Double click the new connection. Get presented with the MySQL warning again. Select the &quot;do not bother me about this BS again&quot;.<\/li>\n<li>Select the Schemas tab.<\/li>\n<li>Right click on the new database (mine from the example is openfaasdb) and Set as Default Schema. This way in queries I don&#8217;t have to specify the schema.<\/li>\n<\/ul>\n<h2>Create the database table<\/h2>\n<p>Open a new query in MySQLWorkbench and paste the following.<\/p>\n<pre><code class=\"language-sql\">CREATE TABLE `openfaasdb`.`legosets` (\n  `pkID` INT NOT NULL AUTO_INCREMENT,\n  `LegoID` INT NOT NULL,\n  `Description` VARCHAR(200) NULL,\n  `ProductURL` VARCHAR(4096) NULL,\n  `ImageURL` VARCHAR(4096) NULL,\n  PRIMARY KEY (`pkID`),\n  UNIQUE INDEX `LegoID_UNIQUE` (`LegoID` ASC));\n<\/code><\/pre>\n<p>Execute the query and with a bit of luck the new table has been created.<\/p>\n<p>Let us populate some sample data into the table. Again execute the following queries.<\/p>\n<pre><code class=\"language-sql\">INSERT INTO `openfaasdb`.`legosets` (`LegoID`, `Description`, `ProductURL`, `ImageURL`) VALUES ('21322', 'Pirates of Barracuda Bay', 'https:\/\/www.lego.com\/en-gb\/product\/pirates-of-barracuda-bay-21322', 'https:\/\/live.staticflickr.com\/65535\/49698377257_be3f773feb_b.jpg');\nINSERT INTO `openfaasdb`.`legosets` (`LegoID`, `Description`, `ProductURL`, `ImageURL`) VALUES ('21325', 'Medieval Blacksmith', 'https:\/\/www.lego.com\/en-gb\/product\/medieval-blacksmith-21325', 'https:\/\/images.brickset.com\/sets\/AdditionalImages\/21325-1\/21325-1_95850.jpg');\n<\/code><\/pre>\n<p>Note: I will later be altering the table to include a BLOB to store a cached version of the product Image (download and store ImageURL)<\/p>\n<p><strong>That is a wrap for tonight.<\/strong> Tomorrow I need to setup my Mac for Python 3 development first and then explore the <a href=\"https:\/\/github.com\/openfaas\/python-flask-template\/tree\/master\/template\/python3-flask\">OpenFaaS Flask template<\/a> and possibly see how to add <a href=\"https:\/\/www.sqlalchemy.org\/\">SQLalchemy<\/a> as a dependency.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Photo by brickset.com [&#8230;]<\/p>\n<p><a class=\"understrap-read-more-link\" href=\"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":247,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[37],"tags":[38,39,36],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>100 Days of Learning: Day 6 \u2013 Let&#039;s build our own Lego database using MariaDB in AWS RDS and OpenFaaS - Andr\u00e9 Jacobs<\/title>\n<meta name=\"description\" content=\"Day 6 of 100 complete. Today I explore setting up a MariaDB database hosted by AWS RDS. The plan is to create a small lego database using OpenFaaS.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"100 Days of Learning: Day 6 \u2013 Let&#039;s build our own Lego database using MariaDB in AWS RDS and OpenFaaS - Andr\u00e9 Jacobs\" \/>\n<meta property=\"og:description\" content=\"Day 6 of 100 complete. Today I explore setting up a MariaDB database hosted by AWS RDS. The plan is to create a small lego database using OpenFaaS.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/\" \/>\n<meta property=\"og:site_name\" content=\"Andr\u00e9 Jacobs\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-14T20:21:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-11T20:24:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/andrejacobs.org\/wp-content\/uploads\/2021\/03\/49697537923_c9a6e91e56_c.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"799\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Andr\u00e9 Jacobs\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@andrejacobs81\" \/>\n<meta name=\"twitter:site\" content=\"@andrejacobs81\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andr\u00e9 Jacobs\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/\"},\"author\":{\"name\":\"Andr\u00e9 Jacobs\",\"@id\":\"https:\/\/andrejacobs.org\/#\/schema\/person\/3d38360883015e883c80c2fb875c5a68\"},\"headline\":\"100 Days of Learning: Day 6 \u2013 Let&#8217;s build our own Lego database using MariaDB in AWS RDS and OpenFaaS\",\"datePublished\":\"2021-03-14T20:21:47+00:00\",\"dateModified\":\"2022-04-11T20:24:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/\"},\"wordCount\":749,\"publisher\":{\"@id\":\"https:\/\/andrejacobs.org\/#\/schema\/person\/3d38360883015e883c80c2fb875c5a68\"},\"keywords\":[\"AWS\",\"MariaDB\",\"OpenFaaS\"],\"articleSection\":[\"100 Days Challenge\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/\",\"url\":\"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/\",\"name\":\"100 Days of Learning: Day 6 \u2013 Let's build our own Lego database using MariaDB in AWS RDS and OpenFaaS - Andr\u00e9 Jacobs\",\"isPartOf\":{\"@id\":\"https:\/\/andrejacobs.org\/#website\"},\"datePublished\":\"2021-03-14T20:21:47+00:00\",\"dateModified\":\"2022-04-11T20:24:23+00:00\",\"description\":\"Day 6 of 100 complete. Today I explore setting up a MariaDB database hosted by AWS RDS. The plan is to create a small lego database using OpenFaaS.\",\"breadcrumb\":{\"@id\":\"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/andrejacobs.org\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"100 Days of Learning: Day 6 \u2013 Let&#8217;s build our own Lego database using MariaDB in AWS RDS and OpenFaaS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/andrejacobs.org\/#website\",\"url\":\"https:\/\/andrejacobs.org\/\",\"name\":\"Andr\u00e9 Jacobs\",\"description\":\"iOS Development, Electronics, Robotics, Artificial Intelligence, Business and Health\",\"publisher\":{\"@id\":\"https:\/\/andrejacobs.org\/#\/schema\/person\/3d38360883015e883c80c2fb875c5a68\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/andrejacobs.org\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/andrejacobs.org\/#\/schema\/person\/3d38360883015e883c80c2fb875c5a68\",\"name\":\"Andr\u00e9 Jacobs\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/andrejacobs.org\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/andrejacobs.org\/wp-content\/uploads\/2019\/03\/andre_jacobs.jpg\",\"contentUrl\":\"https:\/\/andrejacobs.org\/wp-content\/uploads\/2019\/03\/andre_jacobs.jpg\",\"width\":450,\"height\":450,\"caption\":\"Andr\u00e9 Jacobs\"},\"logo\":{\"@id\":\"https:\/\/andrejacobs.org\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/andrejacobs.org\",\"https:\/\/www.youtube.com\/channel\/UCzqXvnd_UJ3sAzQkQBD-IVw\"],\"url\":\"https:\/\/andrejacobs.org\/author\/andre\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"100 Days of Learning: Day 6 \u2013 Let's build our own Lego database using MariaDB in AWS RDS and OpenFaaS - Andr\u00e9 Jacobs","description":"Day 6 of 100 complete. Today I explore setting up a MariaDB database hosted by AWS RDS. The plan is to create a small lego database using OpenFaaS.","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:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/","og_locale":"en_GB","og_type":"article","og_title":"100 Days of Learning: Day 6 \u2013 Let's build our own Lego database using MariaDB in AWS RDS and OpenFaaS - Andr\u00e9 Jacobs","og_description":"Day 6 of 100 complete. Today I explore setting up a MariaDB database hosted by AWS RDS. The plan is to create a small lego database using OpenFaaS.","og_url":"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/","og_site_name":"Andr\u00e9 Jacobs","article_published_time":"2021-03-14T20:21:47+00:00","article_modified_time":"2022-04-11T20:24:23+00:00","og_image":[{"width":799,"height":630,"url":"https:\/\/andrejacobs.org\/wp-content\/uploads\/2021\/03\/49697537923_c9a6e91e56_c.jpg","type":"image\/jpeg"}],"author":"Andr\u00e9 Jacobs","twitter_card":"summary_large_image","twitter_creator":"@andrejacobs81","twitter_site":"@andrejacobs81","twitter_misc":{"Written by":"Andr\u00e9 Jacobs","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/#article","isPartOf":{"@id":"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/"},"author":{"name":"Andr\u00e9 Jacobs","@id":"https:\/\/andrejacobs.org\/#\/schema\/person\/3d38360883015e883c80c2fb875c5a68"},"headline":"100 Days of Learning: Day 6 \u2013 Let&#8217;s build our own Lego database using MariaDB in AWS RDS and OpenFaaS","datePublished":"2021-03-14T20:21:47+00:00","dateModified":"2022-04-11T20:24:23+00:00","mainEntityOfPage":{"@id":"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/"},"wordCount":749,"publisher":{"@id":"https:\/\/andrejacobs.org\/#\/schema\/person\/3d38360883015e883c80c2fb875c5a68"},"keywords":["AWS","MariaDB","OpenFaaS"],"articleSection":["100 Days Challenge"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/","url":"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/","name":"100 Days of Learning: Day 6 \u2013 Let's build our own Lego database using MariaDB in AWS RDS and OpenFaaS - Andr\u00e9 Jacobs","isPartOf":{"@id":"https:\/\/andrejacobs.org\/#website"},"datePublished":"2021-03-14T20:21:47+00:00","dateModified":"2022-04-11T20:24:23+00:00","description":"Day 6 of 100 complete. Today I explore setting up a MariaDB database hosted by AWS RDS. The plan is to create a small lego database using OpenFaaS.","breadcrumb":{"@id":"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/andrejacobs.org\/100-days-challenge\/100-days-of-learning-day-6-lets-build-our-own-lego-database-using-mariadb-in-aws-rds-and-openfaas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/andrejacobs.org\/"},{"@type":"ListItem","position":2,"name":"100 Days of Learning: Day 6 \u2013 Let&#8217;s build our own Lego database using MariaDB in AWS RDS and OpenFaaS"}]},{"@type":"WebSite","@id":"https:\/\/andrejacobs.org\/#website","url":"https:\/\/andrejacobs.org\/","name":"Andr\u00e9 Jacobs","description":"iOS Development, Electronics, Robotics, Artificial Intelligence, Business and Health","publisher":{"@id":"https:\/\/andrejacobs.org\/#\/schema\/person\/3d38360883015e883c80c2fb875c5a68"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/andrejacobs.org\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/andrejacobs.org\/#\/schema\/person\/3d38360883015e883c80c2fb875c5a68","name":"Andr\u00e9 Jacobs","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/andrejacobs.org\/#\/schema\/person\/image\/","url":"https:\/\/andrejacobs.org\/wp-content\/uploads\/2019\/03\/andre_jacobs.jpg","contentUrl":"https:\/\/andrejacobs.org\/wp-content\/uploads\/2019\/03\/andre_jacobs.jpg","width":450,"height":450,"caption":"Andr\u00e9 Jacobs"},"logo":{"@id":"https:\/\/andrejacobs.org\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/andrejacobs.org","https:\/\/www.youtube.com\/channel\/UCzqXvnd_UJ3sAzQkQBD-IVw"],"url":"https:\/\/andrejacobs.org\/author\/andre\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/andrejacobs.org\/wp-content\/uploads\/2021\/03\/49697537923_c9a6e91e56_c.jpg","_links":{"self":[{"href":"https:\/\/andrejacobs.org\/wp-json\/wp\/v2\/posts\/239"}],"collection":[{"href":"https:\/\/andrejacobs.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/andrejacobs.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/andrejacobs.org\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/andrejacobs.org\/wp-json\/wp\/v2\/comments?post=239"}],"version-history":[{"count":3,"href":"https:\/\/andrejacobs.org\/wp-json\/wp\/v2\/posts\/239\/revisions"}],"predecessor-version":[{"id":248,"href":"https:\/\/andrejacobs.org\/wp-json\/wp\/v2\/posts\/239\/revisions\/248"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/andrejacobs.org\/wp-json\/wp\/v2\/media\/247"}],"wp:attachment":[{"href":"https:\/\/andrejacobs.org\/wp-json\/wp\/v2\/media?parent=239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andrejacobs.org\/wp-json\/wp\/v2\/categories?post=239"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andrejacobs.org\/wp-json\/wp\/v2\/tags?post=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}