#Sqlite documentation full

FTS3 - Full Text Search→ A description of the SQLite Full Text Search (FTS3) extension.

FTS5 - Full Text Search→ A description of the SQLite Full Text Search (FTS5) extension.

Json1 - JSON Integration→ SQL functions for creating, parsing, and querying JSON content.

This page describes data typing for SQLite version 3 in further detail.

DataTypes→ SQLite version 3 introduces the concept of manifest typing, where the type of a value is associated with the value itself, not the column that it is stored in.

Tcl API→ A description of the TCL interface bindings for SQLite.

Generated Columns→ Stored and virtual columns in table definitions.

Window Functions→ SQL Window functions.

Date and Time SQL Functions→ SQL functions for manipulating dates and times.

Aggregate SQL Functions→ General-purpose built-in aggregate SQL functions.

Core SQL Functions→ General-purpose built-in scalar SQL functions.

Pragma commands→ This document describes SQLite performance tuning options and other special purpose database commands.

SQL Syntax→ This document describes the SQL language that is understood by SQLite.

Result and Error Codes→ A description of the meanings of the numeric result codes returned by various C/C++ interfaces.

C/C++ API Reference→ This document describes each API function separately.

#Sqlite documentation how to

How To Compile SQLite→ Instructions and hints for compiling SQLite C code and integrating that code with your own application.Users should read this document before the C/C++ API Reference Guide linked below. Introduction to the C/C++ API → This document introduces the C/C++ API.SQLite In 5 Minutes Or Less→ A very quick introduction to programming with SQLite.

Books About SQLite→ A list of independently written books about SQLite.Frequently Asked Questions→ The title of the document says all.This document describes what that means and the implications for contributors. Copyright→ SQLite is in the public domain.This document identifies the many tests that occur before every release of SQLite. How SQLite Is Tested→ The reliability and robustness of SQLite is achieved in large part by thorough and careful testing.

The list includes both deliberate innovations and 'misfeatures' that are retained only for backwards compatibility.

Quirks of SQLite→ This document is a short list of some unusual features of SQLite that tend to cause misunderstandings and confusion.

Distinctive Features→ This document enumerates and describes some of the features of SQLite that make it different from other SQL database engines.

Appropriate Uses For SQLite→ This document describes situations where SQLite is an appropriate database engine to use versus situations where a client/server database engine might be a better choice.

About SQLite→ A high-level overview of what SQLite is and why you might be interested in using it.