Documentation Source Text

Check-in [4d9a64a055]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Move future downloads into subdirectories to try to stem the growth in the number of files in the root directory of the website.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 4d9a64a055d2097d0e02ea1b909f174c8ead2c03
User & Date: drh 2013-03-02 16:20:51.982
Context
2013-03-02
16:44
Fix a typo in the change log for 3.7.16. Remove forgotten debugging puts in the download.in script. (check-in: bf5c2c74b2 user: drh tags: trunk)
16:20
Move future downloads into subdirectories to try to stem the growth in the number of files in the root directory of the website. (check-in: 4d9a64a055 user: drh tags: trunk)
2013-02-25
15:48
Record the incremental vacuum enhancements in the change-log for 3.7.16. (check-in: 638d9567ad user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/download.in.
1
2
3
4
5
6
7
8
9
10
11

12
13

14


15

16
17
18
19
20
21
22
<title>SQLite Download Page</title>

<h2>SQLite Download Page</h2>
<table width="100%" cellpadding="5">

<tcl>
hd_keywords {download page}
set nDownload 0
proc Product {pattern desc {frag {}}} {
  regsub VVV $pattern {*} p3
  regsub DATE $p3 {20*} p3

  regsub VVV $pattern {(30\d{5})} pattern
  regsub DATE $pattern {(\d{12})} pattern

  set p2 [string map {* .*} $pattern]


  set flist [glob -nocomplain $p3]

  foreach file [lsort -dict $flist] {
    if {![regexp ^$p2\$ $file all version]} continue
    if {[regexp {^(\d\d\d\d)(\d\d)(\d\d)(\d\d)(\d\d)$} $version \
           all year month day hour min]} {
      set version "$year-$month-$day $hour:$min UTC"
    } elseif {[regexp {^30(\d)(\d\d)(\d\d)$} $version \
           all major minor patch]} {











>


>

>
>

>







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
<title>SQLite Download Page</title>

<h2>SQLite Download Page</h2>
<table width="100%" cellpadding="5">

<tcl>
hd_keywords {download page}
set nDownload 0
proc Product {pattern desc {frag {}}} {
  regsub VVV $pattern {*} p3
  regsub DATE $p3 {20*} p3
  regsub YEAR $p3 {20[134][0-9]} p3
  regsub VVV $pattern {(30\d{5})} pattern
  regsub DATE $pattern {(\d{12})} pattern
  regsub YEAR $pattern {\d{4}} pattern
  set p2 [string map {* .*} $pattern]
puts stderr p3=$p3
puts stderr p2=$p2
  set flist [glob -nocomplain $p3]
puts stderr flist=$flist
  foreach file [lsort -dict $flist] {
    if {![regexp ^$p2\$ $file all version]} continue
    if {[regexp {^(\d\d\d\d)(\d\d)(\d\d)(\d\d)(\d\d)$} $version \
           all year month day hour min]} {
      set version "$year-$month-$day $hour:$min UTC"
    } elseif {[regexp {^30(\d)(\d\d)(\d\d)$} $version \
           all major minor patch]} {
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
    }
    hd_puts "<tr><td width=\"10\"></td>"
    hd_puts "<td valign=\"top\" align=\"right\">"
    if {$frag!=""} {
      eval hd_fragment $frag
      set frag {}
    }
    hd_puts "<a href=\"/$file\">$file</a><br>($size $units)</td>\n"
    hd_puts "<td width=\"5\"></td>"
    regsub -all VERSION $desc $version d2
    hd_puts "\n<td valign=\"top\">"
    hd_resolve [string trim $d2]
    hd_puts "<br>(sha1: $sha1sum)</td></tr>\n"
    incr ::nDownload
  }







|







56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
    }
    hd_puts "<tr><td width=\"10\"></td>"
    hd_puts "<td valign=\"top\" align=\"right\">"
    if {$frag!=""} {
      eval hd_fragment $frag
      set frag {}
    }
    hd_puts "<a href=\"$file\">[file tail $file]</a><br>($size $units)</td>\n"
    hd_puts "<td width=\"5\"></td>"
    regsub -all VERSION $desc $version d2
    hd_puts "\n<td valign=\"top\">"
    hd_resolve [string trim $d2]
    hd_puts "<br>(sha1: $sha1sum)</td></tr>\n"
    incr ::nDownload
  }
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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
  set ::pending_tag $tag
  # hd_puts "<tr><td colspan=4><big><b>$title</b></big></td></tr>"
}

Heading {Pre-release Source Code Snapshots}


Product {sqlite-amalgamation-DATE.zip} {
  This is a snapshot (as of VERSION) of the current SQLite code under 
  development.  Use this snapshot for testing only.  This is not a release.
  This ZIP archive contains all preprocessed C code combined into a
  single source file (the [amalgamation]).
}
Product {sqlite-amalgamation32k-DATE.zip} {
  This is a snapshot (as of VERSION) of the current SQLite code under 
  development.  The code is split into a small number of source files,
  such that no single source file is longer than 32767 lines of code.
  Use this snapshot for testing only.  This is not a release.
}
Product {sqlite-tea-DATE.zip} {
  This is a snapshot (as of VERSION) of the current SQLite code under 
  development, packaged and ready to build using the
  <a href="http://www.tcl.tk/doc/tea/">Tcl Extension Architecture (TEA)</a>.
  Use this snapshot for testing only.  This is not a release.
}
Product {sqlite-shell-win32-x86-DATE.zip} {
  This is a snapshot (as of VERSION) build of the 
  <a href="sqlite.html">sqlite3.exe command-line shell</a>
  shell program for 32-bit windows.
}
Product {sqlite-shell-win64-x64-DATE.zip} {
  This is a snapshot (as of VERSION) build of the 
  <a href="sqlite.html">sqlite3.exe command-line shell</a>
  shell program for 64-bit windows.
}


Heading {Source Code}

Product {sqlite-amalgamation-VVV.zip} {
  This ZIP archive contains all C source code for SQLite VERSION
  combined into a
  single source file (the [amalgamation]).
}

Product {sqlite-amalgamation32k-VVV.zip} {
  This ZIP archive contains all C source code for SQLite VERSION
  combined into a small number of source files, where no source file
  is longer than 32767 lines of code.
}

Product {sqlite-autoconf-VVV.tar.gz} {
  A tarball containing the [amalgamation]
  for SQLite VERSION together with an configure script and makefile
  for building it.  This tarball also contains in the "tea" subdirectory
  a separate configure script and makefile compatible with the
  <a href="http://www.tcl.tk/doc/tea/">Tcl Extension
  Architecture (TEA)</a> for building the TCL bindings to SQLite.
} {amalgtarball {amalgamation tarball}}


Product {sqlite-tea-VVV.tar.gz} {
  A tarball of the [amalgamation] together with a
  <a href="http://www.tcl.tk/doc/tea/">Tcl Extension
  Architecture (TEA)</a>
  compatible configure script and makefile.
} {teatarball {TEA tarball}}

Heading {Documentation} docco

Product {sqlite-doc-VVV.zip} {
  This ZIP archive contains most of the static HTML files that
  comprise this website, including all of the SQL Syntax and the
  C/C++ interface specs and other miscellaneous documentation.
}

Heading {Precompiled Binaries for Linux} linux

Product sqlite-shell-linux-x86-VVV.zip {
  A [command-line shell]
  for accessing and modifying SQLite databases.
  This program is compatible with all versions of SQLite through VERSION
  and beyond.
}

Product sqlite-analyzer-linux-x86-VVV.zip {
  An analysis program for database files compatible with all SQLite 
  versions through VERSION and beyond.
}

Heading {Precompiled Binaries for Mac OS X (x86)} mac

Product sqlite-shell-osx-x86-VVV.zip {
  A [command-line shell]
  for accessing and modifying SQLite databases.
  This program is compatible with all versions of SQLite through VERSION
  and beyond.
}

Product sqlite-analyzer-osx-x86-VVV.zip {
  An analysis program for database files compatible with all SQLite 
  versions through VERSION and beyond.
}

Heading {Precompiled Binaries for Windows} win32

set start $nDownload
Product sqlite-shell-win32-x86-VVV.zip {
  A [command-line shell]
  for accessing and modifying SQLite databases.
  This program is compatible with all versions of SQLite through VERSION
  and beyond.
}

Product sqlite-dll-win32-x86-VVV.zip {
  This ZIP archive contains a DLL for the SQLite library version VERSION for
  32-bit x86 processors using the Win32 API.
  The DLL is built using [SQLITE_ENABLE_COLUMN_METADATA] so that it is
  suitable for use with Ruby on Rails.
}

Product sqlite-dll-win32-x64-VVV.zip {
  This ZIP archive contains a DLL for the SQLite library version VERSION for
  64-bit x64 processors using the Win32 API.
}

Product sqlite-analyzer-win32-x86-VVV.zip {
  An analysis program for database files compatible with all SQLite 
  versions through VERSION and beyond.
}

Heading {Precompiled Binaries for Windows Phone 8} wp8


Product sqlite-wp80-winrt-VVV.vsix {
  A complete VSIX package with an extension SDK and all other components
  needed to use SQLite for application development with Visual Studio
  2012 targeting Windows Phone 8.0.
}

Product sqlite-wp80-winrt-DATE.vsix {
  A complete VSIX package with an extension SDK and all other components
  needed to use SQLite for application development with Visual Studio
  2012 targeting Windows Phone 8.0.
  This particular VSIX uses a snapshot of SQLite as of VERSION.
}


Heading {Precompiled Binaries for Windows Runtime} winrt

Product sqlite-dll-winrt-x86-VVV.zip {
  This ZIP archive contains a DLL for the SQLite library version VERSION for
  32-bit x86 processors using the WinRT API.
}

Product sqlite-dll-winrt-x64-VVV.zip {
  This ZIP archive contains a DLL for the SQLite library version VERSION for
  64-bit x64 processors using the WinRT API.
}

Product sqlite-winrt-VVV.vsix {
  A complete VSIX package with an extension SDK and all other components
  needed to use SQLite for WinRT application development with Visual Studio
  2012.
}

if {$nDownload>$start} {
  hd_puts {<tr><td colspan="4"><b>Precompiled Binaries for .NET</b></td></tr>}







|





|





|





|




|








|





|





|









|








|







|






|






|






|







|






|






|




|







|





|









|




|




|







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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
  set ::pending_tag $tag
  # hd_puts "<tr><td colspan=4><big><b>$title</b></big></td></tr>"
}

Heading {Pre-release Source Code Snapshots}


Product {snapshot/sqlite-amalgamation-DATE.zip} {
  This is a snapshot (as of VERSION) of the current SQLite code under 
  development.  Use this snapshot for testing only.  This is not a release.
  This ZIP archive contains all preprocessed C code combined into a
  single source file (the [amalgamation]).
}
Product {snapshot/sqlite-amalgamation32k-DATE.zip} {
  This is a snapshot (as of VERSION) of the current SQLite code under 
  development.  The code is split into a small number of source files,
  such that no single source file is longer than 32767 lines of code.
  Use this snapshot for testing only.  This is not a release.
}
Product {snapshot/sqlite-tea-DATE.zip} {
  This is a snapshot (as of VERSION) of the current SQLite code under 
  development, packaged and ready to build using the
  <a href="http://www.tcl.tk/doc/tea/">Tcl Extension Architecture (TEA)</a>.
  Use this snapshot for testing only.  This is not a release.
}
Product {snapshot/sqlite-shell-win32-x86-DATE.zip} {
  This is a snapshot (as of VERSION) build of the 
  <a href="sqlite.html">sqlite3.exe command-line shell</a>
  shell program for 32-bit windows.
}
Product {snapshot/sqlite-shell-win64-x64-DATE.zip} {
  This is a snapshot (as of VERSION) build of the 
  <a href="sqlite.html">sqlite3.exe command-line shell</a>
  shell program for 64-bit windows.
}


Heading {Source Code}

Product {YEAR/sqlite-amalgamation-VVV.zip} {
  This ZIP archive contains all C source code for SQLite VERSION
  combined into a
  single source file (the [amalgamation]).
}

Product {YEAR/sqlite-amalgamation32k-VVV.zip} {
  This ZIP archive contains all C source code for SQLite VERSION
  combined into a small number of source files, where no source file
  is longer than 32767 lines of code.
}

Product {YEAR/sqlite-autoconf-VVV.tar.gz} {
  A tarball containing the [amalgamation]
  for SQLite VERSION together with an configure script and makefile
  for building it.  This tarball also contains in the "tea" subdirectory
  a separate configure script and makefile compatible with the
  <a href="http://www.tcl.tk/doc/tea/">Tcl Extension
  Architecture (TEA)</a> for building the TCL bindings to SQLite.
} {amalgtarball {amalgamation tarball}}


Product {YEAR/sqlite-tea-VVV.tar.gz} {
  A tarball of the [amalgamation] together with a
  <a href="http://www.tcl.tk/doc/tea/">Tcl Extension
  Architecture (TEA)</a>
  compatible configure script and makefile.
} {teatarball {TEA tarball}}

Heading {Documentation} docco

Product {YEAR/sqlite-doc-VVV.zip} {
  This ZIP archive contains most of the static HTML files that
  comprise this website, including all of the SQL Syntax and the
  C/C++ interface specs and other miscellaneous documentation.
}

Heading {Precompiled Binaries for Linux} linux

Product YEAR/sqlite-shell-linux-x86-VVV.zip {
  A [command-line shell]
  for accessing and modifying SQLite databases.
  This program is compatible with all versions of SQLite through VERSION
  and beyond.
}

Product YEAR/sqlite-analyzer-linux-x86-VVV.zip {
  An analysis program for database files compatible with all SQLite 
  versions through VERSION and beyond.
}

Heading {Precompiled Binaries for Mac OS X (x86)} mac

Product YEAR/sqlite-shell-osx-x86-VVV.zip {
  A [command-line shell]
  for accessing and modifying SQLite databases.
  This program is compatible with all versions of SQLite through VERSION
  and beyond.
}

Product YEAR/sqlite-analyzer-osx-x86-VVV.zip {
  An analysis program for database files compatible with all SQLite 
  versions through VERSION and beyond.
}

Heading {Precompiled Binaries for Windows} win32

set start $nDownload
Product YEAR/sqlite-shell-win32-x86-VVV.zip {
  A [command-line shell]
  for accessing and modifying SQLite databases.
  This program is compatible with all versions of SQLite through VERSION
  and beyond.
}

Product YEAR/sqlite-dll-win32-x86-VVV.zip {
  This ZIP archive contains a DLL for the SQLite library version VERSION for
  32-bit x86 processors using the Win32 API.
  The DLL is built using [SQLITE_ENABLE_COLUMN_METADATA] so that it is
  suitable for use with Ruby on Rails.
}

Product YEAR/sqlite-dll-win32-x64-VVV.zip {
  This ZIP archive contains a DLL for the SQLite library version VERSION for
  64-bit x64 processors using the Win32 API.
}

Product YEAR/sqlite-analyzer-win32-x86-VVV.zip {
  An analysis program for database files compatible with all SQLite 
  versions through VERSION and beyond.
}

Heading {Precompiled Binaries for Windows Phone 8} wp8


Product YEAR/sqlite-wp80-winrt-VVV.vsix {
  A complete VSIX package with an extension SDK and all other components
  needed to use SQLite for application development with Visual Studio
  2012 targeting Windows Phone 8.0.
}

Product YEAR/sqlite-wp80-winrt-DATE.vsix {
  A complete VSIX package with an extension SDK and all other components
  needed to use SQLite for application development with Visual Studio
  2012 targeting Windows Phone 8.0.
  This particular VSIX uses a snapshot of SQLite as of VERSION.
}


Heading {Precompiled Binaries for Windows Runtime} winrt

Product YEAR/sqlite-dll-winrt-x86-VVV.zip {
  This ZIP archive contains a DLL for the SQLite library version VERSION for
  32-bit x86 processors using the WinRT API.
}

Product YEAR/sqlite-dll-winrt-x64-VVV.zip {
  This ZIP archive contains a DLL for the SQLite library version VERSION for
  64-bit x64 processors using the WinRT API.
}

Product YEAR/sqlite-winrt-VVV.vsix {
  A complete VSIX package with an extension SDK and all other components
  needed to use SQLite for WinRT application development with Visual Studio
  2012.
}

if {$nDownload>$start} {
  hd_puts {<tr><td colspan="4"><b>Precompiled Binaries for .NET</b></td></tr>}