SQLite: Difference between revisions
Johnrdorazio (talk | contribs) (Created page with "{{short description|Serverless relational database management system (RDBMS)}}{{Infobox software | logo = SQLite370.svg | logo size = 220px | sc...") |
Johnrdorazio (talk | contribs) 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 [[Kibibyte|KiB]]<!-- outout of sqlite3 dd.sqlite 'select 715816 / 1024;' 201411031830 --> | | size = 699 [[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
 | |
| Developer(s) | D. Richard Hipp |
|---|---|
| Initial release | 17 August 2000 |
| Written in | C |
| Operating system | Cross-platform |
| Size | 699 KiB |
| Type | RDBMS (embedded) |
| License | Public domain[1] |
| Filename extension |
.sqlite3, .sqlite, .db |
|---|---|
| Internet media type | application/vnd.sqlite3[2] |
| 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 (/ˌɛ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 [...]