CINXE.COM

<!DOCTYPE html> <html class="client-nojs vector-feature-language-in-header-disabled vector-feature-language-in-main-page-header-disabled vector-feature-sticky-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref--excluded vector-feature-appearance-pinned-clientpref-1 vector-feature-night-mode-disabled skin-theme-clientpref-day vector-toc-available" lang="en" dir="ltr"> <head> <meta charset="UTF-8"> <title>Manual:SQLite - MediaWiki</title> <script>(function(){var className="client-js vector-feature-language-in-header-disabled vector-feature-language-in-main-page-header-disabled vector-feature-sticky-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref--excluded vector-feature-appearance-pinned-clientpref-1 vector-feature-night-mode-disabled skin-theme-clientpref-day vector-toc-available";var cookie=document.cookie.match(/(?:^|; )mediawikiwikimwclientpreferences=([^;]+)/);if(cookie){cookie[1].split('%2C').forEach(function(pref){className=className.replace(new RegExp('(^| )'+pref.replace(/-clientpref-\w+$|[^\w-]+/g,'')+'-clientpref-\\w+( |$)'),'$1'+pref+'$2');});}document.documentElement.className=className;}());RLCONF={"wgBreakFrames":false,"wgSeparatorTransformTable":["",""],"wgDigitTransformTable":["",""], "wgDefaultDateFormat":"dmy","wgMonthNames":["","January","February","March","April","May","June","July","August","September","October","November","December"],"wgRequestId":"d734c7d1-4680-44a0-9568-dd0c6d53342e","wgCanonicalNamespace":"Manual","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":100,"wgPageName":"Manual:SQLite","wgTitle":"SQLite","wgCurRevisionId":6850026,"wgRevisionId":6850026,"wgArticleId":26856,"wgIsArticle":true,"wgIsRedirect":false,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":["Database","Installation"],"wgPageViewLanguage":"en","wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":"Manual:SQLite","wgRelevantArticleId":26856,"wgIsProbablyEditable":false,"wgRelevantPageIsProbablyEditable":false,"wgRestrictionEdit":["autoconfirmed"],"wgRestrictionMove":["autoconfirmed"],"wgNoticeProject":"mediawiki","wgCiteReferencePreviewsActive":true,"wgMediaViewerOnClick":true,"wgMediaViewerEnabledByDefault":true, "wgVisualEditor":{"pageLanguageCode":"en","pageLanguageDir":"ltr","pageVariantFallbacks":"en"},"wgMFDisplayWikibaseDescriptions":{"search":true,"watchlist":true,"tagline":false,"nearby":true},"wgWMESchemaEditAttemptStepOversample":false,"wgWMEPageLength":10000,"wgInternalRedirectTargetUrl":"/wiki/Manual:SQLite","wgTranslatePageTranslation":"source","wgCentralAuthMobileDomain":false,"wgEditSubmitButtonLabelPublish":true,"wgULSPosition":"personal","wgULSisCompactLinksEnabled":true,"wgVector2022LanguageInHeader":false,"wgULSisLanguageSelectorEmpty":false,"wgWikibaseItemId":"Q319417","wgCheckUserClientHintsHeadersJsApi":["brands","architecture","bitness","fullVersionList","mobile","model","platform","platformVersion"]};RLSTATE={"ext.globalCssJs.user.styles":"ready","site.styles":"ready","user.styles":"ready","ext.globalCssJs.user":"ready","user":"ready","user.options":"loading","ext.translate.tag.languages":"ready","skins.vector.search.codex.styles":"ready","skins.vector.styles":"ready", "skins.vector.icons":"ready","jquery.makeCollapsible.styles":"ready","ext.translate.edit.documentation.styles":"ready","ext.translate":"ready","ext.wikimediamessages.styles":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","ext.uls.pt":"ready","wikibase.client.init":"ready","ext.wikimediaBadges":"ready"};RLPAGEMODULES=["mediawiki.action.view.redirect","site","mediawiki.page.ready","jquery.makeCollapsible","mediawiki.toc","skins.vector.js","ext.centralNotice.geoIP","ext.centralNotice.startUp","ext.translate.pagetranslation.uls","ext.urlShortener.toolbar","ext.centralauth.centralautologin","mmv.bootstrap","ext.visualEditor.desktopArticleTarget.init","ext.visualEditor.targetLoader","ext.echo.centralauth","ext.eventLogging","ext.wikimediaEvents","ext.navigationTiming","ext.uls.compactlinks","ext.uls.interface","wikibase.client.vector-2022","ext.checkUser.clientHints","wikibase.sidebar.tracking"];</script> <script>(RLQ=window.RLQ||[]).push(function(){mw.loader.impl(function(){return["user.options@12s5i",function($,jQuery,require,module){mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"}); }];});});</script> <link rel="stylesheet" href="/w/load.php?lang=en&modules=ext.translate%2CwikimediaBadges%7Cext.translate.edit.documentation.styles%7Cext.translate.tag.languages%7Cext.uls.pt%7Cext.visualEditor.desktopArticleTarget.noscript%7Cext.wikimediamessages.styles%7Cjquery.makeCollapsible.styles%7Cskins.vector.icons%2Cstyles%7Cskins.vector.search.codex.styles%7Cwikibase.client.init&only=styles&skin=vector-2022"> <script async="" src="/w/load.php?lang=en&modules=startup&only=scripts&raw=1&skin=vector-2022"></script> <meta name="ResourceLoaderDynamicStyles" content=""> <link rel="stylesheet" href="/w/load.php?lang=en&modules=site.styles&only=styles&skin=vector-2022"> <meta name="generator" content="MediaWiki 1.44.0-wmf.4"> <meta name="referrer" content="origin"> <meta name="referrer" content="origin-when-cross-origin"> <meta name="robots" content="max-image-preview:standard"> <meta name="format-detection" content="telephone=no"> <meta name="viewport" content="width=1120"> <meta property="og:site_name" content="MediaWiki"> <meta property="og:title" content="Manual:SQLite - MediaWiki"> <meta property="og:type" content="website"> <link rel="preconnect" href="//upload.wikimedia.org"> <link rel="alternate" media="only screen and (max-width: 640px)" href="//m.mediawiki.org/wiki/Manual:SQLite"> <link rel="apple-touch-icon" href="/static/apple-touch/mediawiki.png"> <link rel="icon" href="/static/favicon/mediawiki.ico"> <link rel="search" type="application/opensearchdescription+xml" href="/w/rest.php/v1/search" title="MediaWiki (en)"> <link rel="EditURI" type="application/rsd+xml" href="//www.mediawiki.org/w/api.php?action=rsd"> <link rel="canonical" href="https://www.mediawiki.org/wiki/Manual:SQLite"> <link rel="license" href="https://creativecommons.org/licenses/by-sa/4.0/"> <link rel="alternate" type="application/atom+xml" title="MediaWiki Atom feed" href="/w/index.php?title=Special:RecentChanges&feed=atom"> <link rel="dns-prefetch" href="//meta.wikimedia.org" /> <link rel="dns-prefetch" href="//login.wikimedia.org"> </head> <body class="skin--responsive skin-vector skin-vector-search-vue mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-100 ns-subject page-Manual_SQLite rootpage-Manual_SQLite skin-vector-2022 action-view"><a class="mw-jump-link" href="#bodyContent">Jump to content</a> <div class="vector-header-container"> <header class="vector-header mw-header"> <div class="vector-header-start"> <nav class="vector-main-menu-landmark" aria-label="Site"> <div id="vector-main-menu-dropdown" class="vector-dropdown vector-main-menu-dropdown vector-button-flush-left vector-button-flush-right" > <input type="checkbox" id="vector-main-menu-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-main-menu-dropdown" class="vector-dropdown-checkbox " aria-label="Main menu" > <label id="vector-main-menu-dropdown-label" for="vector-main-menu-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-menu mw-ui-icon-wikimedia-menu"></span> <span class="vector-dropdown-label-text">Main menu</span> </label> <div class="vector-dropdown-content"> <div id="vector-main-menu-unpinned-container" class="vector-unpinned-container"> <div id="vector-main-menu" class="vector-main-menu vector-pinnable-element"> <div class="vector-pinnable-header vector-main-menu-pinnable-header vector-pinnable-header-unpinned" data-feature-name="main-menu-pinned" data-pinnable-element-id="vector-main-menu" data-pinned-container-id="vector-main-menu-pinned-container" data-unpinned-container-id="vector-main-menu-unpinned-container" > <div class="vector-pinnable-header-label">Main menu</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-main-menu.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-main-menu.unpin">hide</button> </div> <div id="p-navigation" class="vector-menu mw-portlet mw-portlet-navigation" > <div class="vector-menu-heading"> Navigation </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-mainpage-description" class="mw-list-item"><a href="/wiki/MediaWiki" title="Visit the main page [z]" accesskey="z"><span>Main page</span></a></li><li id="n-mw-download" class="mw-list-item"><a href="/wiki/Download"><span>Get MediaWiki</span></a></li><li id="n-mw-extensions" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Category:Extensions"><span>Get extensions</span></a></li><li id="n-blog-text" class="mw-list-item"><a href="https://techblog.wikimedia.org/"><span>Tech blog</span></a></li><li id="n-mw-contribute" class="mw-list-item"><a href="/wiki/Special:MyLanguage/How_to_contribute"><span>Contribute</span></a></li> </ul> </div> </div> <div id="p-support" class="vector-menu mw-portlet mw-portlet-support" > <div class="vector-menu-heading"> Support </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-help" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Help:Contents" title="The place to find out"><span>User help</span></a></li><li id="n-mw-faq" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Manual:FAQ"><span>FAQ</span></a></li><li id="n-mw-manual" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Manual:Contents"><span>Technical manual</span></a></li><li id="n-mw-supportdesk" class="mw-list-item"><a href="/wiki/Project:Support_desk"><span>Support desk</span></a></li><li id="n-mw-communication" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Communication"><span>Communication</span></a></li> </ul> </div> </div> <div id="p-development" class="vector-menu mw-portlet mw-portlet-development" > <div class="vector-menu-heading"> Development </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-mw-developerportal" class="mw-list-item"><a href="https://developer.wikimedia.org/"><span>Developer portal</span></a></li><li id="n-svn-statistics" class="mw-list-item"><a href="/wiki/Development_statistics"><span>Code statistics</span></a></li> </ul> </div> </div> <div id="p-mediawiki.org" class="vector-menu mw-portlet mw-portlet-mediawiki_org" > <div class="vector-menu-heading"> mediawiki.org </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-portal" class="mw-list-item"><a href="/wiki/Project:Help" title="About the project, what you can do, where to find things"><span>Community portal</span></a></li><li id="n-recentchanges" class="mw-list-item"><a href="/wiki/Special:RecentChanges" title="A list of recent changes in the wiki [r]" accesskey="r"><span>Recent changes</span></a></li><li id="n-mw-translate" class="mw-list-item"><a href="/wiki/Special:LanguageStats"><span>Translate content</span></a></li><li id="n-randompage" class="mw-list-item"><a href="/wiki/Special:Random" title="Load a random page [x]" accesskey="x"><span>Random page</span></a></li><li id="n-mw-discussion" class="mw-list-item"><a href="/wiki/Project:Village_Pump"><span>Village pump</span></a></li><li id="n-Sandboxlink-portlet-label" class="mw-list-item"><a href="/wiki/Project:Sandbox"><span>Sandbox</span></a></li> </ul> </div> </div> <div id="p-lang" class="vector-menu mw-portlet mw-portlet-lang" > <div class="vector-menu-heading"> In other languages </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li class="interlanguage-link interwiki-ar mw-list-item"><a href="https://ar.wikipedia.org/wiki/%D8%A5%D8%B3_%D9%83%D9%8A%D9%88_%D9%84%D8%A7%D9%8A%D8%AA" title="إس كيو لايت – Arabic" lang="ar" hreflang="ar" data-title="إس كيو لايت" data-language-autonym="العربية" data-language-local-name="Arabic" class="interlanguage-link-target"><span>العربية</span></a></li><li class="interlanguage-link interwiki-be mw-list-item"><a href="https://be.wikipedia.org/wiki/SQLite" title="SQLite – Belarusian" lang="be" hreflang="be" data-title="SQLite" data-language-autonym="Беларуская" data-language-local-name="Belarusian" class="interlanguage-link-target"><span>Беларуская</span></a></li><li class="interlanguage-link interwiki-bg mw-list-item"><a href="https://bg.wikipedia.org/wiki/SQLite" title="SQLite – Bulgarian" lang="bg" hreflang="bg" data-title="SQLite" data-language-autonym="Български" data-language-local-name="Bulgarian" class="interlanguage-link-target"><span>Български</span></a></li><li class="interlanguage-link interwiki-ca mw-list-item"><a href="https://ca.wikipedia.org/wiki/SQLite" title="SQLite – Catalan" lang="ca" hreflang="ca" data-title="SQLite" data-language-autonym="Català" data-language-local-name="Catalan" class="interlanguage-link-target"><span>Català</span></a></li><li class="interlanguage-link interwiki-cs mw-list-item"><a href="https://cs.wikipedia.org/wiki/SQLite" title="SQLite – Czech" lang="cs" hreflang="cs" data-title="SQLite" data-language-autonym="Čeština" data-language-local-name="Czech" class="interlanguage-link-target"><span>Čeština</span></a></li><li class="interlanguage-link interwiki-de mw-list-item"><a href="https://de.wikipedia.org/wiki/SQLite" title="SQLite – German" lang="de" hreflang="de" data-title="SQLite" data-language-autonym="Deutsch" data-language-local-name="German" class="interlanguage-link-target"><span>Deutsch</span></a></li><li class="interlanguage-link interwiki-el mw-list-item"><a href="https://el.wikipedia.org/wiki/SQLite" title="SQLite – Greek" lang="el" hreflang="el" data-title="SQLite" data-language-autonym="Ελληνικά" data-language-local-name="Greek" class="interlanguage-link-target"><span>Ελληνικά</span></a></li><li class="interlanguage-link interwiki-en mw-list-item"><a href="https://en.wikipedia.org/wiki/SQLite" title="SQLite – English" lang="en" hreflang="en" data-title="SQLite" data-language-autonym="English" data-language-local-name="English" class="interlanguage-link-target"><span>English</span></a></li><li class="interlanguage-link interwiki-es mw-list-item"><a href="https://es.wikipedia.org/wiki/SQLite" title="SQLite – Spanish" lang="es" hreflang="es" data-title="SQLite" data-language-autonym="Español" data-language-local-name="Spanish" class="interlanguage-link-target"><span>Español</span></a></li><li class="interlanguage-link interwiki-fa mw-list-item"><a href="https://fa.wikipedia.org/wiki/%D8%A7%D8%B3%E2%80%8C%DA%A9%DB%8C%D9%88%D8%A7%D9%84_%D9%84%D8%A7%DB%8C%D8%AA" title="اس‌کیوال لایت – Persian" lang="fa" hreflang="fa" data-title="اس‌کیوال لایت" data-language-autonym="فارسی" data-language-local-name="Persian" class="interlanguage-link-target"><span>فارسی</span></a></li><li class="interlanguage-link interwiki-fi mw-list-item"><a href="https://fi.wikipedia.org/wiki/SQLite" title="SQLite – Finnish" lang="fi" hreflang="fi" data-title="SQLite" data-language-autonym="Suomi" data-language-local-name="Finnish" class="interlanguage-link-target"><span>Suomi</span></a></li><li class="interlanguage-link interwiki-fr mw-list-item"><a href="https://fr.wikipedia.org/wiki/SQLite" title="SQLite – French" lang="fr" hreflang="fr" data-title="SQLite" data-language-autonym="Français" data-language-local-name="French" class="interlanguage-link-target"><span>Français</span></a></li><li class="interlanguage-link interwiki-he mw-list-item"><a href="https://he.wikipedia.org/wiki/SQLite" title="SQLite – Hebrew" lang="he" hreflang="he" data-title="SQLite" data-language-autonym="עברית" data-language-local-name="Hebrew" class="interlanguage-link-target"><span>עברית</span></a></li><li class="interlanguage-link interwiki-hi mw-list-item"><a href="https://hi.wikipedia.org/wiki/%E0%A4%8F%E0%A4%B8%E0%A4%95%E0%A5%8D%E0%A4%AF%E0%A5%82%E0%A4%B2%E0%A4%BE%E0%A4%87%E0%A4%9F" title="एसक्यूलाइट – Hindi" lang="hi" hreflang="hi" data-title="एसक्यूलाइट" data-language-autonym="हिन्दी" data-language-local-name="Hindi" class="interlanguage-link-target"><span>हिन्दी</span></a></li><li class="interlanguage-link interwiki-hr mw-list-item"><a href="https://hr.wikipedia.org/wiki/SQLite" title="SQLite – Croatian" lang="hr" hreflang="hr" data-title="SQLite" data-language-autonym="Hrvatski" data-language-local-name="Croatian" class="interlanguage-link-target"><span>Hrvatski</span></a></li><li class="interlanguage-link interwiki-hu mw-list-item"><a href="https://hu.wikipedia.org/wiki/SQLite" title="SQLite – Hungarian" lang="hu" hreflang="hu" data-title="SQLite" data-language-autonym="Magyar" data-language-local-name="Hungarian" class="interlanguage-link-target"><span>Magyar</span></a></li><li class="interlanguage-link interwiki-id mw-list-item"><a href="https://id.wikipedia.org/wiki/SQLite" title="SQLite – Indonesian" lang="id" hreflang="id" data-title="SQLite" data-language-autonym="Bahasa Indonesia" data-language-local-name="Indonesian" class="interlanguage-link-target"><span>Bahasa Indonesia</span></a></li><li class="interlanguage-link interwiki-it mw-list-item"><a href="https://it.wikipedia.org/wiki/SQLite" title="SQLite – Italian" lang="it" hreflang="it" data-title="SQLite" data-language-autonym="Italiano" data-language-local-name="Italian" class="interlanguage-link-target"><span>Italiano</span></a></li><li class="interlanguage-link interwiki-ja mw-list-item"><a href="https://ja.wikipedia.org/wiki/SQLite" title="SQLite – Japanese" lang="ja" hreflang="ja" data-title="SQLite" data-language-autonym="日本語" data-language-local-name="Japanese" class="interlanguage-link-target"><span>日本語</span></a></li><li class="interlanguage-link interwiki-ko mw-list-item"><a href="https://ko.wikipedia.org/wiki/SQLite" title="SQLite – Korean" lang="ko" hreflang="ko" data-title="SQLite" data-language-autonym="한국어" data-language-local-name="Korean" class="interlanguage-link-target"><span>한국어</span></a></li><li class="interlanguage-link interwiki-lt mw-list-item"><a href="https://lt.wikipedia.org/wiki/SQLite" title="SQLite – Lithuanian" lang="lt" hreflang="lt" data-title="SQLite" data-language-autonym="Lietuvių" data-language-local-name="Lithuanian" class="interlanguage-link-target"><span>Lietuvių</span></a></li><li class="interlanguage-link interwiki-lv mw-list-item"><a href="https://lv.wikipedia.org/wiki/SQLite" title="SQLite – Latvian" lang="lv" hreflang="lv" data-title="SQLite" data-language-autonym="Latviešu" data-language-local-name="Latvian" class="interlanguage-link-target"><span>Latviešu</span></a></li><li class="interlanguage-link interwiki-my mw-list-item"><a href="https://my.wikipedia.org/wiki/SQLite" title="SQLite – Burmese" lang="my" hreflang="my" data-title="SQLite" data-language-autonym="မြန်မာဘာသာ" data-language-local-name="Burmese" class="interlanguage-link-target"><span>မြန်မာဘာသာ</span></a></li><li class="interlanguage-link interwiki-nl mw-list-item"><a href="https://nl.wikipedia.org/wiki/SQLite" title="SQLite – Dutch" lang="nl" hreflang="nl" data-title="SQLite" data-language-autonym="Nederlands" data-language-local-name="Dutch" class="interlanguage-link-target"><span>Nederlands</span></a></li><li class="interlanguage-link interwiki-no mw-list-item"><a href="https://no.wikipedia.org/wiki/SQLite" title="SQLite – Norwegian Bokmål" lang="nb" hreflang="nb" data-title="SQLite" data-language-autonym="Norsk bokmål" data-language-local-name="Norwegian Bokmål" class="interlanguage-link-target"><span>Norsk bokmål</span></a></li><li class="interlanguage-link interwiki-pl mw-list-item"><a href="https://pl.wikipedia.org/wiki/SQLite" title="SQLite – Polish" lang="pl" hreflang="pl" data-title="SQLite" data-language-autonym="Polski" data-language-local-name="Polish" class="interlanguage-link-target"><span>Polski</span></a></li><li class="interlanguage-link interwiki-pt mw-list-item"><a href="https://pt.wikipedia.org/wiki/SQLite" title="SQLite – Portuguese" lang="pt" hreflang="pt" data-title="SQLite" data-language-autonym="Português" data-language-local-name="Portuguese" class="interlanguage-link-target"><span>Português</span></a></li><li class="interlanguage-link interwiki-ro mw-list-item"><a href="https://ro.wikipedia.org/wiki/SQLite" title="SQLite – Romanian" lang="ro" hreflang="ro" data-title="SQLite" data-language-autonym="Română" data-language-local-name="Romanian" class="interlanguage-link-target"><span>Română</span></a></li><li class="interlanguage-link interwiki-ru mw-list-item"><a href="https://ru.wikipedia.org/wiki/SQLite" title="SQLite – Russian" lang="ru" hreflang="ru" data-title="SQLite" data-language-autonym="Русский" data-language-local-name="Russian" class="interlanguage-link-target"><span>Русский</span></a></li><li class="interlanguage-link interwiki-sr mw-list-item"><a href="https://sr.wikipedia.org/wiki/SQLite" title="SQLite – Serbian" lang="sr" hreflang="sr" data-title="SQLite" data-language-autonym="Српски / srpski" data-language-local-name="Serbian" class="interlanguage-link-target"><span>Српски / srpski</span></a></li><li class="interlanguage-link interwiki-sv mw-list-item"><a href="https://sv.wikipedia.org/wiki/SQLite" title="SQLite – Swedish" lang="sv" hreflang="sv" data-title="SQLite" data-language-autonym="Svenska" data-language-local-name="Swedish" class="interlanguage-link-target"><span>Svenska</span></a></li><li class="interlanguage-link interwiki-tr mw-list-item"><a href="https://tr.wikipedia.org/wiki/SQLite" title="SQLite – Turkish" lang="tr" hreflang="tr" data-title="SQLite" data-language-autonym="Türkçe" data-language-local-name="Turkish" class="interlanguage-link-target"><span>Türkçe</span></a></li><li class="interlanguage-link interwiki-uk mw-list-item"><a href="https://uk.wikipedia.org/wiki/SQLite" title="SQLite – Ukrainian" lang="uk" hreflang="uk" data-title="SQLite" data-language-autonym="Українська" data-language-local-name="Ukrainian" class="interlanguage-link-target"><span>Українська</span></a></li><li class="interlanguage-link interwiki-vi mw-list-item"><a href="https://vi.wikipedia.org/wiki/SQLite" title="SQLite – Vietnamese" lang="vi" hreflang="vi" data-title="SQLite" data-language-autonym="Tiếng Việt" data-language-local-name="Vietnamese" class="interlanguage-link-target"><span>Tiếng Việt</span></a></li><li class="interlanguage-link interwiki-zh mw-list-item"><a href="https://zh.wikipedia.org/wiki/SQLite" title="SQLite – Chinese" lang="zh" hreflang="zh" data-title="SQLite" data-language-autonym="中文" data-language-local-name="Chinese" class="interlanguage-link-target"><span>中文</span></a></li><li class="interlanguage-link interwiki-zh-min-nan mw-list-item"><a href="https://zh-min-nan.wikipedia.org/wiki/SQLite" title="SQLite – Minnan" lang="nan" hreflang="nan" data-title="SQLite" data-language-autonym="閩南語 / Bân-lâm-gú" data-language-local-name="Minnan" class="interlanguage-link-target"><span>閩南語 / Bân-lâm-gú</span></a></li> </ul> <div class="after-portlet after-portlet-lang"><span class="wb-langlinks-edit wb-langlinks-link"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q319417#sitelinks-wikipedia" title="Edit interlanguage links" class="wbc-editpage">Edit links</a></span></div> </div> </div> </div> </div> </div> </div> </nav> <a href="/wiki/MediaWiki" class="mw-logo"> <img class="mw-logo-icon" src="/static/images/icons/mediawikiwiki.svg" alt="" aria-hidden="true" height="50" width="50"> <span class="mw-logo-container skin-invert"> <img class="mw-logo-wordmark" alt="MediaWiki" src="/static/images/mobile/copyright/mediawikiwiki-wordmark.svg" style="width: 7.5em; height: 1.125em;"> </span> </a> </div> <div class="vector-header-end"> <div id="p-search" role="search" class="vector-search-box-vue vector-search-box-collapses vector-search-box-show-thumbnail vector-search-box-auto-expand-width vector-search-box"> <a href="/wiki/Special:Search" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only search-toggle" title="Search MediaWiki [f]" accesskey="f"><span class="vector-icon mw-ui-icon-search mw-ui-icon-wikimedia-search"></span> <span>Search</span> </a> <div class="vector-typeahead-search-container"> <div class="cdx-typeahead-search cdx-typeahead-search--show-thumbnail cdx-typeahead-search--auto-expand-width"> <form action="/w/index.php" id="searchform" class="cdx-search-input cdx-search-input--has-end-button"> <div id="simpleSearch" class="cdx-search-input__input-wrapper" data-search-loc="header-moved"> <div class="cdx-text-input cdx-text-input--has-start-icon"> <input class="cdx-text-input__input" type="search" name="search" placeholder="Search MediaWiki" aria-label="Search MediaWiki" autocapitalize="sentences" title="Search MediaWiki [f]" accesskey="f" id="searchInput" > <span class="cdx-text-input__icon cdx-text-input__start-icon"></span> </div> <input type="hidden" name="title" value="Special:Search"> </div> <button class="cdx-button cdx-search-input__end-button">Search</button> </form> </div> </div> </div> <nav class="vector-user-links vector-user-links-wide" aria-label="Personal tools"> <div class="vector-user-links-main"> <div id="p-vector-user-menu-preferences" class="vector-menu mw-portlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-uls" class="mw-list-item active user-links-collapsible-item"><a data-mw="interface" href="#" class="uls-trigger cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet"><span class="vector-icon mw-ui-icon-wikimedia-language mw-ui-icon-wikimedia-wikimedia-language"></span> <span>English</span></a> </li> </ul> </div> </div> <div id="p-vector-user-menu-userpage" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <nav class="vector-appearance-landmark" aria-label="Appearance"> <div id="vector-appearance-dropdown" class="vector-dropdown " title="Change the appearance of the page's font size, width, and color" > <input type="checkbox" id="vector-appearance-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-appearance-dropdown" class="vector-dropdown-checkbox " aria-label="Appearance" > <label id="vector-appearance-dropdown-label" for="vector-appearance-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-appearance mw-ui-icon-wikimedia-appearance"></span> <span class="vector-dropdown-label-text">Appearance</span> </label> <div class="vector-dropdown-content"> <div id="vector-appearance-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <div id="p-vector-user-menu-notifications" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <div id="p-vector-user-menu-overflow" class="vector-menu mw-portlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-sitesupport-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="https://donate.wikimedia.org/?utm_source=donate&utm_medium=sidebar&utm_campaign=spontaneous&uselang=en" class=""><span>Donate</span></a> </li> <li id="pt-createaccount-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="/w/index.php?title=Special:CreateAccount&returnto=Manual%3ASQLite" title="You are encouraged to create an account and log in; however, it is not mandatory" class=""><span>Create account</span></a> </li> <li id="pt-login-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="/w/index.php?title=Special:UserLogin&returnto=Manual%3ASQLite" title="You are encouraged to log in; however, it is not mandatory [o]" accesskey="o" class=""><span>Log in</span></a> </li> </ul> </div> </div> </div> <div id="vector-user-links-dropdown" class="vector-dropdown vector-user-menu vector-button-flush-right vector-user-menu-logged-out" title="More options" > <input type="checkbox" id="vector-user-links-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-user-links-dropdown" class="vector-dropdown-checkbox " aria-label="Personal tools" > <label id="vector-user-links-dropdown-label" for="vector-user-links-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-ellipsis mw-ui-icon-wikimedia-ellipsis"></span> <span class="vector-dropdown-label-text">Personal tools</span> </label> <div class="vector-dropdown-content"> <div id="p-personal" class="vector-menu mw-portlet mw-portlet-personal user-links-collapsible-item" title="User menu" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-sitesupport" class="user-links-collapsible-item mw-list-item"><a href="https://donate.wikimedia.org/?utm_source=donate&utm_medium=sidebar&utm_campaign=spontaneous&uselang=en"><span>Donate</span></a></li><li id="pt-createaccount" class="user-links-collapsible-item mw-list-item"><a href="/w/index.php?title=Special:CreateAccount&returnto=Manual%3ASQLite" title="You are encouraged to create an account and log in; however, it is not mandatory"><span class="vector-icon mw-ui-icon-userAdd mw-ui-icon-wikimedia-userAdd"></span> <span>Create account</span></a></li><li id="pt-login" class="user-links-collapsible-item mw-list-item"><a href="/w/index.php?title=Special:UserLogin&returnto=Manual%3ASQLite" title="You are encouraged to log in; however, it is not mandatory [o]" accesskey="o"><span class="vector-icon mw-ui-icon-logIn mw-ui-icon-wikimedia-logIn"></span> <span>Log in</span></a></li> </ul> </div> </div> <div id="p-user-menu-anon-editor" class="vector-menu mw-portlet mw-portlet-user-menu-anon-editor" > <div class="vector-menu-heading"> Pages for logged out editors <a href="/wiki/Help:Introduction" aria-label="Learn more about editing"><span>learn more</span></a> </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-anoncontribs" class="mw-list-item"><a href="/wiki/Special:MyContributions" title="A list of edits made from this IP address [y]" accesskey="y"><span>Contributions</span></a></li><li id="pt-anontalk" class="mw-list-item"><a href="/wiki/Special:MyTalk" title="Discussion about edits from this IP address [n]" accesskey="n"><span>Talk</span></a></li> </ul> </div> </div> </div> </div> </nav> </div> </header> </div> <div class="mw-page-container"> <div class="mw-page-container-inner"> <div class="vector-sitenotice-container"> <div id="siteNotice"></div> </div> <div class="vector-column-start"> <div class="vector-main-menu-container"> <div id="mw-navigation"> <nav id="mw-panel" class="vector-main-menu-landmark" aria-label="Site"> <div id="vector-main-menu-pinned-container" class="vector-pinned-container"> </div> </nav> </div> </div> <div class="vector-sticky-pinned-container"> <nav id="mw-panel-toc" aria-label="Contents" data-event-name="ui.sidebar-toc" class="mw-table-of-contents-container vector-toc-landmark"> <div id="vector-toc-pinned-container" class="vector-pinned-container"> <div id="vector-toc" class="vector-toc vector-pinnable-element"> <div class="vector-pinnable-header vector-toc-pinnable-header vector-pinnable-header-pinned" data-feature-name="toc-pinned" data-pinnable-element-id="vector-toc" > <h2 class="vector-pinnable-header-label">Contents</h2> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-toc.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-toc.unpin">hide</button> </div> <ul class="vector-toc-contents" id="mw-panel-toc-list"> <li id="toc-mw-content-text" class="vector-toc-list-item vector-toc-level-1"> <a href="#" class="vector-toc-link"> <div class="vector-toc-text">Beginning</div> </a> </li> <li id="toc-Is_SQLite_a_good_choice_for_MediaWiki?" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Is_SQLite_a_good_choice_for_MediaWiki?"> <div class="vector-toc-text"> <span class="vector-toc-numb">1</span> <span>Is SQLite a good choice for MediaWiki?</span> </div> </a> <ul id="toc-Is_SQLite_a_good_choice_for_MediaWiki?-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-About_SQLite" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#About_SQLite"> <div class="vector-toc-text"> <span class="vector-toc-numb">2</span> <span>About SQLite</span> </div> </a> <ul id="toc-About_SQLite-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-SQLite_installation" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#SQLite_installation"> <div class="vector-toc-text"> <span class="vector-toc-numb">3</span> <span>SQLite installation</span> </div> </a> <ul id="toc-SQLite_installation-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Installing_MediaWiki_on_SQLite_backend" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Installing_MediaWiki_on_SQLite_backend"> <div class="vector-toc-text"> <span class="vector-toc-numb">4</span> <span>Installing MediaWiki on SQLite backend</span> </div> </a> <ul id="toc-Installing_MediaWiki_on_SQLite_backend-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Search_engine" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Search_engine"> <div class="vector-toc-text"> <span class="vector-toc-numb">5</span> <span>Search engine</span> </div> </a> <ul id="toc-Search_engine-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Backing_up" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Backing_up"> <div class="vector-toc-text"> <span class="vector-toc-numb">6</span> <span>Backing up</span> </div> </a> <ul id="toc-Backing_up-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Troubleshooting" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Troubleshooting"> <div class="vector-toc-text"> <span class="vector-toc-numb">7</span> <span>Troubleshooting</span> </div> </a> <button aria-controls="toc-Troubleshooting-sublist" class="cdx-button cdx-button--weight-quiet cdx-button--icon-only vector-toc-toggle"> <span class="vector-icon mw-ui-icon-wikimedia-expand"></span> <span>Toggle Troubleshooting subsection</span> </button> <ul id="toc-Troubleshooting-sublist" class="vector-toc-list"> <li id="toc-Unable_to_access_the_database_on_the_terminal" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#Unable_to_access_the_database_on_the_terminal"> <div class="vector-toc-text"> <span class="vector-toc-numb">7.1</span> <span>Unable to access the database on the terminal</span> </div> </a> <ul id="toc-Unable_to_access_the_database_on_the_terminal-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Problems" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#Problems"> <div class="vector-toc-text"> <span class="vector-toc-numb">7.2</span> <span>Problems</span> </div> </a> <ul id="toc-Problems-sublist" class="vector-toc-list"> </ul> </li> </ul> </li> <li id="toc-Performance_Tips" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Performance_Tips"> <div class="vector-toc-text"> <span class="vector-toc-numb">8</span> <span>Performance Tips</span> </div> </a> <ul id="toc-Performance_Tips-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-See_also" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#See_also"> <div class="vector-toc-text"> <span class="vector-toc-numb">9</span> <span>See also</span> </div> </a> <ul id="toc-See_also-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-External_links" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#External_links"> <div class="vector-toc-text"> <span class="vector-toc-numb">10</span> <span>External links</span> </div> </a> <ul id="toc-External_links-sublist" class="vector-toc-list"> </ul> </li> </ul> </div> </div> </nav> </div> </div> <div class="mw-content-container"> <main id="content" class="mw-body"> <header class="mw-body-header vector-page-titlebar"> <nav aria-label="Contents" class="vector-toc-landmark"> <div id="vector-page-titlebar-toc" class="vector-dropdown vector-page-titlebar-toc vector-button-flush-left" > <input type="checkbox" id="vector-page-titlebar-toc-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-page-titlebar-toc" class="vector-dropdown-checkbox " aria-label="Toggle the table of contents" > <label id="vector-page-titlebar-toc-label" for="vector-page-titlebar-toc-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-listBullet mw-ui-icon-wikimedia-listBullet"></span> <span class="vector-dropdown-label-text">Toggle the table of contents</span> </label> <div class="vector-dropdown-content"> <div id="vector-page-titlebar-toc-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <h1 id="firstHeading" class="firstHeading mw-first-heading"><span class="mw-page-title-namespace">Manual</span><span class="mw-page-title-separator">:</span><span class="mw-page-title-main">SQLite</span></h1> <div class="mw-indicators"> </div> </header> <div class="vector-page-toolbar"> <div class="vector-page-toolbar-container"> <div id="left-navigation"> <nav aria-label="Namespaces"> <div id="p-associated-pages" class="vector-menu vector-menu-tabs mw-portlet mw-portlet-associated-pages" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-nstab-manual" class="selected vector-tab-noicon mw-list-item"><a href="/wiki/Manual:SQLite" title="View the subject page [c]" accesskey="c"><span>Manual</span></a></li><li id="ca-talk" class="vector-tab-noicon mw-list-item"><a href="/wiki/Manual_talk:SQLite" rel="discussion" title="Discussion about the content page [t]" accesskey="t"><span>Discussion</span></a></li> </ul> </div> </div> <div id="vector-variants-dropdown" class="vector-dropdown emptyPortlet" > <input type="checkbox" id="vector-variants-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-variants-dropdown" class="vector-dropdown-checkbox " aria-label="Change language variant" > <label id="vector-variants-dropdown-label" for="vector-variants-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet" aria-hidden="true" ><span class="vector-dropdown-label-text">English</span> </label> <div class="vector-dropdown-content"> <div id="p-variants" class="vector-menu mw-portlet mw-portlet-variants emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> </div> </div> </nav> </div> <div id="right-navigation" class="vector-collapsible"> <nav aria-label="Views"> <div id="p-views" class="vector-menu vector-menu-tabs mw-portlet mw-portlet-views" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-view" class="selected vector-tab-noicon mw-list-item"><a href="/wiki/Manual:SQLite"><span>Read</span></a></li><li id="ca-viewsource" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Manual:SQLite&action=edit" title="This page is protected.
You can view its source [e]" accesskey="e"><span>View source</span></a></li><li id="ca-history" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Manual:SQLite&action=history" title="Past revisions of this page [h]" accesskey="h"><span>View history</span></a></li> </ul> </div> </div> </nav> <nav class="vector-page-tools-landmark" aria-label="Page tools"> <div id="vector-page-tools-dropdown" class="vector-dropdown vector-page-tools-dropdown" > <input type="checkbox" id="vector-page-tools-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-page-tools-dropdown" class="vector-dropdown-checkbox " aria-label="Tools" > <label id="vector-page-tools-dropdown-label" for="vector-page-tools-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet" aria-hidden="true" ><span class="vector-dropdown-label-text">Tools</span> </label> <div class="vector-dropdown-content"> <div id="vector-page-tools-unpinned-container" class="vector-unpinned-container"> <div id="vector-page-tools" class="vector-page-tools vector-pinnable-element"> <div class="vector-pinnable-header vector-page-tools-pinnable-header vector-pinnable-header-unpinned" data-feature-name="page-tools-pinned" data-pinnable-element-id="vector-page-tools" data-pinned-container-id="vector-page-tools-pinned-container" data-unpinned-container-id="vector-page-tools-unpinned-container" > <div class="vector-pinnable-header-label">Tools</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-page-tools.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-page-tools.unpin">hide</button> </div> <div id="p-cactions" class="vector-menu mw-portlet mw-portlet-cactions emptyPortlet vector-has-collapsible-items" title="More options" > <div class="vector-menu-heading"> Actions </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-more-view" class="selected vector-more-collapsible-item mw-list-item"><a href="/wiki/Manual:SQLite"><span>Read</span></a></li><li id="ca-more-viewsource" class="vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=Manual:SQLite&action=edit"><span>View source</span></a></li><li id="ca-more-history" class="vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=Manual:SQLite&action=history"><span>View history</span></a></li> </ul> </div> </div> <div id="p-tb" class="vector-menu mw-portlet mw-portlet-tb" > <div class="vector-menu-heading"> General </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-whatlinkshere" class="mw-list-item"><a href="/wiki/Special:WhatLinksHere/Manual:SQLite" title="A list of all wiki pages that link here [j]" accesskey="j"><span>What links here</span></a></li><li id="t-recentchangeslinked" class="mw-list-item"><a href="/wiki/Special:RecentChangesLinked/Manual:SQLite" rel="nofollow" title="Recent changes in pages linked from this page [k]" accesskey="k"><span>Related changes</span></a></li><li id="t-upload" class="mw-list-item"><a href="//commons.wikimedia.org/wiki/Special:UploadWizard" title="Upload files [u]" accesskey="u"><span>Upload file</span></a></li><li id="t-specialpages" class="mw-list-item"><a href="/wiki/Special:SpecialPages" title="A list of all special pages [q]" accesskey="q"><span>Special pages</span></a></li><li id="t-permalink" class="mw-list-item"><a href="/w/index.php?title=Manual:SQLite&oldid=6850026" title="Permanent link to this revision of this page"><span>Permanent link</span></a></li><li id="t-info" class="mw-list-item"><a href="/w/index.php?title=Manual:SQLite&action=info" title="More information about this page"><span>Page information</span></a></li><li id="t-cite" class="mw-list-item"><a href="/w/index.php?title=Special:CiteThisPage&page=Manual%3ASQLite&id=6850026&wpFormIdentifier=titleform" title="Information on how to cite this page"><span>Cite this page</span></a></li><li id="t-urlshortener" class="mw-list-item"><a href="/w/index.php?title=Special:UrlShortener&url=https%3A%2F%2Fwww.mediawiki.org%2Fwiki%2FManual%3ASQLite"><span>Get shortened URL</span></a></li><li id="t-urlshortener-qrcode" class="mw-list-item"><a href="/w/index.php?title=Special:QrCode&url=https%3A%2F%2Fwww.mediawiki.org%2Fwiki%2FManual%3ASQLite"><span>Download QR code</span></a></li> </ul> </div> </div> <div id="p-coll-print_export" class="vector-menu mw-portlet mw-portlet-coll-print_export" > <div class="vector-menu-heading"> Print/export </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="coll-create_a_book" class="mw-list-item"><a href="/w/index.php?title=Special:Book&bookcmd=book_creator&referer=Manual%3ASQLite"><span>Create a book</span></a></li><li id="coll-download-as-rl" class="mw-list-item"><a href="/w/index.php?title=Special:DownloadAsPdf&page=Manual%3ASQLite&action=show-download-screen"><span>Download as PDF</span></a></li><li id="t-print" class="mw-list-item"><a href="/w/index.php?title=Manual:SQLite&printable=yes" title="Printable version of this page [p]" accesskey="p"><span>Printable version</span></a></li> </ul> </div> </div> <div id="p-wikibase-otherprojects" class="vector-menu mw-portlet mw-portlet-wikibase-otherprojects" > <div class="vector-menu-heading"> In other projects </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li class="wb-otherproject-link wb-otherproject-commons mw-list-item"><a href="https://commons.wikimedia.org/wiki/Category:SQLite" hreflang="en"><span>Wikimedia Commons</span></a></li><li class="wb-otherproject-link wb-otherproject-wikibooks mw-list-item"><a href="https://en.wikibooks.org/wiki/SQLite" hreflang="en"><span>Wikibooks</span></a></li><li class="wb-otherproject-link wb-otherproject-wikipedia mw-list-item"><a href="https://en.wikipedia.org/wiki/SQLite" hreflang="en"><span>Wikipedia</span></a></li><li id="t-wikibase" class="wb-otherproject-link wb-otherproject-wikibase-dataitem mw-list-item"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q319417" title="Link to connected data repository item [g]" accesskey="g"><span>Wikidata item</span></a></li> </ul> </div> </div> </div> </div> </div> </div> </nav> </div> </div> </div> <div class="vector-column-end"> <div class="vector-sticky-pinned-container"> <nav class="vector-page-tools-landmark" aria-label="Page tools"> <div id="vector-page-tools-pinned-container" class="vector-pinned-container"> </div> </nav> <nav class="vector-appearance-landmark" aria-label="Appearance"> <div id="vector-appearance-pinned-container" class="vector-pinned-container"> <div id="vector-appearance" class="vector-appearance vector-pinnable-element"> <div class="vector-pinnable-header vector-appearance-pinnable-header vector-pinnable-header-pinned" data-feature-name="appearance-pinned" data-pinnable-element-id="vector-appearance" data-pinned-container-id="vector-appearance-pinned-container" data-unpinned-container-id="vector-appearance-unpinned-container" > <div class="vector-pinnable-header-label">Appearance</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-appearance.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-appearance.unpin">hide</button> </div> </div> </div> </nav> </div> </div> <div id="bodyContent" class="vector-body" aria-labelledby="firstHeading" data-mw-ve-target-container> <div class="vector-body-before-content"> <div id="siteSub" class="noprint">From mediawiki.org</div> </div> <div id="contentSub"><div id="mw-content-subtitle"></div></div> <div id="mw-content-text" class="mw-body-content"><div class="mw-pt-translate-header noprint nomobile" dir="ltr" lang="en"><a href="/w/index.php?title=Special:Translate&group=page-Manual%3ASQLite&action=page&filter=&action_source=translate_page" title="Special:Translate">Translate this page</a></div><div class="mw-content-ltr mw-parser-output" lang="en" dir="ltr"><div class="mw-pt-languages noprint navigation-not-searchable" lang="en" dir="ltr"><div class="mw-pt-languages-label">Languages:</div><ul class="mw-pt-languages-list"><li><a href="/wiki/Manual:SQLite/de" class="mw-pt-progress mw-pt-progress--high" title="Handbuch:SQLite (96% translated)" lang="de" dir="ltr">Deutsch</a></li> <li><span class="mw-pt-languages-ui mw-pt-languages-selected mw-pt-progress mw-pt-progress--complete" lang="en" dir="ltr">English</span></li> <li><a href="/wiki/Manual:SQLite/nl" class="mw-pt-progress mw-pt-progress--complete" title="Handleiding:SQLite (100% translated)" lang="nl" dir="ltr">Nederlands</a></li> <li><a href="/wiki/Manual:SQLite/fr" class="mw-pt-progress mw-pt-progress--complete" title="SQLite (100% translated)" lang="fr" dir="ltr">français</a></li> <li><a href="/wiki/Manual:SQLite/pl" class="mw-pt-progress mw-pt-progress--low" title="Podręcznik:SQLite (14% translated)" lang="pl" dir="ltr">polski</a></li> <li><a href="/wiki/Manual:SQLite/cs" class="mw-pt-progress mw-pt-progress--complete" title="Příručka:SQLite (100% translated)" lang="cs" dir="ltr">čeština</a></li> <li><a href="/wiki/Manual:SQLite/ru" class="mw-pt-progress mw-pt-progress--med" title="Manual:SQLite/ru (67% translated)" lang="ru" dir="ltr">русский</a></li> <li><a href="/wiki/Manual:SQLite/ar" class="mw-pt-progress mw-pt-progress--complete" title="دليل:SQLite (100% translated)" lang="ar" dir="rtl">العربية</a></li> <li><a href="/wiki/Manual:SQLite/hi" class="mw-pt-progress mw-pt-progress--high" title="मैन्युअल:SQLite (96% translated)" lang="hi" dir="ltr">हिन्दी</a></li> <li><a href="/wiki/Manual:SQLite/zh" class="mw-pt-progress mw-pt-progress--high" title="手册:SQLite (89% translated)" lang="zh" dir="ltr">中文</a></li> <li><a href="/wiki/Manual:SQLite/ja" class="mw-pt-progress mw-pt-progress--med" title="Manual:SQLite (29% translated)" lang="ja" dir="ltr">日本語</a></li></ul></div> <figure class="mw-halign-right" typeof="mw:File"><a href="/wiki/File:SQLite370.svg" class="mw-file-description" title="SQLite logo"><img alt="SQLite logo" src="//upload.wikimedia.org/wikipedia/commons/thumb/3/38/SQLite370.svg/200px-SQLite370.svg.png" decoding="async" width="200" height="95" class="mw-file-element" srcset="//upload.wikimedia.org/wikipedia/commons/thumb/3/38/SQLite370.svg/300px-SQLite370.svg.png 1.5x, //upload.wikimedia.org/wikipedia/commons/thumb/3/38/SQLite370.svg/400px-SQLite370.svg.png 2x" data-file-width="382" data-file-height="181" /></a><figcaption>SQLite logo</figcaption></figure> <p>The purpose of this page is to collect information and experiences about running MediaWiki on <a rel="nofollow" class="external text" href="https://www.sqlite.org/">SQLite</a>. </p><p>MediaWiki supports SQLite since 1.17, but please note that this is second-class support, and you may likely run into some bugs. The database most commonly used with MediaWiki is <a href="/wiki/Special:MyLanguage/Manual:MySQL" title="Special:MyLanguage/Manual:MySQL">MySQL</a><span style="display:none"><a href="/wiki/Manual:MySQL" title="Manual:MySQL"> </a></span>. See <a href="https://phabricator.wikimedia.org/tag/sqlite" class="extiw" title="phab:tag/sqlite">Phabricator</a> for a list of issues. MediaWiki requires SQLite <span class="plainlinks"><a class="external text" href="https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/core/+/59f4c323238de385e4d69d71a3a04b994c018d1b">3.8.0</a></span> or later. Support for SQLite by extensions which make database changes is varied. </p> <meta property="mw:PageProp/toc" /> <div class="mw-heading mw-heading2"><h2 id="Is_SQLite_a_good_choice_for_MediaWiki?"><span id="Is_SQLite_a_good_choice_for_MediaWiki.3F"></span>Is SQLite a good choice for MediaWiki?</h2></div> <p>There are two important caveats to using SQLite for MediaWiki. First, while many extensions do support SQLite, there are some popular extensions that still do not support it to this day. Second, SQLite does not scale beyond one server. In case your wiki may grow to have many concurrent users and a large amount of content, it would be better to use a database system that supports the primary-replica model such as MySQL. As a result, if your wiki may depend on using these extensions, or it may need to use a primary-replica database system, it is best to use a MySQL database for your wiki. The decision to use SQLite, MySQL, or another database system should ideally be made before you create your wiki, as it is difficult to convert from a SQLite database to a MySQL database once you have started using your wiki. </p> <div class="mw-heading mw-heading2"><h2 id="About_SQLite">About SQLite</h2></div> <p>SQLite is an open-source database library released into public domain. Unlike <a href="https://en.wikipedia.org/wiki/client-server" class="extiw" title="w:client-server">client-server</a> database management systems, the SQLite <a href="https://en.wikipedia.org/wiki/library_(computing)" class="extiw" title="w:library (computing)">library</a> is <a href="https://en.wikipedia.org/wiki/Linker" class="extiw" title="w:Linker">linked into</a> PHP and thus becomes an integral part of the server process. MediaWiki uses SQLite's functionality through simple function calls, which reduces <a href="https://en.wikipedia.org/wiki/latency_(engineering)" class="extiw" title="w:latency (engineering)">latency</a> in database access as function calls are more efficient than <a href="https://en.wikipedia.org/wiki/inter-process_communication" class="extiw" title="w:inter-process communication">inter-process communication</a>. </p><p>Using SQLite as database backend for MediaWiki has its own pros and cons: </p> <dl><dt>Pros</dt></dl> <ul><li>You don't have to install and maintain a standalone database server such as MySQL; this significantly reduces efforts spent on administration and removes some points of failure.</li> <li>The former also means that SQLite is much more suitable for portable MediaWiki installs running from a USB stick.</li> <li>You are not restricted by artificial database limitations on shared hosts.</li> <li>The entire database is stored as a single cross-platform file, simplifying backups and migration.</li></ul> <dl><dt>Cons</dt></dl> <ul><li>SQLite is not that scalable, so if you have a large and popular wiki, you should use MySQL.</li> <li>Although SQLite has its own search engine, it's not supported by more advanced solutions such as <a href="/wiki/Lucene" class="mw-disambig" title="Lucene">Lucene</a>.</li> <li>Several extensions are known to have database update or installation issues with SQLite: <a href="/wiki/Special:MyLanguage/Extension:AbuseFilter" title="Special:MyLanguage/Extension:AbuseFilter">AbuseFilter</a>, <a href="/wiki/Special:MyLanguage/Extension:Echo" title="Special:MyLanguage/Extension:Echo">Echo</a>, <a href="/wiki/Special:MyLanguage/Extension:Flow" title="Special:MyLanguage/Extension:Flow">Flow</a>, and <a href="/wiki/Special:MyLanguage/Extension:LiquidThreads" title="Special:MyLanguage/Extension:LiquidThreads">LiquidThreads</a>.</li></ul> <div class="mw-heading mw-heading2"><h2 id="SQLite_installation">SQLite installation</h2></div> <p>At least SQLite version <span class="plainlinks"><a class="external text" href="https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/core/+/59f4c323238de385e4d69d71a3a04b994c018d1b">3.8.0</a></span>+ is required. Also, in order to use full text search, SQLite must be compiled with FTS3 module enabled (most builds have it out of the box these days). SQLite3 works via PHP's <a rel="nofollow" class="external text" href="https://php.net/class.pdo">PDO functions</a>. </p> <ul><li>To install SQLite3 on a Debian or Ubuntu based system, use <code>apt install php-sqlite3</code>.</li> <li>Windows binaries from php.net are OK.</li> <li>The PHP PDO SQLite module needs to be loaded. You should uncomment the following line in your <code>php.ini</code> <ul><li><code>extension=pdo_sqlite</code></li></ul></li> <li>Where should you put the SQLite database itself? The default path seems to be $IP/../data/$dbname.sqlite. Anything outside of the webroot should be safe; it's good to keep it nearby. Or, if you feel like it, you could put it in the web root somewhere and make sure to use webserver config to deny access to it.</li></ul> <div class="mw-heading mw-heading2"><h2 id="Installing_MediaWiki_on_SQLite_backend">Installing MediaWiki on SQLite backend</h2></div> <ul><li>If SQLite module for PHP is properly installed, MediaWiki installer (<code>/mw-config/index.php</code>) should offer you an option to use SQLite.</li> <li>If you enter nothing into the "SQLite data directory" field, your <a href="/wiki/Special:MyLanguage/Manual:$wgSQLiteDataDir" title="Special:MyLanguage/Manual:$wgSQLiteDataDir">$wgSQLiteDataDir</a><span style="display:none"><a href="/wiki/Manual:$wgSQLiteDataDir" title="Manual:$wgSQLiteDataDir"> </a></span> will be left empty, which corresponds to <code>data</code> directory in the parent of the document root, however this directory might be different for web scripts and <a href="/wiki/Special:MyLanguage/Manual:Maintenance_scripts" title="Special:MyLanguage/Manual:Maintenance scripts">maintenance scripts</a> run from command line, so specifying it explicitly is recommended.</li></ul> <div class="mw-heading mw-heading2"><h2 id="Search_engine">Search engine</h2></div> <style data-mw-deduplicate="TemplateStyles:r4199130">.mw-parser-output .mw-version{border:1px solid #72777d;font-size:80%;line-height:1.2;border-collapse:collapse}.mw-parser-output .mw-version-ltr{float:right;margin:0 0 .5em .5em;text-align:right}.mw-parser-output .mw-version-rtl{float:left;margin:0 .5em .5em 0;text-align:left}.mw-parser-output .mw-version td{padding:.1em .3em}.mw-parser-output .mw-version-versionbox{border:5px solid #00af89;text-align:center}.mw-parser-output .mw-version-versionnumber{font-weight:bold;font-size:180%}.mw-parser-output .mw-version-version .mw-version-versionbox{border-color:#c8ccd1}.mw-parser-output .mw-version.mw-version-version2 .mw-version-versionbox{border-top-color:#c8ccd1;border-right-color:#c8ccd1;border-left-color:#c8ccd1}.mw-parser-output .mw-version-version-unsupported .mw-version-versionbox{border-color:#d33}.mw-parser-output .mw-version.mw-version-version2-unsupported .mw-version-versionbox{border-top-color:#d33;border-right-color:#d33;border-left-color:#d33}.mw-parser-output .mw-version-version-legacy .mw-version-versionbox{border-color:#f93}.mw-parser-output .mw-version.mw-version-version2-legacy .mw-version-versionbox{border-top-color:#f93;border-right-color:#f93;border-left-color:#f93}.mw-parser-output .mw-version-version-stable .mw-version-versionbox,.mw-parser-output .mw-version.mw-version.mw-version-and-later .mw-version-versionbox{border-color:#00af89}.mw-parser-output .mw-version.mw-version-version2-stable .mw-version-versionbox{border-top-color:#00af89;border-right-color:#00af89;border-left-color:#00af89}.mw-parser-output .mw-version-version-future .mw-version-versionbox{border-color:#8080c0}.mw-parser-output .mw-version.mw-version-version2-future .mw-version-versionbox{border-top-color:#8080c0;border-right-color:#8080c0;border-left-color:#8080c0}.mw-parser-output .mw-version-version-alpha .mw-version-versionbox{border-style:dotted}</style> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-and-later"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="The latest stable version is 1.42"><div class="mw-version-versionnumber"><small>≥</small> 1.16</div></td> </tr></tbody></table> <p>Search capabilities for SQLite backend was introduced in MediaWiki 1.16. They require SQLite with <a rel="nofollow" class="external text" href="https://sqlite.org/fts3.html">FTS3</a> module compiled-in, which is usually present in most modern builds. If you've recently updated your SQLite support to a version that includes FTS3, <a href="/wiki/Special:MyLanguage/Manual:Upgrading#Run_the_update_script" title="Special:MyLanguage/Manual:Upgrading">run the updater</a> as if you're upgrading MediaWiki. After the updater script created the search index table, populate it with <a href="/wiki/Special:MyLanguage/Manual:rebuildtextindex.php" title="Special:MyLanguage/Manual:rebuildtextindex.php">rebuildtextindex.php</a><span style="display:none"><a href="/wiki/Manual:Rebuildtextindex.php" title="Manual:Rebuildtextindex.php"> </a></span>. Same applies to switches back to environments without FTS3: re-running the updater will downgrade the table to avoid SQL errors. </p> <div class="mw-heading mw-heading2"><h2 id="Backing_up">Backing up</h2></div> <p>If your wiki is currently offline, its database can be backed up by simply copying the database file. Otherwise, you should use <a href="/wiki/Special:MyLanguage/Manual:SqliteMaintenance.php" title="Special:MyLanguage/Manual:SqliteMaintenance.php">a maintenance script</a>: <code><style data-mw-deduplicate="TemplateStyles:r4673781">.mw-parser-output .nowrap,.mw-parser-output .nowrap a:before,.mw-parser-output .nowrap .selflink:before{white-space:nowrap}</style><span class="nowrap">php maintenance/SqliteMaintenance.php --backup-to <backup file name></span></code>, which will make sure that operation is atomic and there are no inconsistencies. If your database is not really huge and server is not under heavy load, users editing the wiki will notice nothing but a short lag. Users who are just reading will not notice anything in any case. </p> <div class="mw-heading mw-heading2"><h2 id="Troubleshooting">Troubleshooting</h2></div> <div class="mw-heading mw-heading3"><h3 id="Unable_to_access_the_database_on_the_terminal">Unable to access the database on the terminal</h3></div> <p>To get command-line access to the database, type on the terminal: </p> <pre>sqlite3 /var/data/database_name.sqlite </pre> <p>replacing <code>/var/data</code> with the directory that was set as the "SQLite data directory" during the installation process. Alternatively, look for <a href="/wiki/Special:MyLanguage/Manual:$wgSQLiteDataDir" title="Special:MyLanguage/Manual:$wgSQLiteDataDir">$wgSQLiteDataDir</a><span style="display:none"><a href="/wiki/Manual:$wgSQLiteDataDir" title="Manual:$wgSQLiteDataDir"> </a></span> inside <a href="/wiki/Special:MyLanguage/Manual:LocalSettings.php" title="Special:MyLanguage/Manual:LocalSettings.php">LocalSettings.php</a><span style="display:none"><a href="/wiki/Manual:LocalSettings.php" title="Manual:LocalSettings.php"> </a></span>. </p><p>This can be tricky if you are not experienced about SQLite and run <code>sqlite3 database_name</code> - because this will open a completely different database (creating it if it doesn't exist) since SQLite interprets the argument not as a system-wide database name, but instead as the file name that contains the db. </p> <div class="mw-heading mw-heading3"><h3 id="Problems">Problems</h3></div> <p>Bugs should be reported to <a href="/wiki/Special:MyLanguage/Phabricator" title="Special:MyLanguage/Phabricator">Wikimedia's bug tracker</a>. First check if your problem was already reported - check the dependencies of tag <span style="background: #eaf3ff; border: 1px solid #36c; font-size: 85%; padding: 5px 8px; border-radius: 2px;"><a href="https://phabricator.wikimedia.org/tag/sqlite/" class="extiw" title="phab:tag/sqlite/"><b>#sqlite</b></a></span> and use search. If you can't find your problem, <a href="https://phabricator.wikimedia.org/maniphest/task/edit/" class="extiw" title="phab:maniphest/task/edit/">create a new issue</a>. In any case please take some steps to make your bug easy to find and track: mention SQLite in its summary field and make it have the project tag <a href="https://phabricator.wikimedia.org/tag/SQLite" class="extiw" title="phab:tag/SQLite">SQLite</a>. </p> <div class="mw-heading mw-heading2"><h2 id="Performance_Tips">Performance Tips</h2></div> <ul><li>If possible, ensure you have the APCu php extension installed and <a href="/wiki/Special:MyLanguage/Manual:$wgMainCacheType" title="Special:MyLanguage/Manual:$wgMainCacheType">$wgMainCacheType</a><span style="display:none"><a href="/wiki/Manual:$wgMainCacheType" title="Manual:$wgMainCacheType"> </a></span> set to CACHE_ACCEL. If no cache is present, MediaWiki will use the database as a cache backend, which can lead to write contention. On Sqlite this can significantly slow down your wiki.</li> <li>Make sure your SQLite database is in <a rel="nofollow" class="external text" href="https://www.sqlite.org/wal.html">WAL</a> mode (<b>W</b>rite-<b>A</b>head <b>L</b>ogging – <b>WAL</b>). This can have a major impact on performance when people are viewing and editing your site at the same time. You can do this by using the sqlite command line tool to open the DB, and run the command <code>PRAGMA journal_mode=wal;</code>.</li></ul> <div class="mw-heading mw-heading2"><h2 id="See_also">See also</h2></div> <ul><li>SQLite-specific configuration settings: <ul><li><a href="/wiki/Special:MyLanguage/Manual:$wgSQLiteDataDir" title="Special:MyLanguage/Manual:$wgSQLiteDataDir">$wgSQLiteDataDir</a><span style="display:none"><a href="/wiki/Manual:$wgSQLiteDataDir" title="Manual:$wgSQLiteDataDir"> </a></span></li></ul></li> <li><a href="/wiki/Special:MyLanguage/Manual:sqlite.php" title="Special:MyLanguage/Manual:sqlite.php">sqlite.php</a><span style="display:none"><a href="/wiki/Manual:Sqlite.php" title="Manual:Sqlite.php"> </a></span> - MediaWiki 1.35 and before</li> <li><a href="/wiki/Special:MyLanguage/Manual:SqliteMaintenance.php" title="Special:MyLanguage/Manual:SqliteMaintenance.php">SqliteMaintenance.php</a><span style="display:none"><a href="/wiki/Manual:SqliteMaintenance.php" title="Manual:SqliteMaintenance.php"> </a></span> MediaWiki 1.36+</li></ul> <div class="mw-heading mw-heading2"><h2 id="External_links">External links</h2></div> <ul><li><a rel="nofollow" class="external text" href="http://www.linuxintro.org/wiki/Migrating_mediawiki_from_mysql_to_sqlite">Migrating MediaWiki from MySQL to SQLite</a></li> <li><a rel="nofollow" class="external text" href="https://github.com/mywikis/MediaWiki-SQLite-to-MySQL">Tool to migrate MediaWiki from SQLite to MySQL</a></li> <li><a rel="nofollow" class="external text" href="https://www.sqlite.org/">SQLite home page</a></li> <li><a href="https://en.wikipedia.org/wiki/SQLite" class="extiw" title="en:SQLite">Wikipedia article on SQLite</a></li></ul> <div class="navbox-styles nomobile"><style data-mw-deduplicate="TemplateStyles:r6230902">.mw-parser-output .navbox{border:1px solid #aaa;box-sizing:border-box;width:100%;margin:auto;clear:both;font-size:88%;text-align:center;padding:1px}.mw-parser-output .navbox-inner,.mw-parser-output .navbox-subgroup{width:100%}.mw-parser-output .navbox+.navbox-styles+.navbox{margin-top:-1px}.mw-parser-output .navbox th,.mw-parser-output .navbox-title,.mw-parser-output .navbox-abovebelow{text-align:center;padding-left:1em;padding-right:1em}.mw-parser-output th.navbox-group{white-space:nowrap;text-align:right}.mw-parser-output .navbox,.mw-parser-output .navbox-subgroup{background:#fdfdfd}.mw-parser-output .navbox-list{border-color:#fdfdfd}.mw-parser-output .navbox th,.mw-parser-output .navbox-title{background:#eaeeff}.mw-parser-output .navbox-abovebelow,.mw-parser-output th.navbox-group,.mw-parser-output .navbox-subgroup .navbox-title{background:#ddddff}.mw-parser-output .navbox-subgroup .navbox-group,.mw-parser-output .navbox-subgroup .navbox-abovebelow{background:#e6e6ff}.mw-parser-output .navbox-even{background:#f7f7f7}.mw-parser-output .navbox-odd{background:transparent}.mw-parser-output th.navbox-title1{border-left:2px solid #fdfdfd;width:100%}.mw-parser-output td.navbox-list1{text-align:left;border-left-width:2px;border-left-style:solid}.mw-parser-output .navbox .hlist td dl,.mw-parser-output .navbox .hlist td ol,.mw-parser-output .navbox .hlist td ul,.mw-parser-output .navbox td.hlist dl,.mw-parser-output .navbox td.hlist ol,.mw-parser-output .navbox td.hlist ul{padding:0.125em 0}.mw-parser-output .navbox .hlist dd,.mw-parser-output .navbox .hlist dt,.mw-parser-output .navbox .hlist li{white-space:nowrap}.mw-parser-output .navbox .hlist dd dl,.mw-parser-output .navbox .hlist dt dl,.mw-parser-output .navbox .hlist li ol,.mw-parser-output .navbox .hlist li ul{white-space:normal}.mw-parser-output ol+.navbox-styles+.navbox,.mw-parser-output ul+.navbox-styles+.navbox{margin-top:0.5em}</style></div><div role="navigation" class="navbox" aria-labelledby="Databases" style="padding:3px"><table class="nowraplinks hlist mw-collapsible autocollapse navbox-inner" style="border-spacing:0;background:transparent;color:inherit"><tbody><tr><th scope="col" class="navbox-title" colspan="2"><style data-mw-deduplicate="TemplateStyles:r6387430">.mw-parser-output .hlist dl,.mw-parser-output .hlist ol,.mw-parser-output .hlist ul{margin:0;padding:0}.mw-parser-output .hlist dd,.mw-parser-output .hlist dt,.mw-parser-output .hlist li{margin:0;display:inline}.mw-parser-output .hlist dl dl,.mw-parser-output .hlist dl ol,.mw-parser-output .hlist dl ul,.mw-parser-output .hlist ol dl,.mw-parser-output .hlist ol ol,.mw-parser-output .hlist ol ul,.mw-parser-output .hlist ul dl,.mw-parser-output .hlist ul ol,.mw-parser-output .hlist ul ul{display:inline}.mw-parser-output .hlist .mw-empty-li,.mw-parser-output .hlist .mw-empty-elt{display:none}.mw-parser-output .hlist dt:after{content:": "}.mw-parser-output .hlist dd:after,.mw-parser-output .hlist li:after{content:" · ";font-weight:bold}.mw-parser-output .hlist dd:last-child:after,.mw-parser-output .hlist dt:last-child:after,.mw-parser-output .hlist li:last-child:after{content:none}.mw-parser-output .hlist dd dd:first-child:before,.mw-parser-output .hlist dd dt:first-child:before,.mw-parser-output .hlist dd li:first-child:before,.mw-parser-output .hlist dt dd:first-child:before,.mw-parser-output .hlist dt dt:first-child:before,.mw-parser-output .hlist dt li:first-child:before,.mw-parser-output .hlist li dd:first-child:before,.mw-parser-output .hlist li dt:first-child:before,.mw-parser-output .hlist li li:first-child:before{content:" (";font-weight:normal}.mw-parser-output .hlist dd dd:last-child:after,.mw-parser-output .hlist dd dt:last-child:after,.mw-parser-output .hlist dd li:last-child:after,.mw-parser-output .hlist dt dd:last-child:after,.mw-parser-output .hlist dt dt:last-child:after,.mw-parser-output .hlist dt li:last-child:after,.mw-parser-output .hlist li dd:last-child:after,.mw-parser-output .hlist li dt:last-child:after,.mw-parser-output .hlist li li:last-child:after{content:")";font-weight:normal}.mw-parser-output .hlist ol{counter-reset:listitem}.mw-parser-output .hlist ol>li{counter-increment:listitem}.mw-parser-output .hlist ol>li:before{content:" "counter(listitem)"\a0 "}.mw-parser-output .hlist dd ol>li:first-child:before,.mw-parser-output .hlist dt ol>li:first-child:before,.mw-parser-output .hlist li ol>li:first-child:before{content:" ("counter(listitem)"\a0 "}</style><style data-mw-deduplicate="TemplateStyles:r4692751">.mw-parser-output .navbar{display:inline;font-size:88%;font-weight:normal}.mw-parser-output .navbar ul{display:inline;white-space:nowrap}.mw-parser-output .navbar li{word-spacing:-0.125em}.mw-parser-output .navbox .navbar{display:block;font-size:100%}.mw-parser-output .navbox-title .navbar{float:left;text-align:left;margin-right:0.5em;width:6em}</style><div class="plainlinks hlist navbar mini"><ul><li class="nv-view"><a href="/wiki/Template:Databases" title="Template:Databases"><abbr title="View this template" style=";;background:none transparent;border:none;box-shadow:none; padding:0;">v</abbr></a></li><li class="nv-talk"><a href="/wiki/Template_talk:Databases" title="Template talk:Databases"><abbr title="Discuss this template" style=";;background:none transparent;border:none;box-shadow:none; padding:0;">t</abbr></a></li><li class="nv-edit"><a class="external text" href="https://www.mediawiki.org/w/index.php?title=Template:Databases&action=edit"><abbr title="Edit this template" style=";;background:none transparent;border:none;box-shadow:none; padding:0;">e</abbr></a></li></ul></div><div id="Databases" style="font-size:114%;margin:0 4em"><a href="/wiki/Special:MyLanguage/Manual:Database_layout" title="Special:MyLanguage/Manual:Database layout">Databases</a><span style="display:none"><a href="/wiki/Manual:Database_layout" title="Manual:Database layout"> </a></span></div></th></tr><tr><th scope="row" class="navbox-group" style="width:1%;white-space:inherit; min-width:9em">Engines</th><td class="navbox-list1 navbox-list navbox-odd" style="width:100%;padding:0px"><div style="padding:0em 0.25em"><div class="navbox-styles nomobile"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r6230902"></div></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%">Current</th><td class="navbox-list1 navbox-list navbox-even" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:MariaDB" title="Special:MyLanguage/Manual:MariaDB">MariaDB</a><span style="display:none"><a href="/wiki/Manual:MariaDB" title="Manual:MariaDB"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:MySQL" title="Special:MyLanguage/Manual:MySQL">MySQL</a><span style="display:none"><a href="/wiki/Manual:MySQL" title="Manual:MySQL"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:PostgreSQL" title="Special:MyLanguage/Manual:PostgreSQL">PostgreSQL</a><span style="display:none"><a href="/wiki/Manual:PostgreSQL" title="Manual:PostgreSQL"> </a></span></li> <li><b><a href="/wiki/Special:MyLanguage/Manual:SQLite" title="Special:MyLanguage/Manual:SQLite">SQLite</a></b><span style="display:none"><a class="mw-selflink selflink"> </a></span></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Former</th><td class="navbox-list1 navbox-list navbox-odd" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:Oracle" title="Special:MyLanguage/Manual:Oracle">Oracle</a><span style="display:none"><a href="/wiki/Manual:Oracle" title="Manual:Oracle"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Microsoft_SQL_Server" title="Special:MyLanguage/Manual:Microsoft SQL Server">SQL Server</a><span style="display:none"><a href="/wiki/Manual:Microsoft_SQL_Server" title="Manual:Microsoft SQL Server"> </a></span></li></ul> </div></td></tr></tbody></table><div></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;white-space:inherit; min-width:9em">Technical documentation</th><td class="navbox-list1 navbox-list navbox-even" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:Database_layout" title="Special:MyLanguage/Manual:Database layout">Schema</a><span style="display:none"><a href="/wiki/Manual:Database_layout" title="Manual:Database layout"> </a></span> (<a href="/wiki/Special:MyLanguage/Category:MediaWiki_database_tables" title="Special:MyLanguage/Category:MediaWiki database tables">tables</a><span style="display:none"><a href="/wiki/Category:MediaWiki_database_tables" title="Category:MediaWiki database tables"> </a></span>)</li> <li><a href="/wiki/Special:MyLanguage/API:Database_field_and_API_property_associations" title="Special:MyLanguage/API:Database field and API property associations">API property associations</a><span style="display:none"><a href="/wiki/API:Database_field_and_API_property_associations" title="API:Database field and API property associations"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Database_field_prefixes" title="Special:MyLanguage/Database field prefixes">Field prefixes</a><span style="display:none"><a href="/wiki/Database_field_prefixes" title="Database field prefixes"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Primary_key_storage_in_other_fields" title="Special:MyLanguage/Manual:Primary key storage in other fields">Primary key storage in other fields</a><span style="display:none"><a href="/wiki/Manual:Primary_key_storage_in_other_fields" title="Manual:Primary key storage in other fields"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Category:Wikimedia_extension_database_tables" title="Special:MyLanguage/Category:Wikimedia extension database tables">Wikimedia extension tables</a><span style="display:none"><a href="/wiki/Category:Wikimedia_extension_database_tables" title="Category:Wikimedia extension database tables"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Database_inconsistencies" title="Special:MyLanguage/Manual:Database inconsistencies">Inconsistencies</a><span style="display:none"><a href="/wiki/Manual:Database_inconsistencies" title="Manual:Database inconsistencies"> </a></span></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;white-space:inherit; min-width:9em">Configuration</th><td class="navbox-list1 navbox-list navbox-odd" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:Configuration_settings#Database_settings" title="Special:MyLanguage/Manual:Configuration settings">Settings</a><span style="display:none"><a href="/wiki/Manual:Configuration_settings#Database_settings" title="Manual:Configuration settings"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Shared_database" title="Special:MyLanguage/Manual:Shared database">Sharing</a><span style="display:none"><a href="/wiki/Manual:Shared_database" title="Manual:Shared database"> </a></span></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;white-space:inherit; min-width:9em">Development</th><td class="navbox-list1 navbox-list navbox-even" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:Database_access" title="Special:MyLanguage/Manual:Database access">Access</a><span style="display:none"><a href="/wiki/Manual:Database_access" title="Manual:Database access"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Database_optimization" title="Special:MyLanguage/Database optimization">Optimization</a><span style="display:none"><a href="/wiki/Database_optimization" title="Database optimization"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/MediaWiki_database_policy" title="Special:MyLanguage/MediaWiki database policy">Policy</a><span style="display:none"><a href="/wiki/MediaWiki_database_policy" title="MediaWiki database policy"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:DatabaseUpdater.php" title="Special:MyLanguage/Manual:DatabaseUpdater.php">Updater</a><span style="display:none"><a href="/wiki/Manual:DatabaseUpdater.php" title="Manual:DatabaseUpdater.php"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Hooks/LoadExtensionSchemaUpdates" title="Special:MyLanguage/Manual:Hooks/LoadExtensionSchemaUpdates">Extension schema updates</a><span style="display:none"><a href="/wiki/Manual:Hooks/LoadExtensionSchemaUpdates" title="Manual:Hooks/LoadExtensionSchemaUpdates"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Schema_changes" title="Special:MyLanguage/Manual:Schema changes">Schema changes</a><span style="display:none"><a href="/wiki/Manual:Schema_changes" title="Manual:Schema changes"> </a></span></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;white-space:inherit; min-width:9em">Core tables</th><td class="navbox-list1 navbox-list navbox-odd" style="width:100%;padding:0px"><div style="padding:0em 0.25em"><div class="navbox-styles nomobile"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r6230902"></div></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%">Current</th><td class="navbox-list1 navbox-list navbox-even" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:actor_table" title="Special:MyLanguage/Manual:actor table">actor</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:archive_table" title="Special:MyLanguage/Manual:archive table">archive</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:block_table" title="Special:MyLanguage/Manual:block table">block</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:block_target_table" title="Special:MyLanguage/Manual:block target table">block_target</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:bot_passwords_table" title="Special:MyLanguage/Manual:bot passwords table">bot_passwords</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:category_table" title="Special:MyLanguage/Manual:category table">category</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:categorylinks_table" title="Special:MyLanguage/Manual:categorylinks table">categorylinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:change_tag_table" title="Special:MyLanguage/Manual:change tag table">change_tag</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:change_tag_def_table" title="Special:MyLanguage/Manual:change tag def table">change_tag_def</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:comment_table" title="Special:MyLanguage/Manual:comment table">comment</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:content_table" title="Special:MyLanguage/Manual:content table">content</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:content_models_table" title="Special:MyLanguage/Manual:content models table">content_models</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:externallinks_table" title="Special:MyLanguage/Manual:externallinks table">externallinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:filearchive_table" title="Special:MyLanguage/Manual:filearchive table">filearchive</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:image_table" title="Special:MyLanguage/Manual:image table">image</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:imagelinks_table" title="Special:MyLanguage/Manual:imagelinks table">imagelinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:interwiki_table" title="Special:MyLanguage/Manual:interwiki table">interwiki</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:iwlinks_table" title="Special:MyLanguage/Manual:iwlinks table">iwlinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:ipblocks_table" title="Special:MyLanguage/Manual:ipblocks table">ipblocks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:ipblocks_restrictions_table" title="Special:MyLanguage/Manual:ipblocks restrictions table">ipblocks_restrictions</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:ip_changes_table" title="Special:MyLanguage/Manual:ip changes table">ip_changes</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:job_table" title="Special:MyLanguage/Manual:job table">job</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:l10n_cache_table" title="Special:MyLanguage/Manual:l10n cache table">l10n_cache</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:langlinks_table" title="Special:MyLanguage/Manual:langlinks table">langlinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:linktarget_table" title="Special:MyLanguage/Manual:linktarget table">linktarget</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:logging_table" title="Special:MyLanguage/Manual:logging table">logging</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:log_search_table" title="Special:MyLanguage/Manual:log search table">log_search</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:module_deps_table" title="Special:MyLanguage/Manual:module deps table">module_deps</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:objectcache_table" title="Special:MyLanguage/Manual:objectcache table">objectcache</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:oldimage_table" title="Special:MyLanguage/Manual:oldimage table">oldimage</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:page_table" title="Special:MyLanguage/Manual:page table">page</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:pagelinks_table" title="Special:MyLanguage/Manual:pagelinks table">pagelinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:page_props_table" title="Special:MyLanguage/Manual:page props table">page_props</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:page_restrictions_table" title="Special:MyLanguage/Manual:page restrictions table">page_restrictions</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:protected_titles_table" title="Special:MyLanguage/Manual:protected titles table">protected_titles</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:querycache_table" title="Special:MyLanguage/Manual:querycache table">querycache</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:querycachetwo_table" title="Special:MyLanguage/Manual:querycachetwo table">querycachetwo</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:querycache_info_table" title="Special:MyLanguage/Manual:querycache info table">querycache_info</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:recentchanges_table" title="Special:MyLanguage/Manual:recentchanges table">recentchanges</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:redirect_table" title="Special:MyLanguage/Manual:redirect table">redirect</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:revision_table" title="Special:MyLanguage/Manual:revision table">revision</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:searchindex_table" title="Special:MyLanguage/Manual:searchindex table">searchindex</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:sites_table" title="Special:MyLanguage/Manual:sites table">sites</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:site_identifiers_table" title="Special:MyLanguage/Manual:site identifiers table">site_identifiers</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:site_stats_table" title="Special:MyLanguage/Manual:site stats table">site_stats</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:slots_table" title="Special:MyLanguage/Manual:slots table">slots</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:slot_roles_table" title="Special:MyLanguage/Manual:slot roles table">slot_roles</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:templatelinks_table" title="Special:MyLanguage/Manual:templatelinks table">templatelinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:text_table" title="Special:MyLanguage/Manual:text table">text</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:updatelog_table" title="Special:MyLanguage/Manual:updatelog table">updatelog</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:uploadstash_table" title="Special:MyLanguage/Manual:uploadstash table">uploadstash</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:user_table" title="Special:MyLanguage/Manual:user table">user</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:user_autocreate_serial_table" title="Special:MyLanguage/Manual:user autocreate serial table">user_autocreate_serial</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:user_former_groups_table" title="Special:MyLanguage/Manual:user former groups table">user_former_groups</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:user_groups_table" title="Special:MyLanguage/Manual:user groups table">user_groups</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:user_newtalk_table" title="Special:MyLanguage/Manual:user newtalk table">user_newtalk</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:user_properties_table" title="Special:MyLanguage/Manual:user properties table">user_properties</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:watchlist_table" title="Special:MyLanguage/Manual:watchlist table">watchlist</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:watchlist_expiry_table" title="Special:MyLanguage/Manual:watchlist expiry table">watchlist_expiry</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Former</th><td class="navbox-list1 navbox-list navbox-odd" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:blobs_table" title="Special:MyLanguage/Manual:blobs table">blobs</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:brokenlinks_table" title="Special:MyLanguage/Manual:brokenlinks table">brokenlinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:config_table" title="Special:MyLanguage/Manual:config table">config</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:cur_table" title="Special:MyLanguage/Manual:cur table">cur</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:external_user_table" title="Special:MyLanguage/Manual:external user table">external_user</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:hitcounter_table" title="Special:MyLanguage/Manual:hitcounter table">hitcounter</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:image_comment_temp_table" title="Special:MyLanguage/Manual:image comment temp table">image_comment_temp</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:ipblocks_old_table" title="Special:MyLanguage/Manual:ipblocks old table">ipblocks_old</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:links_table" title="Special:MyLanguage/Manual:links table">links</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:linkscc_table" title="Special:MyLanguage/Manual:linkscc table">linkscc</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:math_table" title="Special:MyLanguage/Manual:math table">math</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:msg_resource_table" title="Special:MyLanguage/Manual:msg resource table">msg_resource</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:msg_resource_links_table" title="Special:MyLanguage/Manual:msg resource links table">msg_resource_links</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:old_table" title="Special:MyLanguage/Manual:old table">old</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:profiling_table" title="Special:MyLanguage/Manual:profiling table">profiling</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:revision_actor_temp_table" title="Special:MyLanguage/Manual:revision actor temp table">revision_actor_temp</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:revision_comment_temp_table" title="Special:MyLanguage/Manual:revision comment temp table">revision_comment_temp</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:tag_summary_table" title="Special:MyLanguage/Manual:tag summary table">tag_summary</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:trackbacks_table" title="Special:MyLanguage/Manual:trackbacks table">trackbacks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:transcache_table" title="Special:MyLanguage/Manual:transcache table">transcache</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:user_rights_table" title="Special:MyLanguage/Manual:user rights table">user_rights</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:valid_tag_table" title="Special:MyLanguage/Manual:valid tag table">valid_tag</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:validate_table" title="Special:MyLanguage/Manual:validate table">validate</a></li></ul> </div></td></tr></tbody></table><div></div></td></tr></tbody></table></div>    </div><noscript><img src="https://login.wikimedia.org/wiki/Special:CentralAutoLogin/start?type=1x1" alt="" width="1" height="1" style="border: none; position: absolute;"></noscript> <div class="printfooter" data-nosnippet="">Retrieved from "<a dir="ltr" href="https://www.mediawiki.org/w/index.php?title=Manual:SQLite&oldid=6850026">https://www.mediawiki.org/w/index.php?title=Manual:SQLite&oldid=6850026</a>"</div></div> <div id="catlinks" class="catlinks" data-mw="interface"><div id="mw-normal-catlinks" class="mw-normal-catlinks"><a href="/wiki/Special:Categories" title="Special:Categories">Categories</a>: <ul><li><a href="/wiki/Category:Database" title="Category:Database">Database</a></li><li><a href="/wiki/Category:Installation" title="Category:Installation">Installation</a></li></ul></div></div> </div> </main> </div> <div class="mw-footer-container"> <footer id="footer" class="mw-footer" > <ul id="footer-info"> <li id="footer-info-lastmod"> This page was last edited on 11 November 2024, at 22:02.</li> <li id="footer-info-copyright">Text is available under the <a rel="nofollow" class="external text" href="https://creativecommons.org/licenses/by-sa/4.0/deed.en">Creative Commons Attribution-ShareAlike License</a>; additional terms may apply. Text in <a class="external text" href="https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents">the Help: namespace</a> is available under the <a rel="nofollow" class="external text" href="https://creativecommons.org/publicdomain/zero/1.0/">Creative Commons CC0 License</a>. By using this site, you agree to the <a class="external text" href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Terms_of_Use">Terms of Use</a> and <a class="external text" href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacy Policy</a>.</li> </ul> <ul id="footer-places"> <li id="footer-places-privacy"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacy policy</a></li> <li id="footer-places-about"><a href="/wiki/Project:About">About mediawiki.org</a></li> <li id="footer-places-disclaimers"><a href="/wiki/Project:General_disclaimer">Disclaimers</a></li> <li id="footer-places-wm-codeofconduct"><a href="https://www.mediawiki.org/wiki/Special:MyLanguage/Code_of_Conduct">Code of Conduct</a></li> <li id="footer-places-developers"><a href="https://developer.wikimedia.org">Developers</a></li> <li id="footer-places-statslink"><a href="https://stats.wikimedia.org/#/www.mediawiki.org">Statistics</a></li> <li id="footer-places-cookiestatement"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Cookie_statement">Cookie statement</a></li> <li id="footer-places-mobileview"><a href="//m.mediawiki.org/w/index.php?title=Manual:SQLite&mobileaction=toggle_view_mobile" class="noprint stopMobileRedirectToggle">Mobile view</a></li> </ul> <ul id="footer-icons" class="noprint"> <li id="footer-copyrightico"><a href="https://wikimediafoundation.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/static/images/footer/wikimedia-button.svg" width="84" height="29" alt="Wikimedia Foundation" loading="lazy"></a></li> <li id="footer-poweredbyico"><a href="https://www.mediawiki.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/w/resources/assets/poweredby_mediawiki.svg" alt="Powered by MediaWiki" width="88" height="31" loading="lazy"></a></li> </ul> </footer> </div> </div> </div> <div class="vector-settings" id="p-dock-bottom"> <ul></ul> </div><script>(RLQ=window.RLQ||[]).push(function(){mw.config.set({"wgHostname":"mw-web.codfw.main-f69cdc8f6-tc56n","wgBackendResponseTime":110,"wgPageParseReport":{"limitreport":{"cputime":"0.563","walltime":"0.683","ppvisitednodes":{"value":5775,"limit":1000000},"postexpandincludesize":{"value":76316,"limit":2097152},"templateargumentsize":{"value":10983,"limit":2097152},"expansiondepth":{"value":16,"limit":100},"expensivefunctioncount":{"value":9,"limit":500},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":12988,"limit":5000000},"entityaccesscount":{"value":0,"limit":400},"timingprofile":["126.27% 533.844 3 Template:Navbox","100.00% 422.763 1 -total"," 74.22% 313.791 1 Template:Databases"," 47.40% 200.402 226 Template:Translatable"," 45.02% 190.316 114 Template:Pagelang"," 41.82% 176.819 82 Template:Db_table"," 20.24% 85.567 31 Template:Ll"," 9.89% 41.792 1 Template:MW_1.16"," 8.32% 35.190 1 Template:MW_version/en"," 7.52% 31.786 1 Template:MW_version/layout"]},"scribunto":{"limitreport-timeusage":{"value":"0.191","limit":"10.000"},"limitreport-memusage":{"value":1602339,"limit":52428800}},"cachereport":{"origin":"mw-web.eqiad.main-79558cdd9c-8d9wd","timestamp":"20241111220731","ttl":2592000,"transientcontent":false}}});});</script> </body> </html>