{"id":379,"date":"2021-03-04T19:12:00","date_gmt":"2021-03-04T10:12:00","guid":{"rendered":"https:\/\/sakae-shokai.com\/?p=379"},"modified":"2021-03-03T18:13:56","modified_gmt":"2021-03-03T09:13:56","slug":"esp32%e3%80%80bme680%e3%81%a7%e6%b8%ac%e5%ae%9a%e3%81%97%e3%81%9f%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92mariadb%e3%81%ab%e3%81%a8%e3%81%b0%e3%81%99%e3%80%80%e3%81%9d%e3%81%ae%ef%bc%92","status":"publish","type":"post","link":"https:\/\/sakae-shokai.com\/wordpress\/?p=379","title":{"rendered":"ESP32\u3000BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059\u3000\u305d\u306e\uff12"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u5148\u65e5BME680\u306e\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u98db\u3070\u3057\u307e\u3057\u305f\u304c\u3001\u30b9\u30bf\u30f3\u30c9\u30a2\u30ed\u30f3\u3067\u81ea\u52d5\u6e2c\u5b9a\u3067\u304d\u308b\u3088\u3046\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f4\u65b0\u3057\u307e\u3057\u305f\u3002\u307e\u305f\u3001Wi-Fi\u306b\u63a5\u7d9a\u3057\u3066\u3044\u308b\u969b\u306b\uff2c\uff25\uff24\u3092\u70b9\u706f\u3055\u305b\u308b\u3053\u3068\u3068\u3057\u307e\u3057\u305f\u3002\u30d4\u30f3\uff14\u756a\u306b\u30d7\u30eb\u30a2\u30c3\u30d7\u62b5\u6297\u3092\u4ecb\u3057\u3066\uff2c\uff25\uff24\u3092\u63a5\u7d9a\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"768\" src=\"https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/03\/D51D164C-A4FE-4F57-AE8F-E806E8FBC100-1024x768.jpeg\" alt=\"\" class=\"wp-image-383\" srcset=\"https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/03\/D51D164C-A4FE-4F57-AE8F-E806E8FBC100-1024x768.jpeg 1024w, https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/03\/D51D164C-A4FE-4F57-AE8F-E806E8FBC100-300x225.jpeg 300w, https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/03\/D51D164C-A4FE-4F57-AE8F-E806E8FBC100-768x576.jpeg 768w, https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/03\/D51D164C-A4FE-4F57-AE8F-E806E8FBC100-1536x1152.jpeg 1536w, https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/03\/D51D164C-A4FE-4F57-AE8F-E806E8FBC100.jpeg 1920w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><figcaption>\u5de6\u4e0a\u306bLED\u3092\u3064\u3051\u3066\u3044\u307e\u3059Wi-Fi\u63a5\u7d9a\u3067\u70b9\u706f\u3057\u307e\u3059\u3002<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0b\u304c\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u3059\u3002\u30d6\u30fc\u30c8\u3057\u305f\u969b\u306b\u81ea\u52d5\u7684\u306b\u8d70\u3089\u305b\u308b\u305f\u3081\u306b\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u540d\u306fmain.py\u306b\u3057\u3066\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:python decode:true \" title=\"main.py\" >from machine import Pin,SoftI2C\nfrom bme680 import *\nimport ntptime\nimport utime\nimport ujson\nimport urequests\n\nUTC_OFFSET=9\np21 = Pin(21, Pin.IN, Pin.PULL_UP)\np23 = Pin(23, Pin.IN, Pin.PULL_UP)\nled = Pin(4, Pin.OUT)\ni2c = SoftI2C(scl=Pin(21), sda=Pin(23))\n\ndef do_connect():\n    import network\n    wlan = network.WLAN(network.STA_IF)\n    wlan.active(True)\n    if not wlan.isconnected():\n        print('connecting to network...')\n        wlan.connect('essid', 'password')\n        while not wlan.isconnected():\n            pass\n    print('network config:', wlan.ifconfig())\n    led.value(1)\n\n     \ndef get_jst():\n    sleep_ms(1000)\n    ntptime.settime()\n    tm=utime.localtime(utime.mktime(utime.localtime())+UTC_OFFSET*3600)\n    jst = str(tm[0])+'\/'+str(tm[1])+'\/'+str(tm[2])+' '+str(tm[3])+':'+str(tm[4])+':'+str(tm[5])\n    return(jst)\n     \ndo_connect()\nprint(get_jst())\n\nwhile True:\n  try:\n    bme = BME680_I2C(i2c=i2c) \n    temp = str(round(bme.temperature, 2))\n    hum = str(round(bme.humidity, 2))\n    pres = str(round(bme.pressure, 2))\n    gas = str(round(bme.gas\/1000, 2))\n\n    dict = {\n            \"temp_value\":temp,\n            \"hum_value\":hum,\n            \"pres_value\":pres,\n            \"gas_value\":gas\n            }\n    response = urequests.post(\n            'https:\/\/***url***\/datarcv.php',\n            data=ujson.dumps(dict).encode(\"utf-8\"),\n                headers={'Content-Type': 'application\/json'}\n            )\n    print  (response.text)\n  except OSError as e:\n    print('Failed to read sensor.')\n \n  sleep(10)<\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u306e\u901a\u308aWi-Fi\u306b\u63a5\u7d9a\u3059\u308b\u3068\uff2c\uff25\uff24\u304c\u3068\u3082\u308a\u307e\u3059\u3002phpMyAdmin\u3067\u78ba\u8a8d\u3059\u308b\u306810\u79d2\u304a\u304d\u306b\u30c7\u30fc\u30bf\u304c\u84c4\u7a4d\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5148\u65e5BME680\u306e\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u98db\u3070\u3057\u307e\u3057\u305f\u304c\u3001\u30b9\u30bf\u30f3\u30c9\u30a2\u30ed\u30f3\u3067\u81ea\u52d5\u6e2c\u5b9a\u3067\u304d\u308b\u3088\u3046\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f4\u65b0\u3057\u307e\u3057\u305f\u3002\u307e\u305f\u3001Wi-Fi\u306b\u63a5\u7d9a\u3057\u3066\u3044\u308b\u969b\u306b\uff2c\uff25\uff24\u3092\u70b9\u706f\u3055\u305b\u308b\u3053\u3068\u3068\u3057\u307e\u3057\u305f\u3002\u30d4\u30f3\uff14\u756a\u306b\u30d7\u30eb\u30a2\u30c3\u30d7\u62b5\u6297\u3092\u4ecb\u3057\u3066 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/sakae-shokai.com\/wordpress\/?p=379\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;ESP32\u3000BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059\u3000\u305d\u306e\uff12&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":234,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,39,16],"tags":[46,18,19],"class_list":["post-379","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-esp32","category-mariadb","category-micropython","tag-bme680","tag-esp32","tag-micropython"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u5148\u65e5BME680\u306e\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u98db\u3070\u3057\u307e\u3057\u305f\u304c\u3001\u30b9\u30bf\u30f3\u30c9\u30a2\u30ed\u30f3\u3067\u81ea\u52d5\u6e2c\u5b9a\u3067\u304d\u308b\u3088\u3046\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f4\u65b0\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"sakae\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/sakae-shokai.com\/wordpress\/?p=379\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"ja_JP\" \/>\n\t\t<meta property=\"og:site_name\" content=\"\u6804\u5546\u4f1a - \u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u30ab\u30e1\u30e9\u306e\u69cb\u7bc9\u3001\u4e2d\u53e4\u4e8c\u8f2a\u8eca\u306e\u8cb7\u53d6\uff0f\u8ca9\u58f2\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"ESP32 BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059 \u305d\u306e\uff12 - \u6804\u5546\u4f1a\" \/>\n\t\t<meta property=\"og:description\" content=\"\u5148\u65e5BME680\u306e\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u98db\u3070\u3057\u307e\u3057\u305f\u304c\u3001\u30b9\u30bf\u30f3\u30c9\u30a2\u30ed\u30f3\u3067\u81ea\u52d5\u6e2c\u5b9a\u3067\u304d\u308b\u3088\u3046\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f4\u65b0\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/sakae-shokai.com\/wordpress\/?p=379\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2021-03-04T10:12:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2021-03-03T09:13:56+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"ESP32 BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059 \u305d\u306e\uff12 - \u6804\u5546\u4f1a\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u5148\u65e5BME680\u306e\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u98db\u3070\u3057\u307e\u3057\u305f\u304c\u3001\u30b9\u30bf\u30f3\u30c9\u30a2\u30ed\u30f3\u3067\u81ea\u52d5\u6e2c\u5b9a\u3067\u304d\u308b\u3088\u3046\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f4\u65b0\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?p=379#blogposting\",\"name\":\"ESP32 BME680\\u3067\\u6e2c\\u5b9a\\u3057\\u305f\\u30c7\\u30fc\\u30bf\\u3092MariaDB\\u306b\\u3068\\u3070\\u3059 \\u305d\\u306e\\uff12 - \\u6804\\u5546\\u4f1a\",\"headline\":\"ESP32\\u3000BME680\\u3067\\u6e2c\\u5b9a\\u3057\\u305f\\u30c7\\u30fc\\u30bf\\u3092MariaDB\\u306b\\u3068\\u3070\\u3059\\u3000\\u305d\\u306e\\uff12\",\"author\":{\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/D073A08E-B5D9-40B9-978B-E7977F603ACB-scaled.jpeg\",\"width\":1080,\"height\":1920},\"datePublished\":\"2021-03-04T19:12:00+09:00\",\"dateModified\":\"2021-03-03T18:13:56+09:00\",\"inLanguage\":\"ja\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?p=379#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?p=379#webpage\"},\"articleSection\":\"ESP32, MariaDB, MicroPython, BME680, ESP32, microPython\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?p=379#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress#listItem\",\"position\":1,\"name\":\"\\u30db\\u30fc\\u30e0\",\"item\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?cat=15#listItem\",\"name\":\"\\u30d7\\u30ed\\u30b0\\u30e9\\u30e0\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?cat=15#listItem\",\"position\":2,\"name\":\"\\u30d7\\u30ed\\u30b0\\u30e9\\u30e0\",\"item\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?cat=15\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?cat=16#listItem\",\"name\":\"MicroPython\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress#listItem\",\"name\":\"\\u30db\\u30fc\\u30e0\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?cat=16#listItem\",\"position\":3,\"name\":\"MicroPython\",\"item\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?cat=16\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?p=379#listItem\",\"name\":\"ESP32\\u3000BME680\\u3067\\u6e2c\\u5b9a\\u3057\\u305f\\u30c7\\u30fc\\u30bf\\u3092MariaDB\\u306b\\u3068\\u3070\\u3059\\u3000\\u305d\\u306e\\uff12\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?cat=15#listItem\",\"name\":\"\\u30d7\\u30ed\\u30b0\\u30e9\\u30e0\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?p=379#listItem\",\"position\":4,\"name\":\"ESP32\\u3000BME680\\u3067\\u6e2c\\u5b9a\\u3057\\u305f\\u30c7\\u30fc\\u30bf\\u3092MariaDB\\u306b\\u3068\\u3070\\u3059\\u3000\\u305d\\u306e\\uff12\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?cat=16#listItem\",\"name\":\"MicroPython\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/#organization\",\"name\":\"\\u6804\\u5546\\u4f1a\",\"description\":\"\\u30cd\\u30c3\\u30c8\\u30ef\\u30fc\\u30af\\u30ab\\u30e1\\u30e9\\u306e\\u69cb\\u7bc9\\u3001\\u4e2d\\u53e4\\u4e8c\\u8f2a\\u8eca\\u306e\\u8cb7\\u53d6\\uff0f\\u8ca9\\u58f2\",\"url\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/\",\"telephone\":\"+818012056039\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/tori.jpg\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?p=379\\\/#organizationLogo\",\"width\":110,\"height\":110},\"image\":{\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?p=379\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?author=1#author\",\"url\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?author=1\",\"name\":\"sakae\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?p=379#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c05e9048726ffb005a982d57828a8d6a1c551b54bf44fc22b30e05eaa62ca05d?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"sakae\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?p=379#webpage\",\"url\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?p=379\",\"name\":\"ESP32 BME680\\u3067\\u6e2c\\u5b9a\\u3057\\u305f\\u30c7\\u30fc\\u30bf\\u3092MariaDB\\u306b\\u3068\\u3070\\u3059 \\u305d\\u306e\\uff12 - \\u6804\\u5546\\u4f1a\",\"description\":\"\\u5148\\u65e5BME680\\u306e\\u30c7\\u30fc\\u30bf\\u3092MariaDB\\u306b\\u98db\\u3070\\u3057\\u307e\\u3057\\u305f\\u304c\\u3001\\u30b9\\u30bf\\u30f3\\u30c9\\u30a2\\u30ed\\u30f3\\u3067\\u81ea\\u52d5\\u6e2c\\u5b9a\\u3067\\u304d\\u308b\\u3088\\u3046\\u306b\\u30d7\\u30ed\\u30b0\\u30e9\\u30e0\\u3092\\u66f4\\u65b0\",\"inLanguage\":\"ja\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?p=379#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?author=1#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/D073A08E-B5D9-40B9-978B-E7977F603ACB-scaled.jpeg\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?p=379\\\/#mainImage\",\"width\":1080,\"height\":1920},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/?p=379#mainImage\"},\"datePublished\":\"2021-03-04T19:12:00+09:00\",\"dateModified\":\"2021-03-03T18:13:56+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/\",\"name\":\"\\u6804\\u5546\\u4f1a\",\"description\":\"\\u30cd\\u30c3\\u30c8\\u30ef\\u30fc\\u30af\\u30ab\\u30e1\\u30e9\\u306e\\u69cb\\u7bc9\\u3001\\u4e2d\\u53e4\\u4e8c\\u8f2a\\u8eca\\u306e\\u8cb7\\u53d6\\uff0f\\u8ca9\\u58f2\",\"inLanguage\":\"ja\",\"publisher\":{\"@id\":\"https:\\\/\\\/sakae-shokai.com\\\/wordpress\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"ESP32 BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059 \u305d\u306e\uff12 - \u6804\u5546\u4f1a","description":"\u5148\u65e5BME680\u306e\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u98db\u3070\u3057\u307e\u3057\u305f\u304c\u3001\u30b9\u30bf\u30f3\u30c9\u30a2\u30ed\u30f3\u3067\u81ea\u52d5\u6e2c\u5b9a\u3067\u304d\u308b\u3088\u3046\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f4\u65b0","canonical_url":"https:\/\/sakae-shokai.com\/wordpress\/?p=379","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/sakae-shokai.com\/wordpress\/?p=379#blogposting","name":"ESP32 BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059 \u305d\u306e\uff12 - \u6804\u5546\u4f1a","headline":"ESP32\u3000BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059\u3000\u305d\u306e\uff12","author":{"@id":"https:\/\/sakae-shokai.com\/wordpress\/?author=1#author"},"publisher":{"@id":"https:\/\/sakae-shokai.com\/wordpress\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/02\/D073A08E-B5D9-40B9-978B-E7977F603ACB-scaled.jpeg","width":1080,"height":1920},"datePublished":"2021-03-04T19:12:00+09:00","dateModified":"2021-03-03T18:13:56+09:00","inLanguage":"ja","mainEntityOfPage":{"@id":"https:\/\/sakae-shokai.com\/wordpress\/?p=379#webpage"},"isPartOf":{"@id":"https:\/\/sakae-shokai.com\/wordpress\/?p=379#webpage"},"articleSection":"ESP32, MariaDB, MicroPython, BME680, ESP32, microPython"},{"@type":"BreadcrumbList","@id":"https:\/\/sakae-shokai.com\/wordpress\/?p=379#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/sakae-shokai.com\/wordpress#listItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/sakae-shokai.com\/wordpress","nextItem":{"@type":"ListItem","@id":"https:\/\/sakae-shokai.com\/wordpress\/?cat=15#listItem","name":"\u30d7\u30ed\u30b0\u30e9\u30e0"}},{"@type":"ListItem","@id":"https:\/\/sakae-shokai.com\/wordpress\/?cat=15#listItem","position":2,"name":"\u30d7\u30ed\u30b0\u30e9\u30e0","item":"https:\/\/sakae-shokai.com\/wordpress\/?cat=15","nextItem":{"@type":"ListItem","@id":"https:\/\/sakae-shokai.com\/wordpress\/?cat=16#listItem","name":"MicroPython"},"previousItem":{"@type":"ListItem","@id":"https:\/\/sakae-shokai.com\/wordpress#listItem","name":"\u30db\u30fc\u30e0"}},{"@type":"ListItem","@id":"https:\/\/sakae-shokai.com\/wordpress\/?cat=16#listItem","position":3,"name":"MicroPython","item":"https:\/\/sakae-shokai.com\/wordpress\/?cat=16","nextItem":{"@type":"ListItem","@id":"https:\/\/sakae-shokai.com\/wordpress\/?p=379#listItem","name":"ESP32\u3000BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059\u3000\u305d\u306e\uff12"},"previousItem":{"@type":"ListItem","@id":"https:\/\/sakae-shokai.com\/wordpress\/?cat=15#listItem","name":"\u30d7\u30ed\u30b0\u30e9\u30e0"}},{"@type":"ListItem","@id":"https:\/\/sakae-shokai.com\/wordpress\/?p=379#listItem","position":4,"name":"ESP32\u3000BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059\u3000\u305d\u306e\uff12","previousItem":{"@type":"ListItem","@id":"https:\/\/sakae-shokai.com\/wordpress\/?cat=16#listItem","name":"MicroPython"}}]},{"@type":"Organization","@id":"https:\/\/sakae-shokai.com\/wordpress\/#organization","name":"\u6804\u5546\u4f1a","description":"\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u30ab\u30e1\u30e9\u306e\u69cb\u7bc9\u3001\u4e2d\u53e4\u4e8c\u8f2a\u8eca\u306e\u8cb7\u53d6\uff0f\u8ca9\u58f2","url":"https:\/\/sakae-shokai.com\/wordpress\/","telephone":"+818012056039","logo":{"@type":"ImageObject","url":"https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/02\/tori.jpg","@id":"https:\/\/sakae-shokai.com\/wordpress\/?p=379\/#organizationLogo","width":110,"height":110},"image":{"@id":"https:\/\/sakae-shokai.com\/wordpress\/?p=379\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/sakae-shokai.com\/wordpress\/?author=1#author","url":"https:\/\/sakae-shokai.com\/wordpress\/?author=1","name":"sakae","image":{"@type":"ImageObject","@id":"https:\/\/sakae-shokai.com\/wordpress\/?p=379#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/c05e9048726ffb005a982d57828a8d6a1c551b54bf44fc22b30e05eaa62ca05d?s=96&d=mm&r=g","width":96,"height":96,"caption":"sakae"}},{"@type":"WebPage","@id":"https:\/\/sakae-shokai.com\/wordpress\/?p=379#webpage","url":"https:\/\/sakae-shokai.com\/wordpress\/?p=379","name":"ESP32 BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059 \u305d\u306e\uff12 - \u6804\u5546\u4f1a","description":"\u5148\u65e5BME680\u306e\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u98db\u3070\u3057\u307e\u3057\u305f\u304c\u3001\u30b9\u30bf\u30f3\u30c9\u30a2\u30ed\u30f3\u3067\u81ea\u52d5\u6e2c\u5b9a\u3067\u304d\u308b\u3088\u3046\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f4\u65b0","inLanguage":"ja","isPartOf":{"@id":"https:\/\/sakae-shokai.com\/wordpress\/#website"},"breadcrumb":{"@id":"https:\/\/sakae-shokai.com\/wordpress\/?p=379#breadcrumblist"},"author":{"@id":"https:\/\/sakae-shokai.com\/wordpress\/?author=1#author"},"creator":{"@id":"https:\/\/sakae-shokai.com\/wordpress\/?author=1#author"},"image":{"@type":"ImageObject","url":"https:\/\/sakae-shokai.com\/wordpress\/wp-content\/uploads\/2021\/02\/D073A08E-B5D9-40B9-978B-E7977F603ACB-scaled.jpeg","@id":"https:\/\/sakae-shokai.com\/wordpress\/?p=379\/#mainImage","width":1080,"height":1920},"primaryImageOfPage":{"@id":"https:\/\/sakae-shokai.com\/wordpress\/?p=379#mainImage"},"datePublished":"2021-03-04T19:12:00+09:00","dateModified":"2021-03-03T18:13:56+09:00"},{"@type":"WebSite","@id":"https:\/\/sakae-shokai.com\/wordpress\/#website","url":"https:\/\/sakae-shokai.com\/wordpress\/","name":"\u6804\u5546\u4f1a","description":"\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u30ab\u30e1\u30e9\u306e\u69cb\u7bc9\u3001\u4e2d\u53e4\u4e8c\u8f2a\u8eca\u306e\u8cb7\u53d6\uff0f\u8ca9\u58f2","inLanguage":"ja","publisher":{"@id":"https:\/\/sakae-shokai.com\/wordpress\/#organization"}}]},"og:locale":"ja_JP","og:site_name":"\u6804\u5546\u4f1a - \u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u30ab\u30e1\u30e9\u306e\u69cb\u7bc9\u3001\u4e2d\u53e4\u4e8c\u8f2a\u8eca\u306e\u8cb7\u53d6\uff0f\u8ca9\u58f2","og:type":"article","og:title":"ESP32 BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059 \u305d\u306e\uff12 - \u6804\u5546\u4f1a","og:description":"\u5148\u65e5BME680\u306e\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u98db\u3070\u3057\u307e\u3057\u305f\u304c\u3001\u30b9\u30bf\u30f3\u30c9\u30a2\u30ed\u30f3\u3067\u81ea\u52d5\u6e2c\u5b9a\u3067\u304d\u308b\u3088\u3046\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f4\u65b0","og:url":"https:\/\/sakae-shokai.com\/wordpress\/?p=379","article:published_time":"2021-03-04T10:12:00+00:00","article:modified_time":"2021-03-03T09:13:56+00:00","twitter:card":"summary","twitter:title":"ESP32 BME680\u3067\u6e2c\u5b9a\u3057\u305f\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u3068\u3070\u3059 \u305d\u306e\uff12 - \u6804\u5546\u4f1a","twitter:description":"\u5148\u65e5BME680\u306e\u30c7\u30fc\u30bf\u3092MariaDB\u306b\u98db\u3070\u3057\u307e\u3057\u305f\u304c\u3001\u30b9\u30bf\u30f3\u30c9\u30a2\u30ed\u30f3\u3067\u81ea\u52d5\u6e2c\u5b9a\u3067\u304d\u308b\u3088\u3046\u306b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f4\u65b0"},"aioseo_meta_data":{"post_id":"379","title":"#post_title #separator_sa #site_title","description":"#post_content","keywords":[],"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"Article","defaultPostTypeGraph":""},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","location":null,"local_seo":{"businessInfo":{"name":"","urls":{"website":"","aboutPage":"","contactPage":""},"address":{"line1":"","line2":"","zip":"","city":"","state":"","country":""},"contact":{"email":"","phone":"","fax":""},"ids":{"vatID":"","taxID":"","chamberID":""},"payment":{"priceIndication":"","currenciesAccepted":"","methodsAccepted":""},"areaServed":""},"openingHours":{"show":false,"closedLabel":"","open24h":false,"open24hLabel":"","open247":false,"use24hFormat":false,"twoSets":false,"timezone":"","hours":[]}},"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-03-03 08:12:35","updated":"2025-06-04 03:19:51","seo_analyzer_scan_date":null},"_links":{"self":[{"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=379"}],"version-history":[{"count":7,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/379\/revisions"}],"predecessor-version":[{"id":387,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/379\/revisions\/387"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/234"}],"wp:attachment":[{"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sakae-shokai.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}