GoLang\u3067SQLite\u3092\u4f7f\u3044\u305f\u3044\u306e\u3067\u3001Install\u3059\u308b\u3002<\/p>\n
$ ls -l \/mnt2\/slackware64\/*\/*sqlite*.txz
\n\\-rw-r–r– 1 root root 1030596 1\u6708 7 2022 \/mnt2\/slackware64\/ap\/sqlite-3.37.2-x86_64-1.txz
\n$ sudo installpkg \/mnt2\/slackware64\/ap\/sqlite-3.37.2-x86_64-1.txz
\n(\u30e1\u30e2\u7701\u7565)
\n$ grep -E ‘bin|lib’ \/var\/log\/packages\/sqlite-3.37.2-x86_64-1 | sed s@^@\/@ | xargs ldd | grep found
\n(\u4f9d\u5b58\u306e\u4e0d\u8db3\u306f\u7121\u304b\u3063\u305f)<\/p>\n
SQLite\u306f\u7d44\u307f\u8fbc\u307f\u5f0f DB\u306a\u306e\u3067\u3001Go\u306e\u30e9\u30a4\u30d6\u30e9\u30ea\u5074\u3067\u7528\u610f\u3057\u3066\u3042\u308b\u306f\u305a\u306a\u306e\u3067\u3001\u8981\u3089\u306a\u304b\u3063\u305f?\u3002
\nDB\u3092\u4f5c\u6210\u3057\u305f\u308a\u3001DB\u306e\u4e2d\u8eab\u3092\u898b\u308b\u30b3\u30de\u30f3\u30c9\u3068\u304b\u3067\u4f7f\u3046\u304b\u3002
\n\u4ee5\u524d\u4f5c\u3063\u305f\u3001\u304a\u554f\u3044\u5408\u308f\u305bTable\u3068\u540c\u3058\u69d8\u306a\u306e\u3092\u3001phpMyAdmin\u3092\u898b\u306a\u304c\u3089\u4f5c\u3063\u3066\u307f\u308b\u3002
\n$ sqlite3 smp001.db
\nSQLite version 3.37.2 2022-01-06 13:25:41
\nEnter “.help” for usage hints.
\nsqlite> create table if not exists mst_message ( code integer primary key autoincrement, name text not null, email text not null, message text not null);
\nsqlite> .tables
\nmst_message
\nsqlite> insert into mst_message ( name, email, message) values (‘test’, ‘test@test.jp’, ‘this is test’);
\nsqlite> select * from mst_message;
\n1|test|test@test.jp|this is test
\nsqlite> .exit<\/p>\n
Go\u5074\u306bgo-sqlite3\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3002
\n$ export PATH=$PATH:\/usr\/local\/go\/bin
\n$ export GOPATH=~\/go
\n$ go mod init example.net\/myproj\/oldcygwin\/practice800\/practice820
\ngo: creating new go.mod: module example.net\/myproj\/oldcygwin\/practice800\/practice820
\ngo: to add module requirements and sums:
\n\\ go mod tidy
\n$ go get github.com\/mattn\/go-sqlite3
\ngo: downloading github.com\/mattn\/go-sqlite3 v1.14.22
\ngo: added github.com\/mattn\/go-sqlite3 v1.14.22<\/p>\n
<\/p>\n
\u53c2\u8003AI\uff1a
\nhttps:\/\/chat.openai.com\/auth\/login
\n\u4ee5\u4e0b\u306eGo\u8a00\u8a9e\u306b\u3064\u3044\u3066\u3001SQLite\u3092\u4f7f\u3046\u8a18\u8ff0\u306b\u5909\u66f4
\nSQLite\u3067\u3001primary key \u3092\u30b3\u30de\u30f3\u30c9\u3067\u8a2d\u5b9a\u3059\u308b\u65b9\u6cd5\u306f\uff1f
\n\u30c6\u30fc\u30d6\u30eb\u306e\u5185\u5bb9\u3092\u8868\u793a\u3059\u308b\u30b3\u30de\u30f3\u30c9\u306f\uff1f<\/p>\n
\u53c2\u8003URL\uff1a
\nsqlite3 \u30b3\u30de\u30f3\u30c9 db\u4f5c\u6210\u3001\u3067\u30b0\u30b0\u3063\u305f\uff1a
\nhttps:\/\/www.javadrive.jp\/sqlite\/database\/index1.html
\nsqlite3 \u30b3\u30de\u30f3\u30c9\u3001\u3067\u30b0\u30b0\u3063\u305f\uff1a
\nhttps:\/\/qiita.com\/ChiakiYamaoka\/items\/b7c7863688d6f23c0501<\/p>\n
\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306e\u8aac\u660e\uff1a
\n# sqlite (simple, self contained database engine)
\n# SQLite is a small C library that implements a self-contained,
\n# embeddable, zero-configuration SQL database engine.
\n# The SQLite distribution comes with a standalone command-line access
\n# program (sqlite) that can be used to administer an SQLite database
\n# and which serves as an example of how to use the SQLite library.
\n# Homepage: http:\/\/www.sqlite.org\/<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
GoLang\u3067SQLite\u3092\u4f7f\u3044\u305f\u3044\u306e\u3067\u3001Install\u3059\u308b\u3002 $ ls -l \/mnt2\/slackware64\/*\/*sqlite*.txz \\-rw-r–r– 1 root root 103 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-181","post","type-post","status-publish","format-standard","hentry","category-web-practice"],"_links":{"self":[{"href":"https:\/\/shirakawa.weblike.jp\/blog-page\/wp-json\/wp\/v2\/posts\/181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shirakawa.weblike.jp\/blog-page\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/shirakawa.weblike.jp\/blog-page\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/shirakawa.weblike.jp\/blog-page\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/shirakawa.weblike.jp\/blog-page\/wp-json\/wp\/v2\/comments?post=181"}],"version-history":[{"count":4,"href":"https:\/\/shirakawa.weblike.jp\/blog-page\/wp-json\/wp\/v2\/posts\/181\/revisions"}],"predecessor-version":[{"id":1492,"href":"https:\/\/shirakawa.weblike.jp\/blog-page\/wp-json\/wp\/v2\/posts\/181\/revisions\/1492"}],"wp:attachment":[{"href":"https:\/\/shirakawa.weblike.jp\/blog-page\/wp-json\/wp\/v2\/media?parent=181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shirakawa.weblike.jp\/blog-page\/wp-json\/wp\/v2\/categories?post=181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shirakawa.weblike.jp\/blog-page\/wp-json\/wp\/v2\/tags?post=181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}