#!/usr/bin/tclsh source common.tcl header {SQLite home page} puts {

About SQLite

SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. Features include:

  • Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
  • Zero-configuration - no setup or administration needed.
  • Implements most of SQL92. (Features not supported)
  • A complete database is stored in a single disk file.
  • Database files can be freely shared between machines with different byte orders.
  • Supports databases up to 2 terabytes (241 bytes) in size.
  • Sizes of strings and BLOBs limited only by available memory.
  • Small code footprint: less than 30K lines of C code, less than 250KB code space (gcc on i486)
  • Faster than popular client/server database engines for most common operations.
  • Simple, easy to use API.
  • TCL bindings included. Bindings for many other languages available separately.
  • Well-commented source code with over 95% test coverage.
  • Self-contained: no external dependencies.
  • Sources are in the public domain. Use for any purpose.

The SQLite 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.

News

} proc newsitem {date title text} { puts "

$date - $title

" regsub -all "\n( *\n)+" $text "

\n\n

" txt puts "

$txt

" puts "
" } newsitem {2005-Mar-29} {Version 3.2.1} { This release fixes a memory allocation problem in the new ALTER TABLE ADD COLUMN command. } newsitem {2005-Mar-21} {Version 3.2.0} { The primary purpose for version 3.2.0 is to add support for ALTER TABLE ADD COLUMN. The new ADD COLUMN capability is made possible by AOL developers supporting and embracing great open-source software. Thanks, AOL! Version 3.2.0 also fixes an obscure but serious bug that was discovered just prior to release. If you have a multi-statement transaction and within that transaction an UPDATE or INSERT statement fails due to a constraint, then you try to rollback the whole transaction, the rollback might not work correctly. See Ticket #1171 for details. Upgrading is recommended for all users. } newsitem {2005-Mar-16} {Version 3.1.6} { Version 3.1.6 fixes a critical bug that can cause database corruption when inserting rows into tables with around 125 columns. This bug was introduced in version 3.0.0. See Ticket #1163 for additional information. } newsitem {2005-Mar-11} {Versions 3.1.4 and 3.1.5 Released} { Version 3.1.4 fixes a critical bug that could cause database corruption if the autovacuum mode of version 3.1.0 is turned on (it is off by default) and a CREATE UNIQUE INDEX is executed within a transaction but fails because the indexed columns are not unique. Anyone using the autovacuum feature and unique indices should upgrade. Version 3.1.5 adds the ability to disable the F_FULLFSYNC ioctl() in OS-X by setting "PRAGMA synchronous=on" instead of the default "PRAGMA synchronous=full". There was an attempt to add this capability in 3.1.4 but it did not work due to a spelling error. } newsitem {2005-Feb-19} {Version 3.1.3 Released} { Version 3.1.3 cleans up some minor issues discovered in version 3.1.2. } puts {

Old news...

} footer {$Id: index.tcl,v 1.115 2005/03/29 13:19:02 drh Exp $}