{"id":6908,"date":"2020-04-14T15:00:44","date_gmt":"2020-04-14T06:00:44","guid":{"rendered":"https:\/\/blog.capilano-fw.com\/?p=6908"},"modified":"2020-04-12T07:40:42","modified_gmt":"2020-04-11T22:40:42","slug":"%e7%b0%a1%e5%8d%98%ef%bc%81laravel%e3%81%a7sqlite%e3%82%92%e4%bd%bf%e3%81%86%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/blog.capilano-fw.com\/?p=6908","title":{"rendered":"\u7c21\u5358\uff01Laravel\u3067SQLite\u3092\u4f7f\u3046\u65b9\u6cd5\uff08phpLiteAdmin\u3082\u3042\u308a\uff09"},"content":{"rendered":"<p>\u3055\u3066\u3055\u3066\u3001\u3053\u308c\u307e\u3067\u79c1\u306f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u69d8\u65b9\u304b\u3089\u69d8\u3005\u306a\u30bf\u30a4\u30d7\u306e\u3054\u4f9d\u983c\u3092\u53d7\u3051\u3066\u304d\u307e\u3057\u305f\u3002\u3082\u3061\u308d\u3093<code>Laravel<\/code>\u95a2\u9023\u306e\u958b\u767a\u304c\u591a\u3044\u306e\u3067\u3059\u304c\u3001<strong>\u305d\u3093\u306a\u4e2d\u3001\u5c11\u3057\u300c\u5909\u5316\u7403\u300d\u306a\u5185\u5bb9\u304c\u3042\u308a\u307e\u3057\u305f\u3002<\/strong><\/p>\n<p>\u305d\u308c\u306f\u30fb\u30fb\u30fb<\/p>\n<p><strong style=\"font-size: 35px;\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306bSQLite\u3092\u4f7f\u3046<\/strong><\/p>\n<p>\u3068\u3044\u3046\u3082\u306e\u3067\u3059\u3002<\/p>\n<p>\u3068\u3044\u3046\u306e\u3082\u3001\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3055\u3093\u306b\u304a\u8a71\u3092\u4f3a\u3046\u3068\u30fb\u30fb\u30fb<\/p>\n<ul>\n<li>\u305d\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306f\u4eca\u5f8c\u30b3\u30d4\u30fc\u3057\u3066\u8907\u6570\u3067\u904b\u7528\u3057\u305f\u3044<\/li>\n<li>\u3067\u3082MySQL\u306a\u3069\u306e\u521d\u671f\u8a2d\u5b9a\u306f\u30ce\u30a6\u30cf\u30a6\u304c\u306a\u3044\u306e\u3067\u3067\u304d\u306a\u3044<\/li>\n<\/ul>\n<p>\u3068\u306e\u3053\u3068\u3067\u3057\u305f\u306e\u3067\u3001\u300c\u3067\u3057\u305f\u3089<code>SQLite<\/code>\u306f\u3069\u3046\u3067\u3057\u3087\u3046\ud83d\ude09\u300d\u3068\u63d0\u6848\u3055\u305b\u3066\u3044\u305f\u3060\u304d\u307e\u3057\u305f\u3002<\/p>\n<p>\u306a\u305c\u306a\u3089\u3001<code>SQLite<\/code>\u306f\u30d5\u30a1\u30a4\u30eb\u3092\u4f7f\u3063\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306a\u306e\u3067\u3001\u521d\u671f\u8a2d\u5b9a\u3092\u6e08\u307e\u305b\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u3064\u304f\u3063\u3066\u304a\u3051\u3070\u5f8c\u306f\u30b3\u30d4\u30fc\u3059\u308b\u3060\u3051\u3067\u3059\u3057\u3001\u3055\u3089\u306b\u30ec\u30f3\u30bf\u30eb\u30b5\u30fc\u30d0\u30fc\u3082<code>SQLite<\/code>\u306b\u306f\u5bfe\u5fdc\u3057\u3066\u308b\u3068\u3053\u308d\u304c\u591a\u304b\u3063\u305f\u304b\u3089\u3067\u3059\u3002<\/p>\n<p>\u305d\u3053\u3067\uff01<\/p>\n<p>\u4eca\u56de\u306f\u305d\u3093\u306a<code>SQLite<\/code>\u3092<code>Laravel<\/code>\u3067\u4f7f\u3046\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<br \/>\n\u305c\u3072\u697d\u3057\u307f\u306a\u304c\u3089\u3084\u3063\u3066\u307f\u307e\u3057\u3087\u3046\u2757<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6070 aligncenter\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/03\/no_5.png\" alt=\"\" width=\"260\" height=\"320\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/03\/no_5.png 260w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/03\/no_5-244x300.png 244w\" sizes=\"auto, (max-width: 260px) 100vw, 260px\" \/><\/p>\n<p style=\"text-align: center;\">\u300cSQLite\u3063\u3066<br \/>\n\u601d\u3063\u305f\u3088\u308a\u9ad8\u901f\u3067\u3059\u306d\ud83d\ude32\u2757\u300d<\/p>\n<p><strong>\u958b\u767a\u74b0\u5883\uff1a<\/strong> Laravel 7.x\u3001Ubuntu 18.04\u3001nginx 1.14.0<\/p>\n<h1>SQLite\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/h1>\n<p>\u307e\u305a\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066<code>SQLite<\/code>\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n<pre><strong>sqlite3 --version<\/strong><\/pre>\n<p>\u3082\u3057\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre><strong>sudo apt install sqlite3<\/strong><\/pre>\n<h1>Laravel\u3067SQLite\u3092\u4f7f\u3046\u8a2d\u5b9a\u3092\u3059\u308b<\/h1>\n<h2>.env\u3092\u5909\u66f4\u3059\u308b<\/h2>\n<p><code>Laravel<\/code>\u3067<code>SQLite<\/code>\u3092\u4f7f\u3046\u306b\u306f\u3001<code>.env<\/code>\u5185\u306b\u3042\u308b<code>DB_CONNECTION<\/code>\u3092\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n<pre><strong>DB_CONNECTION=sqlite\r\n\r\n# \ud83d\udc47 \u305d\u306e\u4ed6\u306f\u4e0d\u8981\u306a\u306e\u3067\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\r\n<\/strong>#DB_HOST=127.0.0.1\r\n#DB_PORT=3306\r\n#DB_DATABASE=*****\r\n#DB_USERNAME=*****\r\n#DB_PASSWORD=*****<\/pre>\n<p>\u306a\u304a\u3001<code>Laravel<\/code>\u306e<code>SQLite<\/code>\u30d5\u30a1\u30a4\u30eb\u306f<code>\/database\/database.sqlite<\/code>\u304c\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u3059\u304c\u3001\u5909\u66f4\u3057\u305f\u3044\u5834\u5408\u306f<code>DB_DATABASE<\/code>\u3067\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<\/p>\n<pre><strong>DB_DATABASE=\/PATH\/TO\/YOUR\/SQLITE\/database.db<\/strong><\/pre>\n<h2>\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3059\u308b<\/h2>\n<p><code>SQLite<\/code>\u306f\u30d5\u30a1\u30a4\u30eb\u3092\u4f7f\u3063\u305fDB\u3067\u3059\u306e\u3067\u3001\u307e\u305a\u300c<strong>\/database\/database.sqlite<\/strong>\u300d\u3068\u3044\u3046DB\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6909\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/04\/wordpress_twitter_7-1.png\" alt=\"\" width=\"472\" height=\"128\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/04\/wordpress_twitter_7-1.png 472w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/04\/wordpress_twitter_7-1-300x81.png 300w\" sizes=\"auto, (max-width: 472px) 100vw, 472px\" \/><\/p>\n<p>\u3061\u306a\u307f\u306b\u3001\u5f8c\u307b\u3069\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3092\u5b9f\u884c\u3057\u3066\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u5834\u5408\u306f\u30d5\u30a1\u30a4\u30eb\u306e\u6a29\u9650\u304c\u6b63\u3057\u304f\u306a\u3044\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<pre><strong>unable to open database file ...<\/strong><\/pre>\n<p>\u305d\u3093\u306a\u5834\u5408\u3001\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3067\u6240\u6709\u8005\u3068\u6a29\u9650\u3092\u5909\u66f4\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre><strong>sudo chown www-data:\uff08\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u3044\u308b\u30e6\u30fc\u30b6\u30fc\u540d\uff09 database.sqlite<\/strong><\/pre>\n<pre><strong>sudo chmod 775 database.sqlite<\/strong><\/pre>\n<p>\u306a\u304a\u3001<code>www-data<\/code>\u306e\u90e8\u5206\u306f\u5b9f\u884c\u74b0\u5883\u306b\u3088\u3063\u3066\u9055\u3063\u3066\u304d\u307e\u3059\u306e\u3067\u3001\u6b21\u306e\u30b3\u30fc\u30c9\u3092<strong>PHP\u3067<\/strong>\u5b9f\u884c\u3057\u3066\u307f\u308b\u3068\u3044\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n<pre><strong>echo exec('whoami');<\/strong> \/\/ \ud83d\udc48 PHP\u3092\u5b9f\u884c\u3057\u3066\u3044\u308b\u30e6\u30fc\u30b6\u30fc\u540d\u304c\u8868\u793a\u3055\u308c\u307e\u3059<\/pre>\n<p>\u3053\u308c\u3067<code>SQLite<\/code>\u306e\u8a2d\u5b9a\u306f\u5b8c\u4e86\u3067\u3059\uff01<\/p>\n<h1>phpLiteAdmin\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/h1>\n<p><code>SQLite<\/code>\u306e\u4e2d\u8eab\u3092\u30d6\u30e9\u30a6\u30b6\u304b\u3089\u78ba\u8a8d\u3067\u304d\u308b\u3088\u3046\u306b<code>phpLiteAdmin<\/code>\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002\uff08\u4e0d\u8981\u306a\u4eba\u306f\u6b21\u307e\u3067\u8aad\u307f\u98db\u3070\u3057\u3066\u304f\u3060\u3055\u3044\uff09<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6911\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/04\/laravel_sqlite_3.png\" alt=\"\" width=\"540\" height=\"240\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/04\/laravel_sqlite_3.png 540w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/04\/laravel_sqlite_3-300x133.png 300w\" sizes=\"auto, (max-width: 540px) 100vw, 540px\" \/><\/p>\n<h2>\u672c\u4f53\u3092\u8a2d\u7f6e\u3059\u308b<\/h2>\n<p>\u307e\u305a<a href=\"https:\/\/www.phpliteadmin.org\/download\/\" target=\"_blank\" rel=\"noopener noreferrer\">\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30da\u30fc\u30b8<\/a>\u306b\u30a2\u30af\u30bb\u30b9\u3057\u6700\u65b0\u7248\u306e<code>phpLiteAdmin<\/code>\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002<\/p>\n<p>\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u5c55\u958b\u3059\u308b\u3068<code>phpLiteAdmin_v1-9-8-2<\/code>\u3068\u3044\u3046\u30d5\u30a9\u30eb\u30c0\u304c\u4f5c\u6210\u3055\u308c\u308b\u306e\u3067\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u3066\u79fb\u52d5\u3057\u307e\u3059\u3002<\/p>\n<pre><strong>sudo mv phpLiteAdmin_v1-9-8-2 \/usr\/share\/phpLiteAdmin<\/strong><\/pre>\n<h2>nginx\u306e\u8a2d\u5b9a\u3092\u3059\u308b<\/h2>\n<p>\u6b21\u306b\u3001\u8a2d\u7f6e\u3057\u305f<code>phpLiteAdmin<\/code>\u306b\u300c<strong>phpliteadmin.test<\/strong>\u300d\u3068\u3057\u3066\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b<code>nginx<\/code>\u3067\u8a2d\u5b9a\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002<\/p>\n<p>\u4ee5\u4e0b\u306e\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u3066\u4fdd\u5b58\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><code><strong>\/etc\/nginx\/sites-available\/default<\/strong><\/code><\/p>\n<pre># \ud83d\udc47 \u8ffd\u52a0\r\n# phpLiteAdmin\r\nserver {\r\n\tlisten 80;\r\n\tlisten [::]:80;\r\n\tserver_name phpliteadmin.test;\r\n\troot \/usr\/share\/phpLiteAdmin;\r\n\tindex index.html, index.php;\r\n\r\n\tlocation \/ {\r\n\t\ttry_files $uri $uri\/ =404;\r\n\t}\r\n\r\n      location ~ \\.php$ {\r\n            include snippets\/fastcgi-php.conf;\r\n            fastcgi_pass unix:\/var\/run\/php\/php7.2-fpm.sock;\r\n        }\r\n}<\/pre>\n<p>\u4fdd\u5b58\u304c\u5b8c\u4e86\u3057\u305f\u3089\u3001<code>nginx<\/code>\u3092\u518d\u8d77\u52d5\u3057\u307e\u3059\u3002<\/p>\n<pre><strong>sudo systemctl restart nginx<\/strong><\/pre>\n<h2>\u30c9\u30e1\u30a4\u30f3\u767b\u9332\u3059\u308b<\/h2>\n<p>\u7d9a\u3044\u3066\u3001\u300c<strong>phpliteadmin.test<\/strong>\u300d\u30c9\u30e1\u30a4\u30f3\u306e\u767b\u9332\u3067\u3059\u3002<br \/>\n\u3053\u3061\u3089\u3082\u6b21\u306e\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p><strong><code>\/etc\/hosts<\/code><\/strong><\/p>\n<pre><strong>127.0.0.1\tphpliteadmin.test<\/strong><\/pre>\n<p>\u3053\u308c\u3067\u3001\u30d6\u30e9\u30a6\u30b6\u304b\u3089\u300c<strong>http:\/\/phpliteadmin.test\/phpliteadmin.php<\/strong>\u300d\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<h2>phpLiteAdmin\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3059\u308b<\/h2>\n<p>\u6700\u5f8c\u306b<code>phpLiteAdmin<\/code>\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3057\u307e\u3059\u3002<\/p>\n<p><code><strong>\/usr\/share\/phpLiteAdmin\/phpliteadmin.php<\/strong><\/code><\/p>\n<pre>\/\/password to gain access\r\n<strong>$password = '\uff08\u3053\u3053\u306b\u30d1\u30b9\u30ef\u30fc\u30c9\uff09';<\/strong> \/\/ \ud83d\udc48 phpLiteAdmin\u3078\u306e\u30ed\u30b0\u30a4\u30f3\u30d1\u30b9\u30ef\u30fc\u30c9\r\n\r\n\/\/directory relative to this file to search for databases (if false, manually list databases in the $databases variable)\r\n<strong>$directory = false;<\/strong> \/\/ \ud83d\udc48 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u76f4\u63a5\u6307\u5b9a\u3059\u308b\u306e\u3067 false \u306b\u5909\u66f4\r\n\r\n\/\/whether or not to scan the subdirectories of the above directory infinitely deep\r\n$subdirectories = false;\r\n\r\n\/\/if the above $directory variable is set to false, you must specify the databases manually in an array as the next variable\r\n\/\/if any of the databases do not exist as they are referenced by their path, they will be created automatically\r\n\r\n\/\/ \ud83d\udc47 \u3053\u3053\u304c\u63a5\u7d9a\u3059\u308bSQLite\u306eDB\u30d5\u30a1\u30a4\u30eb\u3067\u3059\u3002\r\n$databases = array(\r\n\tarray(\r\n\t\t'path'=&gt; '\/PATH\/TO\/YOUR\/LARAVEL\/database\/database.sqlite', \/\/ \ud83d\udc48 \u5148\u307b\u3069\u3064\u304f\u3063\u305f\u30d5\u30a1\u30a4\u30eb\r\n\t\t'name'=&gt; 'Laravel 7.x'\r\n\t)\r\n);<\/pre>\n<p>\u3053\u308c\u3067\u30d6\u30e9\u30a6\u30b6\u304b\u3089\u30ed\u30b0\u30a4\u30f3\u3059\u308b\u3068\u6b21\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6912\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/04\/laravel_sqlite_4.png\" alt=\"\" width=\"536\" height=\"305\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/04\/laravel_sqlite_4.png 536w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/04\/laravel_sqlite_4-300x171.png 300w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><\/p>\n<p>\u203b\u306a\u304a\u3001<code>phpLiteAdmin<\/code>\u306f<code>GPL<\/code>\u30e9\u30a4\u30bb\u30f3\u30b9\u3067\u3059\u306e\u3067\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u540c\u68b1\u3059\u308b\u5834\u5408\u306f\u304a\u6c17\u3092\u3064\u3051\u304f\u3060\u3055\u3044\u3002<\/p>\n<h1>\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u3089\u30fb\u30fb\u30fb<\/h1>\n<p><code>phpinfo()<\/code>\u3067\u8868\u793a\u3057\u305f\u5185\u5bb9\u3067<code>sqlite3<\/code>\u304c\u6709\u52b9\u306b\u306a\u3063\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u3082\u3057\u6709\u52b9\u306b\u306a\u3063\u3066\u306a\u3044\u5834\u5408\u306f\u3001\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre><strong>sudo apt install php-sqlite3<\/strong><\/pre>\n<p>\u306a\u304a\u3001\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u6307\u5b9a\u3059\u308b\u5834\u5408\u306f\u3053\u3061\u3089\u3002<\/p>\n<pre><strong>sudo apt install php7.2-sqlite3<\/strong><\/pre>\n<h1>\u30c6\u30b9\u30c8\u3057\u3066\u307f\u308b<\/h1>\n<p>\u3067\u306f\u3001\u9069\u5f53\u306b\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u3068<code>Seeder<\/code>\u3092\u3064\u304f\u3063\u3066DB\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u3063\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<pre><strong>php artisan migrate:fresh --seed<\/strong><\/pre>\n<p>\u3059\u308b\u3068\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4e2d\u8eab\u306f\u6b21\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6913\" style=\"border: 3px solid #000;\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/04\/laravel_sqlite_5.png\" alt=\"\" width=\"600\" height=\"350\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/04\/laravel_sqlite_5.png 600w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/04\/laravel_sqlite_5-300x175.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>\u6210\u529f\u3067\u3059\ud83d\ude0a\u2728<\/p>\n<h1>\u304a\u308f\u308a\u306b<\/h1>\n<p>\u3068\u3044\u3046\u3053\u3068\u3067\u3001\u4eca\u56de\u306f<code>Laravel<\/code>\u3067<code>SQLite<\/code>\u3092\u4f7f\u3046\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u3042\u307e\u308a<code>SQLite<\/code>\u3092\u30e1\u30a4\u30f3\u3067\u4f7f\u3046\u3053\u3068\u306f\u5c11\u306a\u3044\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u304c\u3001\u7c21\u5358\u306b\u30b3\u30d4\u30fc\u3057\u3066\u6c17\u8efd\u306b\u4f7f\u3044\u305f\u3044\u5834\u5408\u306f\u4fbf\u5229\u306a\u3093\u3058\u3083\u306a\u3044\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n<p>\u307e\u305f\u3001\u30c7\u30fc\u30bf\u306f\u3059\u3079\u3066\uff11\u3064\u306e\u30d5\u30a1\u30a4\u30eb\u306b\u307e\u3068\u3081\u3089\u308c\u3066\u3044\u308b\u306e\u3067\u3001<strong>\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3059\u308b\u5834\u5408\u3082\u30b3\u30d4\u30fc\u3060\u3051\u3067OK\u3067\u3059\u3088\ud83d\ude0a\u2728<\/strong><\/p>\n<p>\u305c\u3072\u6a5f\u4f1a\u304c\u3042\u3063\u305f\u3089\u8a66\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u306d\u3002<\/p>\n<p>\u3067\u306f\u3067\u306f\u301c\u2757<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6069 aligncenter\" src=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/03\/no_20.png\" alt=\"\" width=\"326\" height=\"320\" srcset=\"https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/03\/no_20.png 326w, https:\/\/blog.capilano-fw.com\/wp-content\/uploads\/2020\/03\/no_20-300x294.png 300w\" sizes=\"auto, (max-width: 326px) 100vw, 326px\" \/><\/p>\n<p style=\"text-align: center;\">\u300c\u6a5f\u80fd\u7684\u306b\u306f\u3001\u3082\u3046Lite\u3063\u3066\u3044\u3046<br \/>\n\u30a4\u30e1\u30fc\u30b8\u3058\u3083\u306a\u3044\u3067\u3059\u306d\ud83d\udc4d\u300d<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3055\u3066\u3055\u3066\u3001\u3053\u308c\u307e\u3067\u79c1\u306f\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u69d8\u65b9\u304b\u3089\u69d8\u3005\u306a\u30bf\u30a4\u30d7\u306e\u3054\u4f9d\u983c\u3092\u53d7\u3051\u3066\u304d\u307e\u3057\u305f\u3002\u3082\u3061\u308d\u3093Laravel\u95a2\u9023\u306e\u958b\u767a\u304c\u591a\u3044\u306e\u3067\u3059\u304c\u3001\u305d\u3093\u306a\u4e2d\u3001\u5c11\u3057\u300c\u5909\u5316\u7403\u300d\u306a\u5185\u5bb9\u304c &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/blog.capilano-fw.com\/?p=6908\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;\u7c21\u5358\uff01Laravel\u3067SQLite\u3092\u4f7f\u3046\u65b9\u6cd5\uff08phpLiteAdmin\u3082\u3042\u308a\uff09&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":6916,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[213],"class_list":["post-6908","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-laravel","tag-sqlite"],"_links":{"self":[{"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=\/wp\/v2\/posts\/6908","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6908"}],"version-history":[{"count":3,"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=\/wp\/v2\/posts\/6908\/revisions"}],"predecessor-version":[{"id":6918,"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=\/wp\/v2\/posts\/6908\/revisions\/6918"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=\/wp\/v2\/media\/6916"}],"wp:attachment":[{"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capilano-fw.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}