Editing SQLite (section)

=={{anchor|Adoption}}Notable uses==

===Operating systems===
SQLite is included by default in:<ref name=":0" />
* [[Android (operating system)|Android]]
* [[BlackBerry 10]] OS
* [[Fedora Linux]] where it is used by the [[RPM Package Manager|rpm]] core package management system
* [[FreeBSD]] where starting with 10-RELEASE version in January 2014, it is used by the core package management system.
* [[illumos]]
* [[iOS]]
* [[Mac OS X 10.4]] onwards (Apple adopted it as an option in [[macOS]]'s [[Core Data]] API from the original implementation)
* [[Maemo]]
* [[MeeGo]]
* [[MorphOS]] 3.10 onwards
* [[NetBSD]]
* [[NixOS]] where it is used by the [[Nix (package manager)|Nix]] core package management system
* [[Red Hat Enterprise Linux]] where it is used in the same way as Fedora, from which Red Hat Enterprise Linux is derived
* [[Solaris 10]] where the [[Service Management Facility]] database is serialized for booting.
* [[Symbian OS]]
* [[Tizen]]
* [[webOS]]
* [[Windows 10]] onwards<ref>{{cite web| url=https://docs.microsoft.com/en-us/windows/uwp/data-access/sqlite-databases#to-use-the-version-of-sqlite-that-is-installed-with-windows| title=To use the version of SQLite that is installed with Windows| date=20 October 2022| access-date=31 March 2022| archive-date=31 March 2022| archive-url=https://web.archive.org/web/20220331170828/https://docs.microsoft.com/en-us/windows/uwp/data-access/sqlite-databases#to-use-the-version-of-sqlite-that-is-installed-with-windows| url-status=live}}</ref>

===Middleware===
* [[ADO.NET]] adapter, initially developed by Robert Simpson, is maintained jointly with the SQLite developers since April 2010.<ref>{{cite web |url=http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki |title=Home |website=System.Data.SQLite |date=2016-12-30 |access-date=2017-01-06 |archive-date=2014-07-13 |archive-url=https://web.archive.org/web/20140713080835/http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki |url-status=live }}</ref>
* [[ODBC]] driver has been developed and is maintained separately by Christian Werner.<ref>{{cite web |url=http://www.ch-werner.de/sqliteodbc/ |title=SQLite ODBC Driver |website=Ch-werner.de |date=2016-12-01 |access-date=2017-01-06 |archive-date=2014-06-26 |archive-url=https://web.archive.org/web/20140626165719/http://www.ch-werner.de/sqliteodbc/ |url-status=live }}</ref> Werner's ODBC driver is the recommended connection method for accessing SQLite from [[OpenOffice.org]].<ref>{{cite web |url=http://documentation.openoffice.org/HOW_TO/data_source/SQLite.pdf |title=Using SQLite Database with OpenOffice.org : Version 2.0 |website=Documentation.openoffice.org |access-date=2017-01-06 |archive-date=2011-09-28 |archive-url=https://web.archive.org/web/20110928073029/http://documentation.openoffice.org/HOW_TO/data_source/SQLite.pdf |url-status=live }}</ref>
* [[Component Object Model|COM]] ([[ActiveX]]) wrapper making SQLite accessible on Windows to scripted languages such as [[JScript]] and [[VBScript]]. This adds SQLite database capabilities to [[HTML Application]]s (HTA).<ref>{{cite web|url = https://sqlite.org/cvstrac/wiki?p=SqliteWrappers|title = sqlite&nbsp;— Sqlite Wrappers|date = February 7, 2009|publisher = SQLite.org|access-date = February 7, 2009|archive-date = February 5, 2009|archive-url = https://web.archive.org/web/20090205225756/http://sqlite.org/cvstrac/wiki?p=SqliteWrappers|url-status = live}}</ref>

===Web browsers===
* The browsers [[Google Chrome]], [[Opera (web browser)|Opera]], [[Safari (web browser)|Safari]] and the [[Android Browser]] all allow for storing information in, and retrieving it from, an SQLite database within the browser, using the official SQLite Wasm ([[WebAssembly]]) build,<ref>{{Cite web
| url = https://sqlite.org/wasm
| title = sqlite3 WebAssembly & JavaScript Documentation Index
| website = SQLite
| access-date = 2023-05-08
| archive-date = 2024-05-02
| archive-url = https://web.archive.org/web/20240502210710/https://sqlite.org/wasm/doc/trunk/index.md
| url-status = live
}}</ref> or using the [[Web SQL Database]] technology, although the latter is becoming deprecated (namely superseded by SQLite Wasm or by [[IndexedDB]]). Internally, these [[Chromium (web browser)|Chromium]] based browsers use SQLite databases for storing configuration data like site visit history, cookies, download history etc.<ref>{{cite web |url=https://www.foxtonforensics.com/browser-history-examiner/chrome-history-location |title=Location of Google Chrome history |website=www.foxtonforensics.com |date=2020-10-06 |access-date=2020-10-06 |archive-date=2023-02-28 |archive-url=https://web.archive.org/web/20230228184524/https://www.foxtonforensics.com/browser-history-examiner/chrome-history-location |url-status=live }}</ref>
* [[Mozilla Firefox]] and [[Mozilla Thunderbird]] store a variety of configuration data (bookmarks, cookies, contacts etc.) in internally managed SQLite databases. Until Firefox version 57 ([[History of Firefox#Firefox 57|"Firefox Quantum"]]), there was a third-party add-on that used the API supporting this functionality to provide a user interface for managing arbitrary SQLite databases.<ref>{{cite web|url=https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ |title=SQLite Manager :: Add-ons for Firefox |website=Addons.mozilla.org |date=2015-02-28 |access-date=2017-01-06 |url-status=dead |archive-url=https://web.archive.org/web/20170102010658/https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ |archive-date=2017-01-02}}</ref>
* Several third-party add-ons can make use of [[JavaScript]] APIs to manage SQLite databases.<ref>{{cite web |url=https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager-webext/ |title=SQLite Manager – Get this Extension for 🦊 Firefox (en-US) |website=Addons.mozilla.org |date=2018-07-24 |access-date=2018-10-05 |archive-date=2018-10-05 |archive-url=https://web.archive.org/web/20181005112443/https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager-webext/ |url-status=live }}</ref><ref>{{cite web |url=https://addons.mozilla.org/en-US/firefox/addon/sql-reader/ |title=SQLite Reader – Get this Extension for 🦊 Firefox (en-US) |website=Addons.mozilla.org |date=2018-09-01 |access-date=2018-10-05 |archive-date=2018-10-05 |archive-url=https://web.archive.org/web/20181005112536/https://addons.mozilla.org/en-US/firefox/addon/sql-reader/ |url-status=live }}</ref>

===Web application frameworks===
* [[Symfony]] 
* [[Laravel]]
* [[Bugzilla]]
* [[Django (web framework)|Django]]'s default database management system
* [[Drupal]]
* [[Trac]]
* [[Ruby on Rails]]'s default database management system
* [[web2py]]
* [[Jam.py (web framework)|Jam.py]]

===Others===
* [[Adobe Systems]] uses SQLite as its file format in [[Adobe Lightroom]], a standard database in [[Adobe AIR]], and internally within [[Adobe Reader]].<ref name=":0">{{cite web|title = Well-Known Users Of SQLite|url = https://sqlite.org/famous.html|access-date = August 5, 2015|publisher = SQLite|archive-date = July 11, 2015|archive-url = https://web.archive.org/web/20150711135311/https://sqlite.org/famous.html|url-status = live}}</ref>
* [[Photos (Apple)|Apple Photos]] uses SQLite internally.<ref name="apple-photos">{{cite web|url = https://simonwillison.net/2020/May/21/dogsheep-photos/|access-date = May 23, 2020|title = Using SQL to find my best photo of a pelican according to Apple Photo|work = Simon Willison’s Weblog|archive-date = May 22, 2020|archive-url = https://web.archive.org/web/20200522181550/https://simonwillison.net/2020/May/21/dogsheep-photos/|url-status = live}}</ref>
* [[Audacity (audio editor)|Audacity]] uses SQLite as its file format, as of version 3.0.0.<ref name="audacity">{{cite web|url = https://www.audacityteam.org/audacity-3-0-0-released/|access-date = March 17, 2021|title = Audacity 3.0.0 Released|date = 17 March 2021|archive-date = 14 August 2023|archive-url = https://web.archive.org/web/20230814021313/https://www.audacityteam.org/audacity-3-0-0-released/|url-status = dead}}</ref>
* [[Evernote]] uses SQLite to store its local database repository in Windows.
* [[Skype]]<ref name="skype">{{cite mailing list|url = https://www.mail-archive.com/sqlite-users%40sqlite.org/msg27326.html|archive-url=https://web.archive.org/web/20071117061133/https://www.mail-archive.com/sqlite-users%40sqlite.org/msg27326.html|archive-date=2007-11-17|first=Jeremy|last=Hinegardner|title = Skype client using SQLite?|mailing-list=sqlite-users|date = August 28, 2007|access-date = June 14, 2010}}</ref>
* The Service Management Facility, used for service management within the [[Solaris (operating system)|Solaris]] and [[OpenSolaris]] operating systems
* [[Flame (malware)]]
* [[BMW]] [[IDrive]] Sat Nav system
* [[TomTom]] GPS systems, for the [[Navigation Data Standard|NDS]] map data
* [[Proxmox Virtual Environment|Proxmox VE]] - ''Proxmox Cluster File System'' ([https://pve.proxmox.com/wiki/Proxmox_Cluster_File_System_(pmxcfs) pmxcfs])
* [[Bentley Systems]] MicroStation<ref name=":0"/>
* [[Bosch (company)|Bosch]] car multimedia systems <ref name=":0"/>
* [[Airbus A350]] flight system<ref name=":0"/>