Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
SQLite
open-in-new
<p>SQLite is a <a href="/facts/Free_and_open-source_software/1cHtjLCB">free and open-source</a> <a href="/facts/Relational_database/pEKGmJLy">relational</a> <a href="/facts/Database_engine/w4V0QlqB">database engine</a> written in the <a href="/facts/C_Language/Ky2No763">C programming language</a>. It is not a standalone app; rather, it is a <a href="/facts/Library_(computing)/xRzL3P7q">library</a> that <a href="/facts/Programmer/WGTS1Jv9">software developers</a> embed in their <a href="/facts/Application_software/YQuj7Kog">apps</a>. As such, it belongs to the family of <a href="/facts/Embedded_database/FMl3mz5S">embedded databases</a>. It is the most widely deployed database engine, as it is used by several of the top <a href="/facts/Web_browser/2pfyymLs">web browsers</a>, <a href="/facts/Operating_system/8XTuvMh2">operating systems</a>, <a href="/facts/Mobile_phone/H3EcqD9h">mobile phones</a>, and other <a href="/facts/Embedded_system/a4muX1wU">embedded systems</a>. </p><p>Many <a href="/facts/Programming_language/cWTYbgWa">programming languages</a> have <a href="/facts/Language_binding/V5HW4Wr4">bindings</a> to the SQLite library. It generally follows <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a> syntax, but does not enforce <a href="/facts/Type_checking/Tz0bAMS9">type checking</a> by default. This means that one can, for example, insert a string into a <a href="/facts/Column_(database)/WB91xSVs">column</a> defined as an integer. Although it is a lightweight embedded database, SQLite implements most of the <a href="/facts/SQL/UjQLJcYm">SQL</a> standard and the <a href="/facts/Relational_model/VFf4dDIU">relational model</a>, including <a href="/facts/Transaction_processing/Q0WHeD9R">transactions</a> and <a href="/facts/ACID/XdHkYzHN">ACID</a> guarantees. However, it omits many features implemented by other databases, such as <a href="/facts/Materialized_view/eJhoKA2Q">materialized views</a> and complete support for <a href="/facts/Database_trigger/yhI7KW6H">triggers</a> and <a href="/facts/SQL_syntax/6qp9Hwup">ALTER TABLE statements</a>. </p>