SQLite: An SQL Database Engine In A C Library

This version of SQLite included with the Sambar Server is 2.5.6

Introduction

The Sambar Server includes an "internal" RDBMS (SQLite) for use by applications. This RDBMS is accessible by simply defining a DBMS datasource of type internal-sqlite in the config/dbconfig.ini:

[test]
Datasource = internal-sqlite
Username = ignored
Password = ignored
Maximum Rows = 1000
Maximum Column Length = 8192
Maximum Used Connections = 5
Minimum Free Connections = 1
Maximum Idle Period = 10
Single Thread = false
Trace SQL = false
Trace Performance = false

A SQLite DBMS will be automatically created in the dbms directory within the Sambar Server installation directory. The DBMS filename corresponds with the cache name (test in the above example).

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.

The SQLite home page is at: http://www.hwaci.com/sw/sqlite/.

Features

Implements a large subset of SQL92.
A complete database (with multiple tables and indices) is stored in a single disk file.
Atomic commit and rollback protect data integrity.
Small memory footprint: about 14000 lines of C code.
Four times faster than PostgreSQL. Twice as fast as SQLite 1.0.
Very simple C/C++ interface requires the use of only three functions and one opaque structure.
TCL bindings included.
A TCL-based test suite provides near 100% code coverage.
Self-contained: no external dependencies.
Built and tested under Linux and Win2K.
Sources are uncopyrighted. Use for any purpose.

Documentation

The following documentation is currently available:

Frequently Asked Questions.
Information on the sqlite command-line utility.
The SQL Language subset understood by SQLite.

Mailing List

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

Professional Support and Custom Modifications

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
704.948.4565
drh@hwaci.com