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 has been added for CHECK constraints, DESC indices, IF [NOT] EXISTS clauses on CREATE and DROP statements, a more efficient on-disk encoding for boolean values, and the ability to share the page and schema cache between database connections in the same thread. This is the first stable release in the 3.3 series.

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]