{"id":845,"date":"2012-11-27T09:01:52","date_gmt":"2012-11-27T09:01:52","guid":{"rendered":"http:\/\/178.62.14.192\/?p=845"},"modified":"2012-11-27T09:01:52","modified_gmt":"2012-11-27T09:01:52","slug":"getting-started-with-databases-on-the-pi-with-sqlite-reblog","status":"publish","type":"post","link":"https:\/\/www.recantha.co.uk\/blog\/?p=845","title":{"rendered":"Getting started with Databases on the Pi with SQLite (reblog)"},"content":{"rendered":"<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone alignleft\" src=\"https:\/\/i0.wp.com\/2.bp.blogspot.com\/-i-_vH-mylKg\/ULL7faHH-cI\/AAAAAAAAFro\/-OS7n4dKwmk\/s1600\/sqlite370_banner.gif?resize=220%2C101\" alt=\"\" width=\"220\" height=\"101\" \/>An excellent step-by-step blog post about installing and using SQLite. Further blog posts will cover how to use the database in PHP. I&#8217;ll be keeping an eye on this in my quest to learn my way around PHP!<\/p>\n<p><a href=\"http:\/\/www.raspberrypiblog.com\/2012\/11\/getting-started-with-databases-on-pi.html\">An Unofficial Raspberry Pi Blog: Getting started with Databases on the Pi with SQLite<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>An excellent step-by-step blog post about installing and using SQLite. Further blog posts will cover how to use the database in PHP. I&#8217;ll be keeping an eye on this in my quest to learn my way around PHP! An Unofficial&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"https:\/\/www.recantha.co.uk\/blog\/?p=845\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[54,51],"tags":[],"class_list":["post-845","post","type-post","status-publish","format-standard","hentry","category-accessories","category-tutorials"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Getting started with Databases on the Pi with SQLite (reblog) - Raspberry Pi Pod<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.recantha.co.uk\/blog\/?p=845\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Getting started with Databases on the Pi with SQLite (reblog) - Raspberry Pi Pod\" \/>\n<meta property=\"og:description\" content=\"An excellent step-by-step blog post about installing and using SQLite. Further blog posts will cover how to use the database in PHP. I&#8217;ll be keeping an eye on this in my quest to learn my way around PHP! An Unofficial&hellip;Read more &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.recantha.co.uk\/blog\/?p=845\" \/>\n<meta property=\"og:site_name\" content=\"Raspberry Pi Pod\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/recantha\/\" \/>\n<meta property=\"article:published_time\" content=\"2012-11-27T09:01:52+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/2.bp.blogspot.com\/-i-_vH-mylKg\/ULL7faHH-cI\/AAAAAAAAFro\/-OS7n4dKwmk\/s1600\/sqlite370_banner.gif\" \/>\n<meta name=\"author\" content=\"Michael Horne\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@recantha\" \/>\n<meta name=\"twitter:site\" content=\"@recantha\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Horne\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=845#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=845\"},\"author\":{\"name\":\"Michael Horne\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/person\/c27c4ef2ee1c18b130f1fcd5dcdbb263\"},\"headline\":\"Getting started with Databases on the Pi with SQLite (reblog)\",\"datePublished\":\"2012-11-27T09:01:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=845\"},\"wordCount\":63,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=845#primaryimage\"},\"thumbnailUrl\":\"http:\/\/2.bp.blogspot.com\/-i-_vH-mylKg\/ULL7faHH-cI\/AAAAAAAAFro\/-OS7n4dKwmk\/s1600\/sqlite370_banner.gif\",\"articleSection\":[\"Accessories\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.recantha.co.uk\/blog\/?p=845#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=845\",\"url\":\"https:\/\/www.recantha.co.uk\/blog\/?p=845\",\"name\":\"Getting started with Databases on the Pi with SQLite (reblog) - Raspberry Pi Pod\",\"isPartOf\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=845#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=845#primaryimage\"},\"thumbnailUrl\":\"http:\/\/2.bp.blogspot.com\/-i-_vH-mylKg\/ULL7faHH-cI\/AAAAAAAAFro\/-OS7n4dKwmk\/s1600\/sqlite370_banner.gif\",\"datePublished\":\"2012-11-27T09:01:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=845#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.recantha.co.uk\/blog\/?p=845\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=845#primaryimage\",\"url\":\"http:\/\/2.bp.blogspot.com\/-i-_vH-mylKg\/ULL7faHH-cI\/AAAAAAAAFro\/-OS7n4dKwmk\/s1600\/sqlite370_banner.gif\",\"contentUrl\":\"http:\/\/2.bp.blogspot.com\/-i-_vH-mylKg\/ULL7faHH-cI\/AAAAAAAAFro\/-OS7n4dKwmk\/s1600\/sqlite370_banner.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/?p=845#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.recantha.co.uk\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Getting started with Databases on the Pi with SQLite (reblog)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#website\",\"url\":\"https:\/\/www.recantha.co.uk\/blog\/\",\"name\":\"Raspberry Pi Pod\",\"description\":\"Experiences with the Raspberry Pi micro computer and microcontroller\",\"publisher\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.recantha.co.uk\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#organization\",\"name\":\"Raspberry Pi Pod\",\"url\":\"https:\/\/www.recantha.co.uk\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2016\/03\/cropped-PiPod-Logo-v3.png?fit=800%2C337&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2016\/03\/cropped-PiPod-Logo-v3.png?fit=800%2C337&ssl=1\",\"width\":800,\"height\":337,\"caption\":\"Raspberry Pi Pod\"},\"image\":{\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/recantha\/\",\"https:\/\/x.com\/recantha\",\"https:\/\/www.linkedin.com\/in\/recantha\/\",\"https:\/\/www.youtube.com\/channel\/UCK4F9blabxzmk8Inzhs8tpg\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/person\/c27c4ef2ee1c18b130f1fcd5dcdbb263\",\"name\":\"Michael Horne\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/479778b0677caadde0ceb54c4129804ef674914607e3ed0998808148357d10d8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/479778b0677caadde0ceb54c4129804ef674914607e3ed0998808148357d10d8?s=96&d=mm&r=g\",\"caption\":\"Michael Horne\"},\"url\":\"https:\/\/www.recantha.co.uk\/blog\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Getting started with Databases on the Pi with SQLite (reblog) - Raspberry Pi Pod","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:\/\/www.recantha.co.uk\/blog\/?p=845","og_locale":"en_US","og_type":"article","og_title":"Getting started with Databases on the Pi with SQLite (reblog) - Raspberry Pi Pod","og_description":"An excellent step-by-step blog post about installing and using SQLite. Further blog posts will cover how to use the database in PHP. I&#8217;ll be keeping an eye on this in my quest to learn my way around PHP! An Unofficial&hellip;Read more &rarr;","og_url":"https:\/\/www.recantha.co.uk\/blog\/?p=845","og_site_name":"Raspberry Pi Pod","article_publisher":"https:\/\/www.facebook.com\/recantha\/","article_published_time":"2012-11-27T09:01:52+00:00","og_image":[{"url":"http:\/\/2.bp.blogspot.com\/-i-_vH-mylKg\/ULL7faHH-cI\/AAAAAAAAFro\/-OS7n4dKwmk\/s1600\/sqlite370_banner.gif","type":"","width":"","height":""}],"author":"Michael Horne","twitter_card":"summary_large_image","twitter_creator":"@recantha","twitter_site":"@recantha","twitter_misc":{"Written by":"Michael Horne"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.recantha.co.uk\/blog\/?p=845#article","isPartOf":{"@id":"https:\/\/www.recantha.co.uk\/blog\/?p=845"},"author":{"name":"Michael Horne","@id":"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/person\/c27c4ef2ee1c18b130f1fcd5dcdbb263"},"headline":"Getting started with Databases on the Pi with SQLite (reblog)","datePublished":"2012-11-27T09:01:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.recantha.co.uk\/blog\/?p=845"},"wordCount":63,"commentCount":0,"publisher":{"@id":"https:\/\/www.recantha.co.uk\/blog\/#organization"},"image":{"@id":"https:\/\/www.recantha.co.uk\/blog\/?p=845#primaryimage"},"thumbnailUrl":"http:\/\/2.bp.blogspot.com\/-i-_vH-mylKg\/ULL7faHH-cI\/AAAAAAAAFro\/-OS7n4dKwmk\/s1600\/sqlite370_banner.gif","articleSection":["Accessories","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.recantha.co.uk\/blog\/?p=845#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.recantha.co.uk\/blog\/?p=845","url":"https:\/\/www.recantha.co.uk\/blog\/?p=845","name":"Getting started with Databases on the Pi with SQLite (reblog) - Raspberry Pi Pod","isPartOf":{"@id":"https:\/\/www.recantha.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.recantha.co.uk\/blog\/?p=845#primaryimage"},"image":{"@id":"https:\/\/www.recantha.co.uk\/blog\/?p=845#primaryimage"},"thumbnailUrl":"http:\/\/2.bp.blogspot.com\/-i-_vH-mylKg\/ULL7faHH-cI\/AAAAAAAAFro\/-OS7n4dKwmk\/s1600\/sqlite370_banner.gif","datePublished":"2012-11-27T09:01:52+00:00","breadcrumb":{"@id":"https:\/\/www.recantha.co.uk\/blog\/?p=845#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.recantha.co.uk\/blog\/?p=845"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.recantha.co.uk\/blog\/?p=845#primaryimage","url":"http:\/\/2.bp.blogspot.com\/-i-_vH-mylKg\/ULL7faHH-cI\/AAAAAAAAFro\/-OS7n4dKwmk\/s1600\/sqlite370_banner.gif","contentUrl":"http:\/\/2.bp.blogspot.com\/-i-_vH-mylKg\/ULL7faHH-cI\/AAAAAAAAFro\/-OS7n4dKwmk\/s1600\/sqlite370_banner.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.recantha.co.uk\/blog\/?p=845#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.recantha.co.uk\/blog"},{"@type":"ListItem","position":2,"name":"Getting started with Databases on the Pi with SQLite (reblog)"}]},{"@type":"WebSite","@id":"https:\/\/www.recantha.co.uk\/blog\/#website","url":"https:\/\/www.recantha.co.uk\/blog\/","name":"Raspberry Pi Pod","description":"Experiences with the Raspberry Pi micro computer and microcontroller","publisher":{"@id":"https:\/\/www.recantha.co.uk\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.recantha.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.recantha.co.uk\/blog\/#organization","name":"Raspberry Pi Pod","url":"https:\/\/www.recantha.co.uk\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2016\/03\/cropped-PiPod-Logo-v3.png?fit=800%2C337&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2016\/03\/cropped-PiPod-Logo-v3.png?fit=800%2C337&ssl=1","width":800,"height":337,"caption":"Raspberry Pi Pod"},"image":{"@id":"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/recantha\/","https:\/\/x.com\/recantha","https:\/\/www.linkedin.com\/in\/recantha\/","https:\/\/www.youtube.com\/channel\/UCK4F9blabxzmk8Inzhs8tpg"]},{"@type":"Person","@id":"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/person\/c27c4ef2ee1c18b130f1fcd5dcdbb263","name":"Michael Horne","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.recantha.co.uk\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/479778b0677caadde0ceb54c4129804ef674914607e3ed0998808148357d10d8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/479778b0677caadde0ceb54c4129804ef674914607e3ed0998808148357d10d8?s=96&d=mm&r=g","caption":"Michael Horne"},"url":"https:\/\/www.recantha.co.uk\/blog\/?author=1"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2RsaV-dD","jetpack-related-posts":[{"id":18890,"url":"https:\/\/www.recantha.co.uk\/blog\/?p=18890","url_meta":{"origin":845,"position":0},"title":"Dundee student resurrects Doctor Who&#8217;s K9 with a Raspberry Pi","author":"Michael Horne","date":"4 June 2018","format":false,"excerpt":"Gary Taylor\u00a0from Dundee's Abertay University found an original, but water-damaged, K9 BBC TV prop in his University's lab and, because he is an enormous Doctor Who and robotics fan, wanted to resurrect it. This formed the basis for his final year dissertation: \"Creating an Autonomous Robot Utilising Raspberry Pi, Arduino,\u2026","rel":"","context":"In &quot;Bluetooth&quot;","block_context":{"text":"Bluetooth","link":"https:\/\/www.recantha.co.uk\/blog\/?cat=82"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2018\/06\/K9-Final-Model-with-sensors.png?fit=1000%2C891&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2018\/06\/K9-Final-Model-with-sensors.png?fit=1000%2C891&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2018\/06\/K9-Final-Model-with-sensors.png?fit=1000%2C891&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.recantha.co.uk\/blog\/wp-content\/uploads\/2018\/06\/K9-Final-Model-with-sensors.png?fit=1000%2C891&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":6475,"url":"https:\/\/www.recantha.co.uk\/blog\/?p=6475","url_meta":{"origin":845,"position":1},"title":"Install MongoDB on your #RaspberryPi","author":"Michael Horne","date":"14 October 2013","format":false,"excerpt":"Chris Mobberley has written a tutorial on getting MongoDB (a NoSQL database server) up and running on your Pi. Read it here","rel":"","context":"In &quot;Databases&quot;","block_context":{"text":"Databases","link":"https:\/\/www.recantha.co.uk\/blog\/?cat=14"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":12451,"url":"https:\/\/www.recantha.co.uk\/blog\/?p=12451","url_meta":{"origin":845,"position":2},"title":"Learn about Big Data with Hadoop on the Raspberry Pi","author":"Michael Horne","date":"27 April 2015","format":false,"excerpt":"Carsten M\u00f6nning over at the SAP Community Network has written the start of an intriguing series of blog posts on creating a Hadoop cluster with several Raspberry Pi 2s. This initial post just covers setting up Hadoop on a single Pi, and future instalments will go into further depth on\u2026","rel":"","context":"In &quot;Big Data&quot;","block_context":{"text":"Big Data","link":"https:\/\/www.recantha.co.uk\/blog\/?cat=72"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/scn.sap.com\/servlet\/JiveServlet\/showImage\/38-124611-692706\/WebUI_NodeOverview2.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/scn.sap.com\/servlet\/JiveServlet\/showImage\/38-124611-692706\/WebUI_NodeOverview2.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/scn.sap.com\/servlet\/JiveServlet\/showImage\/38-124611-692706\/WebUI_NodeOverview2.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/scn.sap.com\/servlet\/JiveServlet\/showImage\/38-124611-692706\/WebUI_NodeOverview2.png?resize=700%2C400 2x"},"classes":[]},{"id":1878,"url":"https:\/\/www.recantha.co.uk\/blog\/?p=1878","url_meta":{"origin":845,"position":3},"title":"MySQL for Beginners on the #RaspberryPi","author":"Michael Horne","date":"5 February 2013","format":false,"excerpt":"If you know nothing about databases, except that you know you want to\u00a0use\u00a0them, this video tutorial is for you. Richard Wenner has posted an excellent, very comprehensive tutorial on MySQL for the Raspberry Pi on YouTube. This 40-minute video covers installation of MySQL and using it on the command line\u2026","rel":"","context":"In &quot;Databases&quot;","block_context":{"text":"Databases","link":"https:\/\/www.recantha.co.uk\/blog\/?cat=14"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":13413,"url":"https:\/\/www.recantha.co.uk\/blog\/?p=13413","url_meta":{"origin":845,"position":4},"title":"Make your own weather station with some sensors and a Raspberry Pi","author":"Michael Horne","date":"20 September 2015","format":false,"excerpt":"Jeremy Morgan\u00a0has recently been tinkering with a bunch of sensors attached to a Raspberry Pi, out of which he has made a 'weather station'. The station measures temperature (several different ways!), humidity, barometric (atmospheric) pressure and light levels\/luminosity (lux). He has now written up the whole thing as a tutorial\u2026","rel":"","context":"In &quot;Accessories&quot;","block_context":{"text":"Accessories","link":"https:\/\/www.recantha.co.uk\/blog\/?cat=54"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.jeremymorgan.com\/images\/raspberry-pi-2-weather-station\/raspberry-pi-weather-station-00.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jeremymorgan.com\/images\/raspberry-pi-2-weather-station\/raspberry-pi-weather-station-00.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.jeremymorgan.com\/images\/raspberry-pi-2-weather-station\/raspberry-pi-weather-station-00.jpg?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":6544,"url":"https:\/\/www.recantha.co.uk\/blog\/?p=6544","url_meta":{"origin":845,"position":5},"title":"Install PostgreSQL database engine on your #RaspberryPi","author":"Michael Horne","date":"19 October 2013","format":false,"excerpt":"Chris Mobberley has been looking at PostgreSQL and has found a simple way to get up-and-running. Read about it here","rel":"","context":"In &quot;Databases&quot;","block_context":{"text":"Databases","link":"https:\/\/www.recantha.co.uk\/blog\/?cat=14"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts\/845","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=845"}],"version-history":[{"count":0,"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts\/845\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.recantha.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}