SQLite

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

Richard Hipp
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.

Embedded database

EmbeddedembeddingVistaDB
SQLite is a popular choice as embedded database software for local/client storage in application software such as web browsers.

Relational database

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

Mozilla XULRunner
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

WordCampbbPressWord Press
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.

Hierarchical and recursive queries in SQL

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+,.

Google Chrome

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.

Data control language

DCLGRANT
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.

Database trigger

triggerstriggerprocedural triggers
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.

Fossil (software)

FossilFossil SCMFossil-scm
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.

Mozilla Thunderbird

ThunderbirdMozilla Thunderbird PortableThunderbird 1.5.0.2
Thunderbird also uses Mork and (since version 3) MozStorage (which is based on SQLite) for its internal database.

Trac

Inspired by CVSTrac, Jonas Borgström and Daniel Lundin from Edgewall Software started writing svntrac in August 2003 using SQLite and Subversion.

SpatiaLite

SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality.

Adobe AIR

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.

Drupal

DrupalConOpen AtriumDrupal 7
Drupal 7 supports the file-based SQLite database engine, which is part of the standard PHP distribution.

Open Database Connectivity

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.

Flame (malware)

FlameFlame VirusFlame (computer virus)
The malware uses five different encryption methods and an SQLite database to store structured information.

Core Data

CoreData
It allows data organized by the relational entity–attribute model to be serialized into XML, binary, or SQLite stores.

Web SQL Database

WebSQL
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.

Django (web framework)

DjangoDjango web frameworkDjango framework
Django officially supports four database backends: PostgreSQL, MySQL, SQLite, and Oracle.

Evernote

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.

Bugzilla

Buggie
Currently supported database systems are MySQL, PostgreSQL, Oracle, and SQLite.