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
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.
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.
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.
Old news...
|
