About:
SQLite is a small, fast, embeddable SQL database engine that supports most of SQL92, including transactions with atomic commit and rollback, subqueries, compound queries, triggers, and views. A complete database is stored in a single cross-platform disk file. The native C/C++ API is simple and easy to use. Bindings for other languages are also available.

Release focus: Major feature enhancements

Changes:
Support for ALTER TABLE ADD COLUMN has been added.

Author:
D. Richard Hipp [contact developer]

Rating:	reset 1 2 3 4 5 6 7 8 9 10
8.50/10.00 (55 votes)

Homepage:
http://www.sqlite.org/
Tar/GZ:
http://www.sqlite.org/download.html
Changelog:
http://www.sqlite.org/changes.html
Mirror site:
http://www.hwaci.com/sw/sqlite/

Trove categories: [change]

[Development Status]		6 - Mature
[Intended Audience]		Developers, End Users/Desktop
[License]		Public Domain
[Operating System]		Microsoft :: Windows, POSIX
[Programming Language]		C, SQL, Tcl
[Topic]		Database :: Database Engines/Servers

Dependencies: [change]
No dependencies filed

 Branches

Branch	Version	Last release	License	URLs
Default	3.3.10	10-Jan-2007	Public Domain
2.x Versions which support the version 2 file format and API.	2.8.16	15-Feb-2005	Public Domain

 Releases

Version	Focus	Date
3.3.10	Major bugfixes	10-Jan-2007 20:12
3.3.4	N/A	17-Feb-2006 11:09
3.3.3	Major feature enhancements	31-Jan-2006 18:48
3.2.8	Minor bugfixes	21-Dec-2005 10:55
3.2.7	N/A	18-Oct-2005 07:09
3.2.6	Major bugfixes	18-Sep-2005 12:05
3.2.0	Major feature enhancements	23-Mar-2005 13:44
3.1.2	Major bugfixes	15-Feb-2005 15:38
3.1.0 (alpha)	Major feature enhancements	21-Jan-2005 22:45
3.0.7	Minor bugfixes	19-Sep-2004 05:46

 Articles referencing this project

• SQLite Tutorial
  by Mike Chirico , in Tutorials
  Sat, Dec 25th 2004 00:00
  
• Lemon Parser Generator Tutorial
  by Mike Chirico , in Tutorials
  Sat, Aug 14th 2004 00:00
  
• SQL Databases for Linux
  by Christopher Browne , in Category Reviews
  Sun, Sep 30th 2001 00:00
  

 Comments

[»] Hard to say too much good about this...
by Charles Duffy - Dec 17th 2003 21:30:04

It's small, fast and very low footprint, the Python bindings are excellent... I'm really exceedingly pleased with SQLite. Since converting cscvs (a project I maintain) to use it, performance and space efficiency have vastly improved over previous versions, and the ease-of-use (and ease-of-setup) perspective makes it tremendously more appropriate for embedded use in a tool of this sort than depending on a full-fledged out-of-process database server.

In short: Try it. You'll like it.

[reply] [top]