SQLite
An Embeddable SQL Database Engine

This page was last modified on 2003/08/22 02:34:30 UTC
The latest SQLite version is 2.8.6 created on 2003/08/20 01:03:34 UTC

Introduction

SQLite is a C library that implements an embeddable SQL database engine. Programs that link with the SQLite library can have SQL database access without running a separate RDBMS process. The distribution comes with a standalone command-line access program (sqlite) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library.

SQLite is not a client library used to connect to a big database server. SQLite is the server. The SQLite library reads and writes directly to and from the database files on disk.

Features

• Implements most of SQL92. (Features not supported)
• A complete database (with multiple tables and indices) is stored in a single disk file.
• Atomic commit and rollback protect data integrity.
• Database files can be freely shared between machines with different byte orders.
• Supports databases up to 2 terabytes (2^41 bytes) in size.
• Small memory footprint: less than 25K lines of C code.
• Two times faster than PostgreSQL and MySQL for many common operations.
• Very simple C/C++ interface requires the use of only three functions and one opaque structure.
• TCL bindings included. Bindings for many other languages available separately.
• Simple, well-commented source code.
• Automated test suite provides near 100% code coverage.
• Self-contained: no external dependencies.
• Built and tested under Linux and Windows.
• Sources are in the public domain. Use for any purpose.

Current Status

A Change Summary is available on this website. You can also access a detailed change history, view open bugs, or report new bugs at the CVS server.

Complete source code and precompiled binaries for the latest release are available for download on this site. You can also obtain the latest changes by anonymous CVS access:

cvs -d :pserver:anonymous@www.sqlite.org:/sqlite login
cvs -d :pserver:anonymous@www.sqlite.org:/sqlite checkout sqlite

Note that the CVS server is located on a cable modem with a dynamic IP address. The IP address changes every 3 or 4 months. After an IP address change occurs it usually takes a day or two for the new DNS information to propagate. So if you have trouble accessing the CVS server, it could be because the IP address has recently changed. Try again in a few days.

Whenever either of the first two digits in the version number for SQLite change, it means that the underlying file format has changed. Usually these changes are backwards compatible. See formatchng.html for additional information.

Documentation

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.

Click to subscribe to sqlite

If you would like professional support for SQLite or if you want custom modifications to SQLite performed by the original author, these services are available for a modest fee. For additional information visit http://www.hwaci.com/sw/sqlite/support.html or contact:

D. Richard Hipp
Hwaci - Applied Software Research
704.948.4565
drh@hwaci.com

Building From Source

To build sqlite under Unix, just unwrap the tarball, create a separate build directory, run configure from the build directory and then type "make". For example:

$ tar xzf sqlite.tar.gz       Unpacks into directory named "sqlite" 
$ mkdir bld                   Create a separate build directory 
$ cd bld
$ ../sqlite/configure
$ make                        Builds "sqlite" and "libsqlite.a" 
$ make test                   Optional: run regression tests 

If you prefer, you can also build by making whatever modifications you desire to the file "Makefile.linux-gcc" and then executing that makefile. Tha latter method is used for all official development and testing of SQLite and for building the precompiled binaries found on this website. Windows binaries are generated by cross-compiling from Linux using MinGW

Related Sites

For information bindings of SQLite to other programming languages (Perl, Python, Ruby, PHP, etc.) and for a list of programs currently using SQLite, visit the Wiki documentation at:

http://www.sqlite.org/cvstrac/wiki