{"id":2401,"date":"2024-02-08T11:14:00","date_gmt":"2024-02-08T02:14:00","guid":{"rendered":"https:\/\/hatter.jp\/nico\/?p=2401"},"modified":"2024-02-13T17:04:36","modified_gmt":"2024-02-13T08:04:36","slug":"sqlite%e3%81%a7wordpress","status":"publish","type":"post","link":"https:\/\/hatter.jp\/nico\/2024\/02\/08\/sqlite%e3%81%a7wordpress\/","title":{"rendered":"SQLite\u3067WordPress"},"content":{"rendered":"\n<p class=\"has-text-align-right wp-block-paragraph\">\u4ee4\u548c6\u5e742\u67088\u65e5<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL\u304c\u306a\u3044\u306a\u3089SQLite(wp-sqlite-db)\u3092\u4f7f\u3046<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f7f\u3063\u3066\u3044\u308b\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u306e\u6700\u5b89\u30d7\u30e9\u30f3\u306b\u306fMySQL\u304c\u306a\u304b\u3063\u305f\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3092\u6a5f\u306b\u4ee4\u548c6\u5e742\u67088\u65e5\u6642\u70b9\u3067\u901a\u7528\u3059\u308b\u60c5\u5831\u3092\u8a18\u9332\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u53c2\u8003\u306b\u3057\u305f\u30da\u30fc\u30b8(\u975e\u5e38\u306b\u8a73\u3057\u3044)<\/h3>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u3067\u306fMySQL\u306e\u5236\u9650\u304c\u3042\u308a\u30ef\u30fc\u30c9\u30d7\u30ec\u30b9\u306e\u5229\u7528\u3092\u8ae6\u3081\u3066\u3044\u308b\u65b9\u306f\u3044\u307e\u305b\u3093\u304b\uff1f\u305d\u308c\u3092\u6551\u3046\u306e\u304csqlite\u3067\u3059\u3002\u305d\u306e\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<cite><a href=\"https:\/\/kuruma.rdy.jp\/it\/wordpress-sqlite-howto\/\">WordPress\u3067Sqlite\u304c\u4f7f\u3048\u306a\u3044\u7406\u7531\u3068\u5bfe\u5fdc\u7b56<\/a> \uff70 \u8f9b\u53e3\u304f\u308b\u307e\u8a55\u4fa1\u306e\u67fb\u5b9a\u541b<\/cite><\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\">\u516c\u5f0f\u306b\u3088\u308b\u8aac\u660e<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/github.com\/aaemnnosttv\/wp-sqlite-db\">wp-sqlite-db\u516c\u5f0f\u30da\u30fc\u30b8<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u516c\u5f0f\u30da\u30fc\u30b8\u306b\u306f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u307e\u3067\u306e\u65b9\u6cd5\u304c\u7c21\u6f54\u306b\u8a18\u3055\u308c\u3066\u3044\u308b\u3002<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">About<br>A single file drop-in for using a SQLite database with WordPress. Based on the original SQLite Integration plugin.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">(\u8a33)<br>About<br>WordPress \u3067 SQLite \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u7528\u3059\u308b\u305f\u3081\u306e\u5358\u4e00\u30d5\u30a1\u30a4\u30eb \u30c9\u30ed\u30c3\u30d7\u30a4\u30f3\u3002\u30aa\u30ea\u30b8\u30ca\u30eb\u306e SQLite \u7d71\u5408\u30d7\u30e9\u30b0\u30a4\u30f3\u306b\u57fa\u3065\u3044\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<cite><a href=\"https:\/\/github.com\/aaemnnosttv\/wp-sqlite-db\">wp-sqlite-db\u516c\u5f0f\u30da\u30fc\u30b8<\/a> \u3088\u308a<\/cite><\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\">\u624b\u306b\u5165\u308c\u308b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/github.com\/aaemnnosttv\/wp-sqlite-db\">wp-sqlite-db\u516c\u5f0f\u30da\u30fc\u30b8<\/a>\u306e\u53f3\u5074\u306b\u3042\u308b<a href=\"https:\/\/github.com\/aaemnnosttv\/wp-sqlite-db\/releases\">Releases<\/a>\u3088\u308a\u66f8\u5eab\u3092\u624b\u306b\u5165\u308c\u308b\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u73fe\u5728\u306e\u6700\u65b0\u7248\u306fFeb 6, 2023 v1.3.1\u3068\u306a\u3063\u3066\u3044\u308b\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u66f8\u5eab\u304b\u3089\u624b\u306b\u5165\u308c\u305fsrc\/db.php\u3092wp-content\u3078\u79fb\u3059\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">wp-config-sample.php\u306e\u4e00\u90e8\u3092\u5909\u66f4\u3059\u308b\u3002<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\/**#@+<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Authentication unique keys and salts.<br>*<\/li>\n\n\n\n<li>Change these to different unique phrases! You can generate these using<\/li>\n\n\n\n<li>the {@link https:\/\/api.wordpress.org\/secret-key\/1.1\/salt\/ WordPress.org secret-key service}.<br>*<\/li>\n\n\n\n<li>You can change these at any point in time to invalidate all existing cookies.<\/li>\n\n\n\n<li>This will force all users to have to log in again.<br>*<\/li>\n\n\n\n<li>@since 2.6.0<br>*\/<br>define( &#8216;AUTH_KEY&#8217;, &#8216;put your unique phrase here&#8217; );<br>define( &#8216;SECURE_AUTH_KEY&#8217;, &#8216;put your unique phrase here&#8217; );<br>define( &#8216;LOGGED_IN_KEY&#8217;, &#8216;put your unique phrase here&#8217; );<br>define( &#8216;NONCE_KEY&#8217;, &#8216;put your unique phrase here&#8217; );<br>define( &#8216;AUTH_SALT&#8217;, &#8216;put your unique phrase here&#8217; );<br>define( &#8216;SECURE_AUTH_SALT&#8217;, &#8216;put your unique phrase here&#8217; );<br>define( &#8216;LOGGED_IN_SALT&#8217;, &#8216;put your unique phrase here&#8217; );<br>define( &#8216;NONCE_SALT&#8217;, &#8216;put your unique phrase here&#8217; );<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\/*<em>#@-<\/em>\/<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<cite>wp-config-sample.php \u3088\u308a<\/cite><\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/api.wordpress.org\/secret-key\/1.1\/salt\/\">WordPress.org secret-key service<\/a>\u3092\u5229\u7528\u3057\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u6587\u5b57\u5217\u3092\u624b\u306b\u5165\u308c\u308b\u3002<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a2d5b5f8db20&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a2d5b5f8db20\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"775\" height=\"174\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/hatter.jp\/nico\/wp-content\/uploads\/2024\/02\/WordPress.org-secret-key-service.png\" alt=\"\" class=\"wp-image-2407\" srcset=\"https:\/\/hatter.jp\/nico\/wp-content\/uploads\/2024\/02\/WordPress.org-secret-key-service.png 775w, https:\/\/hatter.jp\/nico\/wp-content\/uploads\/2024\/02\/WordPress.org-secret-key-service-300x67.png 300w\" sizes=\"auto, (max-width: 775px) 100vw, 775px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">\u3053\u308c\u3092\u5148\u307b\u3069\u306ewp-config-sample.php\u5185\u306e\u8a72\u5f53\u90e8\u5206\u3068\u7f6e\u304d\u63db\u3048\u308b\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7f6e\u304d\u63db\u3048\u5f8c\u3001wp-config-sample.php\u3092wp-config.php\u3078\u6539\u3081\u308b\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u3042\u3044\u307e\u3044<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u524d\u56de\u3084\u3063\u305f\u3068\u304d\u306fdb.php\u3092\u79fb\u52d5\u3057\u305f\u306e\u306f\u4e00\u756a\u6700\u5f8c\u3060\u3063\u305f\u3088\u3046\u306a\u6c17\u3082\u3059\u308b\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30ea\u30e2\u30fc\u30c8\u3067\u4f5c\u696d\u3057\u3066\u305f\u3057\u3001\u53e4\u3044\u60c5\u5831\u3092\u5143\u306b\u8a66\u884c\u932f\u8aa4\u3057\u3064\u3064config\u3060\u3051\u306f\u5148\u306b\u4f5c\u3063\u3066\u3044\u305f\u304b\u3082\u3057\u308c\u306a\u3044\u306e\u3067\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u306a\u306e\u3067\u30ad\u30fc\u3068db.php\u306e\u5148\u5f8c\u306e\u95a2\u4fc2\u304c\u3088\u304f\u308f\u304b\u3089\u306a\u3044\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL\u304c\u306a\u3044\u305b\u3044\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a8\u30e9\u30fc\u304c\u51fa\u3066\u306e\u4f5c\u696d\u3068\u3044\u3046\u8a18\u61b6\u306f\u3042\u308b\u304c\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u306b\u3064\u3044\u3066<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee4\u548c6\u5e742\u67087\u65e5<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f5c\u696d\u5185\u5bb9\uff1adb.php\u3092v1.2.1\u3088\u308av1.3.0\u3078\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8(db.php\u306e\u4e0a\u66f8\u304d)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u72b6\u6cc1\uff1a\u4eca\u306e\u3068\u3053\u308d\u7279\u306b\u4f55\u3082\u306a\u3057<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee4\u548c6\u5e742\u670812\u65e5 \u8ffd\u8a18<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u72b6\u6cc1\uff1a\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u304b\u30892\uff5e3\u65e5\u3057\u3066\u91cd\u5927\u306a\u30a8\u30e9\u30fc\u306e\u767a\u751f(\u7ba1\u7406\u753b\u9762\u3082\u51fa\u305a)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u51e6\u7f6e\uff1a<a href=\"https:\/\/ja.wordpress.org\/plugins\/broken-link-checker\/\">Broken Link Checker<\/a>\u95a2\u4fc2\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u306e\u7121\u52b9\u5316<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8a73\u7d30\uff1adb.php\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u306e\u95a2\u4fc2\u304b\u3068\u601d\u3044\u304d\u3084\u4ed6\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u306e\u95a2\u4fc2\u3067\u3042\u3063\u305f(\u901a\u77e5\u3082\u306a\u304f\u8a73\u7d30\u306f\u4e0d\u660e)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee4\u548c6\u5e742\u67088\u65e5 MySQL\u304c\u306a\u3044\u306a\u3089SQLite(wp-sqlite-db)\u3092\u4f7f\u3046 \u4f7f\u3063\u3066\u3044\u308b\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u306e\u6700\u5b89\u30d7\u30e9\u30f3\u306b\u306fMySQL\u304c\u306a\u304b\u3063\u305f\u3002 \u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3092\u6a5f\u306b\u4ee4\u548c6\u5e742\u67088\u65e5\u6642\u70b9\u3067\u901a\u7528\u3059\u308b\u60c5\u5831\u3092\u8a18\u9332\u3002 \u53c2\u8003\u306b [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":438,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[85,43],"class_list":["post-2401","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-21","tag-85","tag-43"],"_links":{"self":[{"href":"https:\/\/hatter.jp\/nico\/wp-json\/wp\/v2\/posts\/2401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hatter.jp\/nico\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hatter.jp\/nico\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hatter.jp\/nico\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hatter.jp\/nico\/wp-json\/wp\/v2\/comments?post=2401"}],"version-history":[{"count":26,"href":"https:\/\/hatter.jp\/nico\/wp-json\/wp\/v2\/posts\/2401\/revisions"}],"predecessor-version":[{"id":2521,"href":"https:\/\/hatter.jp\/nico\/wp-json\/wp\/v2\/posts\/2401\/revisions\/2521"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hatter.jp\/nico\/wp-json\/wp\/v2\/media\/438"}],"wp:attachment":[{"href":"https:\/\/hatter.jp\/nico\/wp-json\/wp\/v2\/media?parent=2401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hatter.jp\/nico\/wp-json\/wp\/v2\/categories?post=2401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hatter.jp\/nico\/wp-json\/wp\/v2\/tags?post=2401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}