Editing SQLite (section)

{{Short description|Serverless relational database management system}}

{{Infobox software
| logo                   = SQLite370.svg
| logo size              = 220px
| screenshot             = SQLite3.png
| caption                = Screenshot of <code>sqlite3</code> command-line shell program
| collapsible            = 
| developer              = [[D. Richard Hipp]]
| released               = {{Start date and age|2000|8|17|df=yes|br=yes}}
| latest preview version =
| latest preview date    =
| programming language   = [[C (programming language)|C]]
| operating system       = [[Cross-platform]]
| platform               = 
| size                   = 699&nbsp;[[Kibibyte|KiB]]
| genre                  = [[Relational database management system|RDBMS]] ([[Embedded database|embedded]])
 | license                = [[Public domain]]<ref name="license">{{cite web
 | url                    = https://sqlite.org/copyright.html
 | title                  = SQLite Copyright
 | publisher              = sqlite.org
 | access-date            = May 17, 2010
 }}</ref>
| website                = {{Official URL}}
}}

{{Infobox file format
| name          = SQLite Database File Format
| icon          = 
| extension     = .sqlite, .sqlite3, .db, .db3, .s3db, .sl3
| _nomimecode   = yes
| mime          = <code>application/vnd.sqlite3</code><ref>{{cite web
 |url          = https://www.iana.org/assignments/media-types/application/vnd.sqlite3
 |title        = SQLite database file format media type at IANA
 |website      = [[Internet Assigned Numbers Authority]]
 |publisher    = [[Internet Assigned Numbers Authority|IANA]]
 |access-date  = 2019-03-08
 }}</ref>
| type code     = 
| uniform type  = 
| magic         = <code>53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00</code> (zero-terminated [[ASCII]] "SQLite format 3")
| developer     = 
| genre         = 
| released      = 2004-06-18
| extended from = 
| standard      = 
| open          = yes ([[Public Domain]])
| url           = {{url|https://sqlite.org/fileformat.html}}
}}

'''SQLite''' ({{IPAc-en|ˌ|ɛ|s|ˌ|k|juː|ˌ|ɛ|l|ˈ|aɪ|t}} "S-Q-L-ite",<ref>{{cite episode |series=The Changelog |number=201 |title=Why SQLite succeeded as a database — Richard Hipp, creator of SQLite |time=00:16:00 |url=https://changelog.com/podcast/201 |quote=How do I pronounce the name of the product? I say S-Q-L-ite, like a mineral. |access-date=2025-04-11 |archive-date=2022-07-07 |archive-url=https://web.archive.org/web/20220707033506/https://changelog.com/podcast/201 |url-status=live }}</ref><ref>{{cite video | people = [[D. Richard Hipp]] (presenter) | date = May 31, 2006 | title = An Introduction to SQLite | url = https://www.youtube.com/watch?v=f428dSRkTs4#t=1m14s | format = video<!-- HTML5 WebM video is available --> | publisher = Google Inc. | access-date =March 23, 2010 | time = 00:01:14 |quote={{IPA|[ˌɛsˌkjuˌwəlˈaɪt̚]}}}}</ref> {{IPAc-en|ˈ|s|iː|k|w|ə|,|l|aɪ|t}} "sequel-ite"<ref>{{cite video | people = [[D. Richard Hipp]] (presenter) | date = May 31, 2006 | title = An Introduction to SQLite | url = https://www.youtube.com/watch?v=f428dSRkTs4#t=48m15s | format = <!-- HTML5 WebM video is available --> | publisher = Google Inc. | access-date =March 23, 2010 | time = 00:48:15 |quote={{IPA|[ˈsikwəˌlaɪt̚]}} }}</ref>) is a [[Free and open-source software|free and open-source]] [[Relational database|relational]] [[database engine]] written in the [[C Language|C programming language]]. It is not a standalone app; rather, it is a [[Library (computing)|library]] that [[Programmer|software developers]] embed in their [[Application software|apps]]. As such, it belongs to the family of [[embedded database]]s. It is the most widely deployed database engine, as it is used by several of the top [[Web browser|web browsers]], [[operating system]]s, [[Mobile phone|mobile phones]], and other [[embedded system]]s.<ref>{{cite web |url = https://sqlite.org/mostdeployed.html |title = Most Widely Deployed SQL Database Estimates |publisher = SQLite.org |access-date = May 11, 2011}}</ref> 

Many [[Programming language|programming languages]] have [[Language binding|bindings]] to the SQLite library. It generally follows [[PostgreSQL]] syntax, but does not enforce [[type checking]] by default.<ref name="Owens 2006">{{cite book |last=Owens |first=Michael |year=2006 |chapter=Chapter 4: SQL |editor1-last=Gilmore |editor1-first=Jason |editor2-last=Thomas |editor2-first=Keir |editor2-link=Keir Thomas |title=The Definitive Guide to SQLite |chapter-url=https://books.google.com/books?id=VsZ5bUh0XAkC&pg=PA133 |others=[[D. Richard Hipp]] (foreword), Preston Hagar (technical reviewer) |publisher=[[Apress]] |page=133 |isbn=978-1-59059-673-9 |access-date=30 December 2014 |archive-date=24 November 2020 |archive-url=https://web.archive.org/web/20201124002058/https://books.google.com/books?id=VsZ5bUh0XAkC&pg=PA133 |url-status=live }}</ref><ref>{{cite web | url=https://sqlite.org/stricttables.html | title=STRICT Tables | access-date=2022-08-11 | archive-date=2022-08-07 | archive-url=https://web.archive.org/web/20220807204905/https://sqlite.org/stricttables.html | url-status=live }}</ref> This means that one can, for example, insert a string into a [[Column (database)|column]] defined as an integer. Although it is a lightweight embedded database, SQLite implements most of the [[SQL]] standard and the [[relational model]], including [[Transaction processing|transactions]] and [[ACID]] guarantees.<ref>{{Cite web |title=Full-Featured SQL |url=https://www.sqlite.org/fullsql.html |access-date=January 24, 2025 |website=SQLite}}</ref> However, it omits many features implemented by other databases, such as [[Materialized view|materialized views]] and complete support for [[Database trigger|triggers]] and [[SQL syntax|ALTER TABLE statements]].<ref>{{Cite web |title=SQL Features That SQLite Does Not Implement |url=https://www.sqlite.org/omitted.html |access-date=January 24, 2025 |website=SQLite}}</ref>