SQLite

SQLite is a relational database management system contained in a C programming library. In contrast to many other database management systems, SQLite is not a client–server database engine. Rather, it is embedded into the end program.

SQLite is ACID-compliant and implements most of the SQL standard, using a dynamically and weakly typed SQL syntax that does not guarantee the domain integrity.^[1]

SQLite is a popular choice as embedded database software for local/client storage in application software such as web browsers. It is arguably the most widely deployed database engine, as it is used today by several widespread browsers, operating systems, and embedded systems (such as mobile phones), among others.^[2]
SQLite has bindings to many programming languages.

Table of ContentsEdit

This book requires that you first read Structured Query Language.

A printable version of SQLite is available. (edit it)

Wikipedia has related information at SQLite

Introduction

Downloading and using

SQL standard divergences

API TutorialEdit

Introductory exercise

Command-line tool ReferenceEdit

sqlite3

sqldiff

sqlite3_analyzer

External linksEdit

SQLite Tutorial

ReferencesEdit

↑ Owens, Michael (2006). "Chapter 4: SQL". in Gilmore, Jason; Thomas, Keir. The Definitive Guide to SQLite. D. Richard Hipp (foreword), Preston Hagar (technical reviewer). Apress. p. 133. ISBN 978-1-59059-673-9.
↑ "Most Widely Deployed SQL Database Estimates". SQLite.org. https://sqlite.org/mostdeployed.html. Retrieved May 11, 2011.

[Owens_2006-1] Owens, Michael (2006). "Chapter 4: SQL". in Gilmore, Jason; Thomas, Keir. The Definitive Guide to SQLite. D. Richard Hipp (foreword), Preston Hagar (technical reviewer). Apress. p. 133. ISBN 978-1-59059-673-9.

[2] "Most Widely Deployed SQL Database Estimates". SQLite.org. https://sqlite.org/mostdeployed.html. Retrieved May 11, 2011.

[1]

[2]