Back إس كيو لايت Arabic SQLite Byelorussian SQLite Bulgarian SQLite Catalan SQLite Czech SQLite German SQLite Greek SQLite Spanish اس‌کیوال لایت Persian SQLite Finnish

SQLite

SQLite
Developer(s)D. Richard Hipp
Initial release17 August 2000;
24 years ago (2000-08-17)
Stable release3.48.0[1] Edit this on Wikidata (14 January 2025; 11 days ago (14 January 2025)) [±]
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)
Websitesqlite.org/fileformat.html

SQLite (/ˌɛsˌkjuːˌɛlˈaɪt/,[4][5] /ˈsiːkwəˌlaɪt/[6]) is a free and open-source relational 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. Although it is a lightweight embedded database, SQLite implements most of the SQL standard and the relational model, including transactions and ACID guarantees.[10] However, it omits many features implemented by other databases, such as materialized views and complete support for triggers and ALTER TABLE statements.[11]

  1. ^ "SQLite Release 3.48.0 On 2025-01-14". 14 January 2025. Retrieved 14 January 2025.
  2. ^ "SQLite Copyright". sqlite.org. Retrieved May 17, 2010.{{cite web}}: CS1 maint: url-status (link)
  3. ^ "SQLite database file format media type at IANA". Internet Assigned Numbers Authority. IANA. Retrieved 2019-03-08.{{cite web}}: CS1 maint: url-status (link)
  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.
  10. ^ "Full-Featured SQL". SQLite. Retrieved January 24, 2025.
  11. ^ "SQL Features That SQLite Does Not Implement". SQLite. Retrieved January 24, 2025.
From Wikipedia, the free encyclopedia · View on Wikipedia

Developed by Nelliwinne