SQLite

From Seeds of the Word
Revision as of 21:49, April 3, 2021 by Johnrdorazio (talk | contribs)
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.

The SQLite team published a document Code of Ethics, also known as "Code of Conduct", as a reference for developers, in which the founder and the developers participating in the project pledged to govern their interactions with each other, with their clients, and with the larger SQLite community, taking inspiration from chapter 4 of the Rule of Saint Benedict.

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