{"id":9869,"date":"2019-08-20T08:28:58","date_gmt":"2019-08-20T08:28:58","guid":{"rendered":"http:\/\/blog.bachi.net\/?p=9869"},"modified":"2019-11-13T19:41:53","modified_gmt":"2019-11-13T19:41:53","slug":"sqlite","status":"publish","type":"post","link":"https:\/\/blog.bachi.net\/?p=9869","title":{"rendered":"SQLite"},"content":{"rendered":"<p><a href=\"https:\/\/www.sqlite.org\/foreignkeys.html\">SQLite Foreign Key Support<\/a><br \/>\n<a href=\"https:\/\/www.sqlite.org\/autoinc.html\">SQLite Autoincrement<\/a><br \/>\n<a href=\"https:\/\/www.sqlite.org\/pragma.html\">PRAGMA Statements<\/a><br \/>\n<a href=\"https:\/\/www.sqlite.org\/wal.html\">Write-Ahead Logging<\/a><br \/>\n<a href=\"https:\/\/www.sqlite.org\/atomiccommit.html\">Atomic Commit In SQLite<\/a><br \/>\n<a href=\"https:\/\/www.sqlite.org\/transactional.html\">SQLite is Transactional<\/a><\/p>\n<h2>SQL As Understood By SQLite<\/h2>\n<p><a href=\"https:\/\/www.sqlite.org\/lang_select.html\">SELECT<\/a><br \/>\n<a href=\"https:\/\/www.sqlite.org\/lang_insert.html\">INSERT<\/a><br \/>\n<a href=\"https:\/\/www.sqlite.org\/lang_update.html\">UPDATE<\/a><br \/>\n<a href=\"https:\/\/www.sqlite.org\/lang_transaction.html\">BEGIN TRANSACTION<\/a><\/p>\n<h2>SQLite C Interface<\/h2>\n<p><a href=\"https:\/\/www.sqlite.org\/c3ref\/last_insert_rowid.html\">Last Insert Rowid<\/a><\/p>\n<h1>Tutorials<\/h1>\n<p><a href=\"https:\/\/renenyffenegger.ch\/notes\/development\/databases\/SQLite\/\">renenyffenegger.ch: SQLite<\/a><br \/>\n<a href=\"https:\/\/www.tutorialspoint.com\/sqlite\/sqlite_using_autoincrement.htm\">SQLite &#8211; AUTOINCREMENT<\/a><br \/>\n<a href=\"http:\/\/www.sqlitetutorial.net\/sqlite-autoincrement\/\">SQLite AUTOINCREMENT<\/a><br \/>\n<a href=\"https:\/\/www.sqlitetutorial.net\/sqlite-transaction\/\">SQLite Transaction<\/a><\/p>\n<h1>Command Line Shell For SQLite<\/h1>\n<p><a href=\"https:\/\/sqlite.org\/cli.html\">Command Line Shell For SQLite<\/a><\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ sqlite3.exe \/c\/Users\/andreas\/AppData\/Roaming\/DatabaseSelect\/default.sqlite\r\n\r\n.database\r\n.table\r\n.tables\r\n\r\n.mode column\r\n.header on\r\n\r\n.quit\r\n<\/pre>\n<h1>MSYS<\/h1>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n$ pacman -S sqlite3\r\n$ pacman -S sqlite-vfslog\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>SQLite Foreign Key Support SQLite Autoincrement PRAGMA Statements Write-Ahead Logging Atomic Commit In SQLite SQLite is Transactional SQL As Understood By SQLite SELECT INSERT UPDATE BEGIN TRANSACTION SQLite C Interface Last Insert Rowid Tutorials renenyffenegger.ch: SQLite SQLite &#8211; AUTOINCREMENT SQLite AUTOINCREMENT SQLite Transaction Command Line Shell For SQLite Command Line Shell For SQLite $ sqlite3.exe [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-9869","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/9869","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9869"}],"version-history":[{"count":6,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/9869\/revisions"}],"predecessor-version":[{"id":10336,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/9869\/revisions\/10336"}],"wp:attachment":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}