SQLite

SQLite
Developer(s)D. Richard Hipp
Initial release17 August 2000;
24 years ago (2000-08-17)
Stable release3.47.0[1] Edit this on Wikidata (21 October 2024; 20 days ago (21 October 2024)) [±]
Repository
Written inC
Operating systemCross-platform
Size699 KiB
TypeRDBMS (embedded)
LicensePublic domain[2]
Websitesqlite.org Edit this at Wikidata
SQLite Database File Format
Filename extension
.sqlite, .sqlite3, .db, .db3, .s3db, .sl3
Internet media typeapplication/vnd.sqlite3[3]
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)
Websitewww.sqlite.org/fileformat2.html

SQLite (/ˌɛsˌkjuːˌɛlˈaɪt/,[4][5] /ˈsiːkwəˌlaɪt/[6]) is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases. It is the most widely deployed database engine, as it is used by several of the top web browsers, operating systems, mobile phones, and other embedded systems.[7]

Many programming languages have bindings to the SQLite library. It generally follows PostgreSQL syntax, but does not enforce type checking by default.[8][9] This means that one can, for example, insert a string into a column defined as an integer.

  1. ^ "SQLite Release 3.47.0 On 2024-10-21". 21 October 2024. Retrieved 21 October 2024.
  2. ^ "SQLite Copyright". sqlite.org. Archived from the original on October 10, 2023. Retrieved May 17, 2010.
  3. ^ "SQLite database file format media type at IANA". Internet Assigned Numbers Authority. IANA. Archived from the original on 2022-11-09. Retrieved 2019-03-08.
  4. ^ "Why SQLite succeeded as a database — Richard Hipp, creator of SQLite". The Changelog. Episode 201. Event occurs at 00:17:25. Archived from the original on 2022-07-07. Retrieved 2019-08-06. How do I pronounce the name of the product? I say S-Q-L-ite, like a mineral.
  5. ^ 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 [...]
  6. ^ D. Richard Hipp (presenter) (May 31, 2006). An Introduction to SQLite. Google Inc. Event occurs at 00:48:15. Retrieved March 23, 2010. [...] sequelite [...]
  7. ^ "Most Widely Deployed SQL Database Estimates". SQLite.org. Retrieved May 11, 2011.
  8. ^ Owens, Michael (2006). "Chapter 4: SQL". In Gilmore, Jason; Thomas, Keir (eds.). The Definitive Guide to SQLite. D. Richard Hipp (foreword), Preston Hagar (technical reviewer). Apress. p. 133. ISBN 978-1-59059-673-9. Archived from the original on 24 November 2020. Retrieved 30 December 2014.
  9. ^ "STRICT Tables". Archived from the original on 2022-08-07. Retrieved 2022-08-11.