SQLite3SQLite 3SQLite4SQLite 3.8.3+SQLiteDBStorage (SQLite)
SQLite is a relational database management system (RDBMS) contained in a C library.wikipedia
391 Related Articles
D. Richard Hipp designed SQLite in the spring of 2000 while working for General Dynamics on contract with the United States Navy.
Dwayne Richard Hipp (born April 9, 1961) is the architect and primary author of SQLite as well as the Fossil SCM.
SQLite is a popular choice as embedded database software for local/client storage in application software such as web browsers.
relational database management systemRDBMSrelational databases
SQLite is a relational database management system (RDBMS) contained in a C library.
According to DB-Engines, in July 2019, the most widely used systems were Oracle, MySQL (free software), Microsoft SQL Server, PostgreSQL (free software), IBM DB2, Microsoft Access, SQLite (free software), and MariaDB (free software).
XULRunner stores a variety of configuration data (bookmarks, cookies, contacts etc.) in internally managed SQLite databases, and even offer an add-on to manage SQLite databases.
WordPress (WordPress.org) is a content management system (CMS) based on PHP and MySQL that is usually used with the MySQL or MariaDB database servers but can also use the SQLite database engine.
common table expressionsHierarchical queryrecursive queries
Common table expressions support was added to SQLite in version 3.8.3.
Recursive CTEs are also supported by Microsoft SQL Server (since SQL Server 2008 R2), Firebird 2.1, PostgreSQL 8.4+, SQLite 3.8.3+, IBM Informix version 11.50+, CUBRID, MariaDB 10.2+ and MySQL 8.0.1+,.
ChromeChrome browserGoogle Chrome Extensions
Chrome was assembled from 25 different code libraries from Google and third parties such as Mozilla's Netscape Portable Runtime, Network Security Services, NPAPI (dropped as of version 45), Skia Graphics Engine, SQLite, and a number of other open-source projects.
SQLite is called zero-conf because it does not require service management (such as startup scripts) or access control based on GRANT and passwords.
SQLite does not have any DCL commands as it does not have usernames or logins.
For example, it partially provides triggers, and it cannot write to views (however it provides INSTEAD OF triggers that provide this functionality).
SQLite only supports row-level triggers, not statement-level triggers.
SQLite's code is hosted with Fossil, a distributed version control system that is itself built upon an SQLite database.
Content is stored using a SQLite database so that transactions are atomic even if interrupted by a power loss or system crash.
ThunderbirdMozilla Thunderbird PortableThunderbird 126.96.36.199
Thunderbird also uses Mork and (since version 3) MozStorage (which is based on SQLite) for its internal database.
Inspired by CVSTrac, Jonas Borgström and Daniel Lundin from Edgewall Software started writing svntrac in August 2003 using SQLite and Subversion.
SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality.
AIRAdobe Integrated Runtime.air
AIR enables applications to work with data in different ways, including using local files, local SQLite databases (for which AIR has built-in support), a database server, or the encrypted local store included with AIR.
DrupalConOpen AtriumDrupal 7
Drupal 7 supports the file-based SQLite database engine, which is part of the standard PHP distribution.
ODBCODBC driverDatabase driver
It is not uncommon to find ODBC drivers for database engines that are meant to be embedded, like SQLite, as a way to allow existing tools to act as front-ends to these engines for testing and debugging.
FlameFlame VirusFlame (computer virus)
The malware uses five different encryption methods and an SQLite database to store structured information.
It allows data organized by the relational entity–attribute model to be serialized into XML, binary, or SQLite stores.
The W3C Web Applications Working Group ceased working on the specification in November 2010, citing a lack of independent implementations (i.e. the use of a database system other than SQLite as the backend) as the reason the specification could not move forward to become a W3C Recommendation.
DjangoDjango web frameworkDjango framework
Django officially supports four database backends: PostgreSQL, MySQL, SQLite, and Oracle.
Evernote Data Access and ManagementEvernote WebEvernotes
On supported operating systems, Evernote allows users to store and edit notes on their local machine, using a SQLite database in Windows.
Currently supported database systems are MySQL, PostgreSQL, Oracle, and SQLite.
Symbian OSSymbian^3Symbian Belle