# # Run this TCL script to generate HTML for the index.html file. # set rcsid {$Id: index.tcl,v 1.54 2002/02/18 18:30:33 drh Exp $} puts { SQLite: An SQL Database Engine In A C Library

SQLite: An SQL Database Engine In A C Library

} puts "This page was last modified on [lrange $rcsid 3 4] UTC
" set vers [lindex $argv 0] puts "The latest SQLite version is $vers" puts " created on [exec cat last_change] UTC" puts {

} puts {


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.

} puts {
} puts {


} puts {

Current Status

A change history is available online. The latest source code is available for download. For a list of recently discovered bugs, refer to the change history.

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


The following documentation is currently available:

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

} puts {

Click to subscribe to sqlite

Mailing List

A mailing list has been set up on yahooGroups for discussion of SQLite design issues or for asking questions about SQLite.

} puts {

Professional Support and Custom Modifications

} puts {

If you would like professional support for SQLite or if you want custom modifications to SQLite preformed by the original author, these services are available for a modest fee. For additional information contact:

D. Richard Hipp
Hwaci - Applied Software Research
} puts {

Building From Source

} puts {

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 
} puts {

Related Sites

} puts {

More Open Source Software from Hwaci.