The following documentation is currently available:

• A Quick Start guide to using SQLite in 5 minutes or less.
• Frequently Asked Questions are available online.
• Information on the sqlite command-line utility.
• SQLite is typeless.
• The SQL Language subset understood by SQLite.
• The C/C++ Interface.
• The NULL handling in SQLite versus other SQL database engines.
• The Tcl Binding to SQLite.
• The Architecture of the SQLite Library describes how the library is put together.
• A description of the virtual machine that SQLite uses to access the database.
• A description of the database file format used by SQLite.
• A speed comparison between SQLite, PostgreSQL, and MySQL.
• User-written documentation is available on the SQLite Wiki. Please contribute if you can.

The SQLite source code is 30% comment. These comments are another important source of information.

Building From Source

To statically link with your application (as a library):

• start a new empty library project
• add all .c files in the sqlite directory to the library, except shell.c
• include "sqlite.h" in your program
• build and link with your program

To dinamically link with your application (as a DLL):

• start a new empty DLL project
• add all .c files in the sqlite directory to the project, except shell.c
• add "sqlite.def" to the project
• build the DLL
• include "sqlite.h" in your program
• link with the import library built