Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: |
Downloads: |
Tarball
| ZIP archive
|
---|
Timelines: |
family
| ancestors
| descendants
| both
| trunk
|
Files: |
files
| file ages
| folders
|
SHA1: |
a4e3e075e3b36e0f5f692067c5bf5e1b660d893d |
User & Date: |
drh
2003-08-22 02:34:30.000 |
Context
2003-08-22
| | |
03:00 |
|
(check-in: 0bde7ae2ba user: drh tags: trunk)
|
02:34 |
|
(check-in: a4e3e075e3 user: drh tags: trunk)
|
2003-08-21
| | |
14:36 |
|
(check-in: dc36365eea user: drh tags: trunk)
|
| | |
Changes
Changes to www/changes.tcl.
︙ | | |
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
|
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
|
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
|
<body bgcolor="white">
<h1 align="center">Recent Changes To SQLite</h1>
<p>
This file provides a high-level summary of changes to SQLite.
For more detail, refer the the checkin logs generated by
CVS at
<a href="http://cvs.hwaci.com/sqlite/timeline">
http://cvs.hwaci.com/sqlite/timeline</a>.
<a href="http://www.sqlite.org/cvstrac/timeline">
http:/www.sqlite.org/cvstrac/timeline</a>.
</p>
<DL>
}
proc chng {date desc} {
puts "<DT><B>$date</B></DT>"
puts "<DD><P><UL>$desc</UL></P></DD>"
}
chng {2003 August 21 (2.8.6)} {
<li>Moved the CVS repository to www.sqlite.org</li>
<li>Update the NULL-handling documentation.</li>
<li>Experimental date/time functions added.</li>
<li>Bug fix: correctly evaluate a view of a view without segfaulting.</li>
<li>Bug fix: prevent database corruption if you dropped a
trigger that had the same name as a table.</li>
<li>Bug fix: allow a VACUUM (without segfaulting) on an empty
database after setting the EMPTY_RESULT_CALLBACKS pragma.</li>
<li>Bug fix: if an integer value will not fit in a 32-bit int, store it in
a double instead.</li>
<li>Bug fix: Make sure the journal file directory entry is committed to disk
before writing the database file.</li>
}
chng {2003 July 22 (2.8.5)} {
<li>Make LIMIT work on a compound SELECT statement.</li>
<li>LIMIT 0 now shows no rows. Use LIMIT -1 to see all rows.</li>
<li>Correctly handle comparisons between an INTEGER PRIMARY KEY and
a floating point number.</li>
<li>Fix several important bugs in the new ATTACH and DETACH commands.</li>
|
︙ | | |
Changes to www/index.tcl.
1
2
3
4
5
6
7
8
9
10
11
|
1
2
3
4
5
6
7
8
9
10
11
|
-
+
|
#
# Run this TCL script to generate HTML for the index.html file.
#
set rcsid {$Id: index.tcl,v 1.77 2003/07/22 12:44:54 drh Exp $}
set rcsid {$Id: index.tcl,v 1.78 2003/08/22 02:34:30 drh Exp $}
puts {<html>
<head><title>SQLite: An Embeddable SQL Database Engine</title></head>
<body bgcolor=white>
<h1 align=center>SQLite<br>An Embeddable SQL Database Engine</h1>
<p align=center>}
puts "This page was last modified on [lrange $rcsid 3 4] UTC<br>"
|
︙ | | |
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
-
-
+
+
|
puts {
<table align="right" hspace="10" cellpadding=0 cellspacing=0 broder=0>
<tr><td align="right" bgcolor="#cacae4">
<table border="2" width="100%" cellspacing=0 cellpadding=5><tr><td align="left">
Quick Links:
<ul>
<li><a href="download.html">Download</a></li>
<li><a href="http://cvs.hwaci.com/sqlite/timeline">Change Log</a></li>
<li><a href="http://cvs.hwaci.com/sqlite/tktnew">Report a bug</a></li>
<li><a href="http://www.sqlite.org/cvstrac/timeline">Change Log</a></li>
<li><a href="http://www.sqlite.org/cvstrac/tktnew">Report a bug</a></li>
<li><a href="quickstart.html">Quick start</a></li>
</ul>
</td></tr></table>
</td></tr>
</table>
}
|
︙ | | |
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
|
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
|
-
+
-
-
+
+
-
+
-
+
|
<li><a href="speed.html">Two times faster</a> than PostgreSQL and
MySQL for many common operations.</li>
<li>Very simple
<a href="c_interface.html">C/C++ interface</a> requires the use of only
three functions and one opaque structure.</li>
<li><a href="tclsqlite.html">TCL bindings</a> included.
Bindings for many other languages
<a href="http://cvs.hwaci.com/sqlite/wiki?p=SqliteWrappers">
<a href="http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers">
available separately.</a></li>
<li>Simple, well-commented source code.</li>
<li>Automated test suite provides near 100% code coverage.</li>
<li>Self-contained: no external dependencies.</li>
<li>Built and tested under Linux and Windows.</li>
<li>Sources are in the public domain. Use for any purpose.</li>
</ul>
</p>
}
puts {<h2>Current Status</h2>
<p>A <a href="changes.html">Change Summary</a> is available on this
website. You can also access a detailed
<a href="http://cvs.hwaci.com/sqlite/timeline">change history</a>,
<a href="http://cvs.hwaci.com/sqlite/rptview?rn=2">view open bugs</a>,
<a href="http://www.sqlite.org/cvstrac/timeline">change history</a>,
<a href="http://www.sqlite.org/cvstrac/rptview?rn=2">view open bugs</a>,
or
<a href="http://cvs.hwaci.com/sqlite/tktnew">report new bugs</a>
<a href="http://www.sqlite.org/cvstrac/tktnew">report new bugs</a>
at the
<a href="http://cvs.hwaci.com/sqlite/">CVS server</a>.</p>
<a href="http://www.sqlite.org/cvstrac/">CVS server</a>.</p>
<p>Complete source code and precompiled binaries for the latest release are
<a href="download.html">available for download</a> on this site. You
can also obtain the latest changes by anonymous CVS access:
<blockquote><pre>
cvs -d :pserver:anonymous@cvs.hwaci.com:/home/cvs/sqlite login
cvs -d :pserver:anonymous@cvs.hwaci.com:/home/cvs/sqlite checkout sqlite
|
︙ | | |
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
|
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
|
-
+
|
<li>A description of the <a href="opcode.html">virtual machine</a> that
SQLite uses to access the database.</li>
<li>A description of the
<a href="fileformat.html">database file format</a> used by SQLite.
<li>A <a href="speed.html">speed comparison</a> between SQLite, PostgreSQL,
and MySQL.</li>
<li>User-written documentation is available on the
<a href="http://cvs.hwaci.com/sqlite/wiki">SQLite Wiki</a>. Please
<a href="http://www.sqlite.org/cvstrac/wiki">SQLite Wiki</a>. Please
contribute if you can.</li>
</ul>
</p>
<p>The SQLite source code is 30% comment. These comments are
another important source of information. </p>
|
︙ | | |
210
211
212
213
214
215
216
217
218
219
220
221
222
223
|
210
211
212
213
214
215
216
217
218
219
220
221
222
223
|
-
-
+
+
|
<p>
For information bindings of SQLite to other programming languages
(Perl, Python, Ruby, PHP, etc.) and for a list of programs currently
using SQLite, visit the Wiki documentation at:
</p>
<blockquote>
<a href="http://cvs.hwaci.com/sqlite/wiki">
http://cvs.hwaci.com/sqlite/wiki</a>
<a href="http://www.sqlite.org/cvstrac/wiki">
http://www.sqlite.org/cvstrac/wiki</a>
</blockquote>
}
puts {
</body></html>}
|
Changes to www/omitted.tcl.
1
2
3
4
5
6
7
8
9
10
11
|
1
2
3
4
5
6
7
8
9
10
11
|
-
+
|
#
# Run this script to generated a omitted.html output file
#
set rcsid {$Id: omitted.tcl,v 1.4 2003/06/30 10:36:23 drh Exp $}
set rcsid {$Id: omitted.tcl,v 1.5 2003/08/22 02:34:30 drh Exp $}
puts {<html>
<head>
<title>SQL Features That SQLite Does Not Implement</title>
</head>
<body bgcolor="white">
<h1 align="center">
|
︙ | | |
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
|
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
|
-
-
+
+
|
puts {
</table>
<p>
If you find other SQL92 features that SQLite does not support, please
add them to the Wiki page at
<a href="http://cvs.hwaci.com/sqlite/wiki?p=UnsupportedSql">
http://cvs.hwaci.com/sqlite/wiki?p=Unsupported</a>
<a href="http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSql">
http://www.sqlite.org/cvstrac/wiki?p=Unsupported</a>
</p>
<p><hr /></p>
<p><a href="index.html"><img src="/goback.jpg" border=0 />
Back to the SQLite Home Page</a>
</p>
</body></html>}
|