SQLite
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.
| Tags | Database Database Engines/Servers |
|---|---|
| Licenses | Public Domain |
| Operating Systems | Windows Windows POSIX |
| Implementation | C SQL Tcl |
Recent releases
- 17 Apr 2009 11:57
Changes: This release fixes a bug that caused a segfault when running a count(*) on the sqlite_master table of an empty database, a bug that caused a segfault when inserting into a table using a DEFAULT value when there was a function as part of the DEFAULT value expression, data structure alignment issues on Sparc, and other minor problems.
- 29 Jan 2009 17:30
No changes have been submitted for this release.
- 10 Jan 2007 12:12
Changes: This release fixes a bug that could cause database corruption when a multi-processor system attempted to rollback an incomplete transaction following a system crash. It also fixes various other less severe bugs and enhances the query optimizer.
- 17 Feb 2006 03:09
No changes have been submitted for this release.
- 31 Jan 2006 10:48
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.
drh
29 May 2000 20:22
Heartbeat
- Popularity Score
- 1,155.91
- Vitality Score
- 19.07
- Subscriptions
- 374
- All comments
Recent commentsNeed older versions
Can please let me know the link from which i can load the first version of sqlite? ( sqlite 0.1 ?)
Cheers,
Lakshmipathi.G
Hard to say too much good about this...
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.