Difference between revisions of "SQLite"

From Seeds of the Word
(Created page with "{{short description|Serverless relational database management system (RDBMS)}}{{Infobox software | logo = SQLite370.svg | logo size = 220px | sc...")
 
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]]

Revision as of 21:42, April 3, 2021

SQLite
SQLite370.svg
Developer(s)D. Richard Hipp
Initial release17 August 2000;
21 years ago
 (2000-08-17)
Written inC
Operating systemCross-platform
Size699 KiB
TypeRDBMS (embedded)
LicensePublic domain[1]
SQLite Database File Format
Filename extension
.sqlite3, .sqlite, .db
Internet media typeapplication/vnd.sqlite3[2]
Magic number53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 (zero-terminated ASCII "SQLite format 3")
Initial release2004-06-18
Open format?yes (Public Domain)
Websitesqlite.org/fileformat2.html

SQLite (/ˌɛsˌkjuːˌɛlˈt/,[3][4] /ˈskwəˌlt/[5]) is a relational database management system (RDBMS) contained in a C 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.

  1. "SQLite Copyright". sqlite.org. Retrieved May 17, 2010.
  2. "SQLite database file format media type at IANA". Internet Assigned Numbers Authority. IANA. Retrieved 2019-03-08.
  3. "Why SQLite succeeded as a database — Richard Hipp, creator of SQLite". The Changelog. Episode 201. Event occurs at 00:17:25. How do I pronounce the name of the product? I say S-Q-L-ite, like a mineral.
  4. D. Richard Hipp (presenter) (May 31, 2006). An Introduction to SQLite (video). Google Inc. Event occurs at 00:01:14. Retrieved March 23, 2010. [...] ess-kju-ellite [...]
  5. D. Richard Hipp (presenter) (May 31, 2006). An Introduction to SQLite. Google Inc. Event occurs at 00:48:15. Retrieved March 23, 2010. [...] sequelite [...]