SQLite: Difference between revisions

Content deleted Content added
Created page with "{{short description|Serverless relational database management system (RDBMS)}}{{Infobox software | logo = SQLite370.svg | logo size = 220px | sc..."
 
No edit summary
Line 5: Line 5:
| caption =
| caption =
| collapsible =
| collapsible =
| developer = [[D. Richard Hipp]]
| developer = [[wikipedia:D. Richard Hipp|D. Richard Hipp]]
| released = {{Start date and age|2000|8|17|df=yes|br=yes}}
| released = {{Start date and age|2000|8|17|df=yes|br=yes}}
| latest preview version =
| latest preview version =
| latest preview date =
| latest preview date =
| programming language = [[C (programming language)|C]]
| programming language = [[wikipedia:C (programming language)|C]]
| operating system = [[Cross-platform]]
| operating system = [[wikipedia:Cross-platform|Cross-platform]]
| platform =
| platform =
| size = 699&nbsp;[[Kibibyte|KiB]]<!-- outout of sqlite3 dd.sqlite 'select 715816 / 1024;' 201411031830 -->
| size = 699&nbsp;[[wikipedia:Kibibyte|KiB]]<!-- outout of sqlite3 dd.sqlite 'select 715816 / 1024;' 201411031830 -->
| genre = [[Relational database management system|RDBMS]] ([[Embedded database|embedded]])
| genre = [[wikipedia:Relational database management system|RDBMS]] ([[wikipedia:Embedded database|embedded]])
| license = [[Public domain]]<ref name="license">{{cite web
| license = [[wikipedia:Public domain|Public domain]]<ref name="license">{{cite web
| url = https://www.sqlite.org/copyright.html
| url = https://www.sqlite.org/copyright.html
| title = SQLite Copyright
| title = SQLite Copyright
Line 30: Line 30:
| url = https://www.iana.org/assignments/media-types/application/vnd.sqlite3
| url = https://www.iana.org/assignments/media-types/application/vnd.sqlite3
| title = SQLite database file format media type at IANA
| title = SQLite database file format media type at IANA
| website = [[Internet Assigned Numbers Authority]]
| website = [[wikipedia:Internet Assigned Numbers Authority|Internet Assigned Numbers Authority]]
| publisher = [[Internet Assigned Numbers Authority|IANA]]
| publisher = [[wikipedia:Internet Assigned Numbers Authority|IANA]]
| access-date = 2019-03-08}}</ref>
| access-date = 2019-03-08}}</ref>
| type code =
| type code =
| uniform type =
| 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")
| magic = <code>53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00</code> (zero-terminated [[wikipedia:ASCII|ASCII]] "SQLite format 3")
| developer =
| developer =
| genre =
| genre =
Line 41: Line 41:
| extended from =
| extended from =
| standard =
| standard =
| free = yes ([[Public Domain]])
| free = yes ([[wikipedia:Public Domain|Public Domain]])
| url = [https://www.sqlite.org/fileformat2.html sqlite.org/fileformat2.html]
| url = [https://www.sqlite.org/fileformat2.html sqlite.org/fileformat2.html]
}}
}}


'''SQLite''' ({{IPAc-en|ˌ|ɛ|s|ˌ|k|juː|ˌ|ɛ|l|ˈ|aɪ|t}},<ref>{{cite episode |series=The Changelog |number=201 |title=Why SQLite succeeded as a database — Richard Hipp, creator of SQLite |time=00:17:25 |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.}}</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 = [...] ess-kju-ellite [...] }}</ref> {{IPAc-en|ˈ|s|iː|k|w|ə|,|l|aɪ|t}}<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 = [...] sequelite [...] }}</ref>) is a [[relational database management system]] (RDBMS) contained in a [[C (programming language)|C]] [[library (computer science)|library]]. In contrast to many other database management systems, SQLite is not a [[client–server]] database engine. Rather, it is embedded into the end program.
'''SQLite''' ({{IPAc-en|ˌ|ɛ|s|ˌ|k|juː|ˌ|ɛ|l|ˈ|aɪ|t}},<ref>{{cite episode |series=The Changelog |number=201 |title=Why SQLite succeeded as a database — Richard Hipp, creator of SQLite |time=00:17:25 |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.}}</ref><ref>{{cite video | people = [[wikipedia:D. Richard Hipp|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 = [...] ess-kju-ellite [...] }}</ref> {{IPAc-en|ˈ|s|iː|k|w|ə|,|l|aɪ|t}}<ref>{{cite video | people = [[wikipedia:D. Richard Hipp|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 = [...] sequelite [...] }}</ref>) is a [[wikipedia:relational database management system|relational database management system]] (RDBMS) contained in a [[wikipedia:C (programming language)|C]] [[wikipedia:library (computer science)|library]]. In contrast to many other database management systems, SQLite is not a [[wikipedia:client–server|client–server]] database engine. Rather, it is embedded into the end program.
[[Category:Computer science]]
[[Category:Computer science]]