#!/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-Feb-15} {Versions 2.8.16 and 3.1.2 Released} { A critical bug in the VACUUM command that can lead to database corruption has been fixed in both the 2.x branch and the main 3.x line. This bug has existed in all prior versions of SQLite. Even though it is unlikely you will ever encounter this bug, it is suggested that all users upgrade. See ticket #1116. for additional information. Version 3.1.2 is also the first stable release of the 3.1 series. SQLite 3.1 features added support for correlated subqueries, autovacuum, autoincrement, ALTER TABLE, and other enhancements. See the release notes for version 3.1.0 for a detailed description of the changes available in the 3.1 series. } newsitem {2004-Nov-09} {SQLite at the 2004 International PHP Conference} { There was a talk on the architecture of SQLite and how to optimize SQLite queries at the 2004 International PHP Conference in Frankfurt, Germany. Slides from that talk are available. } newsitem {2004-Oct-10} {SQLite at the 11th Annual Tcl/Tk Conference} { There will be a talk on the use of SQLite in Tcl/Tk at the 11th Tcl/Tk Conference this week in New Orleans. Visit http://www.tcl.tk/ for details. Slides from the talk are available. } puts {

Old news...

} footer {$Id: index.tcl,v 1.107 2005/02/15 13:38:46 drh Exp $}