File:SQLite370.svg · Wikimedia Commons · See Wikimedia Commons
Q319417
Sign in to saveAlso known as sqlite3, sqlite.org
SQLite ( "S-Q-L-ite", "sequel-ite") is a free and open-source relational database engine written in the C programming language. It is not a standalone application; rather, it is a library that software developers embed in their applications. As such, it belongs to the family of embedded databases. According to its developers, SQLite 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.
Key facts
- Software.logo
- SQLite370.svg
- Software.logo size
- 220px
- Software.screenshot
- SQLite3.png
- Software.caption
- Screenshot of sqlite3 command-line shell program
- Software.developer
- D. Richard Hipp
- Software.programming language
- C
- Software.operating system
- Cross-platform
- Software.size
- 699 KiB
- Software.genre
- RDBMS (embedded)
- Software.license
- Public domain
- File format.name
- SQLite Database File Format
- File format.extension
- .sqlite, .sqlite3, .db, .db3, .s3db, .sl3
- File format._nomimecode
- yes
- File format.mime
- application/vnd.sqlite3
- File format.magic
- 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 (zero-terminated ASCII "SQLite format 3")
- File format.released
- 2004-06-18
- File format.open
- yes (Public Domain)
via Wikipedia infobox
~14 min read
Encyclopedic overview
17 sectionsContents
- History
- Design
- Features
- Development and distribution
- {{anchor|Adoption}}Notable uses
- Operating systems
- Middleware
- Web browsers
- Web application frameworks
- Others
- See also
- Notes
- References
- Citations
- Sources
- Further reading
- External links
SQLite ( "S-Q-L-ite", "sequel-ite") is a free and open-source relational database engine written in the C programming language. It is not a standalone application; rather, it is a library that software developers embed in their applications. As such, it belongs to the family of embedded databases. According to its developers, SQLite 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.
Many programming languages have bindings to the SQLite library. It generally follows PostgreSQL syntax, but does not enforce type checking by default. 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. However, it omits many features implemented by other databases, such as materialized views and complete support for triggers and ALTER TABLE statements.
Excerpted from Wikipedia’s “Q319417” article, available under the CC BY-SA 4.0 licence.