SQLite: Difference between revisions

SQLite Database File Format
Filename extension	.sqlite3, .sqlite, .db
Internet media type	application/vnd.sqlite3
Magic number	53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 (zero-terminated ASCII "SQLite format 3")
Initial release	2004-06-18
Open format?	yes (Public Domain)
Website	sqlite.org/fileformat2.html

SQLite
Developer(s)	D. Richard Hipp
Initial release	17 August 2000;; 24 years ago
Written in	C
Operating system	Cross-platform
Size	699 KiB
Type	RDBMS (embedded)
License	Public domain

Browse history interactively

Newer edit →

Content deleted Content added

VisualWikitext

Inline

Revision as of 21:42, April 3, 2021

SQLite (/ˌɛsˌkjuːˌɛlˈaɪt/,^[3]^[4] /ˈsiːkwəˌlaɪt/^[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.

↑ "SQLite Copyright". sqlite.org. Retrieved May 17, 2010.
↑ "SQLite database file format media type at IANA". Internet Assigned Numbers Authority. IANA. Retrieved 2019-03-08.
↑ "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.
↑ 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 [...]
↑ D. Richard Hipp (presenter) (May 31, 2006). An Introduction to SQLite. Google Inc. Event occurs at 00:48:15. Retrieved March 23, 2010. [...] sequelite [...]

[license-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 [...]

[1]

[2]

[3]

[4]

[5]

@@ Line 5: / Line 5: @@
 | caption                =
 | 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}}
 | latest preview version =
 | 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               =
-| 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
  | title      = SQLite Copyright
@@ Line 30: / Line 30: @@
  | 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]]
+ | 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>
 | 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")
+| 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     =
 | genre         =
@@ Line 41: / Line 41: @@
 | extended from =
 | standard      =
-| free          = yes ([[Public Domain]])
+| free          = yes ([[wikipedia:Public Domain|Public Domain]])
 | 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]]