blob: 2eb5cef8c176451ace324d0ccba19fd97d696cf3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
|
#!/usr/bin/tclsh
source common.tcl
header {SQLite home page}
puts {
<table width="100%" border="0" cellspacing="5">
<tr>
<td width="50%" valign="top">
<h2>About SQLite</h2>
<p>
<table align="right" border="0"><tr><td>
<a href="http://osdir.com/Article6677.phtml">
<img src="2005osaward.gif"></a>
</td></tr></table>
SQLite is a small
C library that implements a self-contained, embeddable,
zero-configuration
SQL database engine.
Features include:
</p>
<p><ul>
<li>Transactions are atomic, consistent, isolated, and durable (ACID)
even after system crashes and power failures.
<li>Zero-configuration - no setup or administration needed.</li>
<li>Implements most of SQL92.
(<a href="omitted.html">Features not supported</a>)</li>
<li>A complete database is stored in a single disk file.</li>
<li>Database files can be freely shared between machines with
different byte orders.</li>
<li>Supports terabyte-sized databases and gigabyte-sized strings
and blobs. (See <a href="limits.html">limits.html</a>.)
<li>Small code footprint:
<a href="http://www.sqlite.org/cvstrac/wiki?p=SizeOfSqlite">
less than 250KiB</a> fully configured or less
than 150KiB with optional features omitted.</li>
<li><a href="speed.html">Faster</a> than popular client/server database
engines for most common operations.</li>
<li>Simple, easy to use <a href="capi3.html">API</a>.</li>
<li><a href="tclsqlite.html">TCL bindings</a> included.
Bindings for many other languages
<a href="http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers">
available separately.</a></li>
<li>Well-commented source code with over 98% test coverage.</li>
<li>Available as a
<a href="http://www.sqlite.org/cvstrac/wiki?p=TheAmalgamation">
single ANSI-C source-code file</a> that you can easily drop into
another project.
<li>Self-contained: no external dependencies.</li>
<li>Sources are in the <a href="copyright.html">public domain</a>.
Use for any purpose.</li>
</ul>
</p>
<p>
The SQLite distribution comes with a standalone command-line
access program (<a href="sqlite.html">sqlite</a>) that can
be used to administer an SQLite database and which serves as
an example of how to use the SQLite library.
</p>
</td>
<td width="1" bgcolor="#80a796"></td>
<td valign="top" width="50%">
<h2>News</h2>
}
proc newsitem {date title text} {
puts "<h3>$date - $title</h3>"
regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
puts "<p>$txt</p>"
puts "<hr width=\"50%\">"
}
newsitem {2007-Oct-04} {Version 3.5.1} {
Fix a long-standing bug that might cause database corruption if a
disk-full error occurs in the middle of a transaction and that
transaction is not rolled back.
<a href="http://www.sqlite.org/cvstrac/tktview?tn=2686">Ticket #2686.</a>
The new VFS layer is stable. However, we still reserve the right to
make tweaks to the interface definition of the VFS if necessary.
}
newsitem {2007-Sep-04} {Version 3.5.0 alpha} {
The OS interface layer and the memory allocation subsystems in
SQLite have been reimplemented. The published API is largely unchanged
but the (unpublished) OS interface has been modified extensively.
Applications that implement their own OS interface will require
modification. See
<a href="34to35.html">34to35.html</a> for details.<p>
This is a large change. Approximately 10% of the source code was
modified. We are calling this first release "alpha" in order to give
the user community time to test and evaluate the changes before we
freeze the new design.
}
newsitem {2007-Aug-13} {Version 3.4.2} {
While stress-testing the
<a href="capi3ref.html#sqlite3_soft_heap_limit">soft_heap_limit</a>
feature, a bug that could lead to
<a href="http://www.sqlite.org/cvstrac/wiki?p=DatabaseCorruption">database
corruption</a> was <a href="http://www.sqlite.org/cvstrac/tktview?tn=2565">
discovered and fixed</a>.
Though the consequences of this bug are severe, the chances of hitting
it in a typical application are remote. Upgrading is recommended
only if you use the
<a href="capi3ref.html#sqlite3_soft_heap_limit">sqlite3_soft_heap_limit</a>
interface.
}
newsitem {2007-Jly-20} {Version 3.4.1} {
This release fixes a bug in <a href="lang_vacuum.html">VACUUM</a> that
can lead to <a href="http://www.sqlite.org/cvstrac/wiki?p=DatabaseCorruption">
database corruption</a>. The bug was introduced in version
<a href="changes.html#version_3_3_14">3.3.14</a>.
Upgrading is recommended for all users. Also included are a slew of
other more routine
<a href="changes.html#version_3_4_1">enhancements and bug fixes</a>.
}
puts {
<p align="right"><a href="oldnews.html">Old news...</a></p>
</td></tr></table>
}
footer {$Id: index.tcl,v 1.164 2007/10/03 20:32:17 drh Exp $}
|
