Debian Codegraph @

www/news.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="sqlite.css" rel="stylesheet">
6 <title>Recent SQLite News</title>
7 <!-- path= -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="index.html">
12 <img class="logo" src="images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='about.html'>About</a>
23 <li class='desktoponly'><a href="docs.html">Documentation</a>
24 <li class='desktoponly'><a href="download.html">Download</a>
25 <li class='wideonly'><a href='copyright.html'>License</a>
26 <li class='desktoponly'><a href="support.html">Support</a>
27 <li class='desktoponly'><a href="prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='about.html'>About</a>
35 <li><a href='docs.html'>Documentation</a>
36 <li><a href='download.html'>Download</a>
37 <li><a href='support.html'>Support</a>
38 <li><a href='prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118
119
120 <h2>Recent News</h2>
121
122 <a name="2026_06_03"></a><h3>2026-06-03 - <a href="releaselog/3_53_2.html">Version 3.53.2</a></h3><blockquote>
123 SQLite version 3.53.2 is a maintenance patch release
124 for 3.53.
125 </blockquote><hr width="50%"><a name="2026_05_05"></a><h3>2026-05-05 - <a href="releaselog/3_53_1.html">Version 3.53.1</a></h3><blockquote>
126 SQLite version 3.53.1 is a maintenance patch release
127 for 3.53.
128 </blockquote><hr width="50%"><a name="2026_04_09"></a><h3>2026-04-09 - <a href="releaselog/3_53_0.html">Version 3.53.0</a></h3><blockquote>
129 SQLite version 3.53.0 is a re-release of <a href="releaselog/3_52_0.html">version 3.52.0</a> with
130 additional enhancements to address the problem of
131 <a href="staleexpridx.html">stale expression indexes</a>.
132 <p>
133 The <a href="wal.html#walresetbug">WAL-reset bug</a> is fixed in this release. This is the
134 first major release (if you don't count 3.52.0) that contains
135 a fix for that bug, so upgrading is recommended.
136 <p>
137 See the <a href="releaselog/3_53_0.html">version 3.53.0 change log</a> for a
138 list of the many other enhancements included in 3.53.0.
139 </blockquote><hr width="50%"><a name="2026_03_13"></a><h3>2026-03-13 - <a href="releaselog/3_51_3.html">Version 3.51.3</a></h3><blockquote>
140 SQLite version 3.52.0 has been withdrawn because some of
141 the new features found in 3.52.0 are not 100% compatible with
142 prior releases. Those new features and their associated
143 APIs need to be reworked before 3.52 is made available.
144 <p>
145 In place of 3.52.0, patch release 3.51.3 is now available.
146 Patch release 3.51.3 fixes the <a href="wal.html#walresetbug">WAL-reset bug</a> as well as other
147 minor problems that have come to light since the 3.51.2 release.
148 <p>
149 Version 3.52.0 works fine and is fully backwards
150 compatible as long as the database does not contain
151 <a href="expridx.html">indexes on expressions</a> or indexes on
152 <a href="gencol.html">VIRTUAL computed columns</a> where
153 the expression evaluates to a floating-point number that is
154 derived from text or <a href="json1.html#jsonbx">JSONB</a> inputs. If indexes of that type are
155 present, then version 3.52.0 might not interoperate correct
156 with prior releases, in rare cases.
157 </blockquote><hr width="50%"><a name="2026_03_06"></a><h3>2026-03-06 - <a href="releaselog/3_52_0.html">Version 3.52.0</a></h3><blockquote>
158 SQLite version 3.52.0 is a major release with many important
159 changes, the two most important of which (in my opinion) are:
160 <ol>
161 <li> A 15-year-old <a href="wal.html#walresetbug">database corruption bug</a> was
162 discovered just a few days ago, and is now fixed.
163 <li> The <a href="cli.html">command-line interface</a> utility
164 has been significantly enhanced, especially in how it
165 <a href="climode.html">formats query results</a>.
166 </ol>
167 <p>See the <a href="releaselog/3_52_0.html">change log</a> for a more complete list.
168 <p>The previous release was about four months ago.
169 We are <i>striving</i> to slow the release cadence of
170 SQLite to about once every six months. This is not a promise, only
171 a goal. We'll see how it goes.
172 </blockquote><hr width="50%"><a name="2026_01_09"></a><h3>2026-01-09 - <a href="releaselog/3_51_2.html">Version 3.51.2</a></h3><blockquote>
173 Patch release 3.51.2 fixes a potential (but unlikely) deadlock
174 in the OS interface for unix that can arise due to changes in 3.51.0
175 that were designed to detect broken Posix Advisory Locks cause by
176 the application mistakenly directly opening and closing a file
177 descriptor to the database file and not going through the SQLite
178 interface. The patch also fixes some other obscure bugs that are
179 of little importance, but still ought to be addressed. Changes from
180 3.51.0 and 3.51.1 are minimal.
181 </blockquote><hr width="50%"><a name="2025_11_28"></a><h3>2025-11-28 - <a href="releaselog/3_51_1.html">Version 3.51.1</a></h3><blockquote>
182 Patch release 3.51.1 fixes two cases of incorrect answers to
183 corner-case queries caused by new optimizations in version 3.51.0.
184 </blockquote><hr width="50%"><a name="2025_11_04"></a><h3>2025-11-04 - <a href="releaselog/3_51_0.html">Version 3.51.0</a></h3><blockquote>
185 Version 3.51.0 is the first major update to SQLite since the
186 25th anniversary release on 2025-05-29. Version 3.51.0
187 includes new features, new interfaces, and new optimizations.
188 See the <a href="releaselog/3_51_0.html">3.51.0 change log</a> for more detail.
189 </blockquote><hr width="50%"><a name="2025_07_30"></a><h3>2025-07-30 - <a href="releaselog/3_50_4.html">Version 3.50.4</a></h3><blockquote>
190 Version 3.50.4 is a patch release to fix minor problems reported
191 since the previous release.
192 </blockquote><hr width="50%"><a name="2025_07_17"></a><h3>2025-07-17 - <a href="releaselog/3_50_3.html">Version 3.50.3</a></h3><blockquote>
193 Version 3.50.3 is a patch release to fix minor problems reported
194 since the previous release.
195 </blockquote><hr width="50%"><a name="2025_06_28"></a><h3>2025-06-28 - <a href="releaselog/3_50_2.html">Version 3.50.2</a></h3><blockquote>
196 Version 3.50.2 is a patch release to fix minor problems reported
197 since the previous release.
198 </blockquote><hr width="50%"><a name="2025_06_06"></a><h3>2025-06-06 - <a href="releaselog/3_50_1.html">Version 3.50.1</a></h3><blockquote>
199 Version 3.50.1 is a small patch to fix minor problems in the 3.50.0
200 release. Upgrading is recommended.
201 </blockquote><hr width="50%"><a name="2025_05_29"></a><h3>2025-05-29 - <a href="releaselog/3_50_0.html">Version 3.50.0</a></h3><blockquote>
202 Version 3.50.0 is the twenty-fifth anniversity release of SQLite.
203 </blockquote><hr width="50%"><a name="2025_05_07"></a><h3>2025-05-07 - <a href="releaselog/3_49_2.html">Version 3.49.2</a></h3><blockquote>
204 Patch release 3.49.2 fixes various bugs. The most important problem is
205 a mistake in the NOT NULL optimization that was added to version 3.40.0
206 (see item 3c in the <a href="releaselog/3_40_0.html">version 3.40.0 change log</a>) that if
207 abused by an attacker with SQL injection capabilities can lead to read
208 off the end of a static array, resulting in a segfault and possible
209 denial of service. This patch release is mostly to address that one
210 mistake. The other fixes could have waited for the next major release.
211 <p>
212 The 3.50.0 release is still scheduled for 2025-05-29, which is only about
213 three weeks away. All the same bug fixes will be in the 3.50.0 release,
214 so you might want to wait for that release to come up before upgrading.
215 </blockquote><hr width="50%"><a name="2025_02_18"></a><h3>2025-02-18 - <a href="releaselog/3_49_1.html">Version 3.49.1</a></h3><blockquote>
216 Patch release 3.49.1 fixes a problem in the <a href="lang_corefunc.html#concat_ws">concat_ws() SQL function</a>.
217 The problem has existed since version 3.44.0 (2023-11-01) but was
218 only discovered two days ago. The problem is a potential vulnerability.
219 An attacker who can control the separator string and can make that
220 string very large (hundreds of megabytes) could cause a memory error.
221 Your system is not vulnerable if you are following the
222 <a href="security.html">recommended application security practices</a>, especially recommendation
223 number 2, or if your system does not use the concat_ws() function and
224 is impervious to SQL injections. Regardless of whether or not your
225 system is subject to this problem, you will do well to upgrade to version
226 3.49.1 or later.
227 <p>
228 The 3.49.1 patch release also makes multiple improvements to the portability
229 of configure scripts and makefiles. These improvements involve
230 a lot of change, but only to makefiles and configuration scripts. The
231 core SQLite library is unaffected by those enhancements.
232 </blockquote><hr width="50%"><a name="2025_02_06"></a><h3>2025-02-06 - <a href="releaselog/3_49_0.html">Version 3.49.0</a></h3><blockquote>
233 There were a lot of minor patches and bug fixes that needed to be added
234 to the 3.48.0 release. We were originally planning to do a patch release
235 3.48.1 to publish those changes. But we noticed that the patches formed
236 a significant fraction of all changes on the main development trunk, and
237 the trunk was stable, so we decided instead just to
238 do an early release of version 3.49.0.
239 <p>
240 Hence, the 3.49.0 release is being published less than one month after
241 the 3.48.0 release. Version 3.49.0 contains both patches for minor
242 issues in the 3.48.0 release and new enhancements.
243 See the <a href="releaselog/3_49_0.html">change log</a> for details.
244 <p>
245 We expect that the next major release (3.50.0) will resume the usual
246 5-to-7 month cadence.
247 </blockquote><hr width="50%"><a name="2025_01_14"></a><h3>2025-01-14 - <a href="releaselog/3_48_0.html">Version 3.48.0</a></h3><blockquote>
248 Version 3.48.0 refactors the "./configure" system of SQLite to fix bugs,
249 simplify usage, improve performance, and make it easier to maintain moving
250 forward. Though the internal changes are extensive, the user interface
251 should remain the same. Unless you were doing something bizarre and
252 undocumented with ./configure, you should not notice the difference.
253 <p>
254 <b>NB:</b> This change applies to the configure system in the
255 <a href="amalg-v-canon.html#canon">canonical source code</a> only. The amalgamation tarball
256 (the sqlite-autoconf-xxxxxx.tar.gz download) is unaffected.
257 <p>
258 The ./configure implementation has changed to use
259 <a href="https://msteveb.github.io/autosetup/">Autosetup</a> instead of
260 GNU Autoconf. One benefit of this is that TCL is no longer necessary
261 to build SQLite from canonical sources, thus simplifying the build
262 process. Just download the canonical source code, unpack it, and
263 run "./configure && make". No third-party software packages (other
264 than the C compiler and related tools like "make") are needed in
265 most cases. The Windows makefile ("Makefile.msc") also now
266 runs without TCL. Note, however, that TCL is still required to run
267 tests or to build tools such as <a href="sqlanalyze.html">sqlite3_analyzer</a> that link against
268 libtcl.
269 <p>
270 There are other minor enhancements in the 3.48.0 release, but the
271 refactor of the ./configure system is by far the biggest and most
272 important change. See the <a href="releaselog/3_48_0.html">change log</a> for more detail.
273 </blockquote><hr width="50%"><a name="2024_12_07"></a><h3>2024-12-07 - <a href="releaselog/3_47_2.html">Version 3.47.2</a></h3><blockquote>
274 Versions 3.47.0 and 3.47.1 contain a bug in the text-to-floating-point
275 conversion routines such that numbers where the 16
276 most significant digits are "1844674407370955" might be converted to
277 floating point incorrectly on x64 and i386 hardware. This is not an
278 issue on ARM or PPC (the only other CPUs that the SQLite devs have
279 access to), only x64/i386.
280 Version 3.47.2 addresses the problems. You should upgrade to
281 3.47.2 or later if you are using any prior 3.47.x release.
282 </blockquote><hr width="50%"><a name="2024_11_25"></a><h3>2024-11-25 - <a href="releaselog/3_47_1.html">Version 3.47.1</a></h3><blockquote>
283 Version 3.47.1 is a patch release with minimal changes from
284 version 3.47.0. The purpose of the patch is to fix various
285 issues in the 3.47.0 release.
286 </blockquote><hr width="50%"><a name="2024_10_21"></a><h3>2024-10-21 - <a href="releaselog/3_47_0.html">Version 3.47.0</a></h3><blockquote>
287 Version 3.47.0 is an enhancement release with many
288 feature improvements and performance enhancements. Of particular note:
289 <ul>
290 <li> The <a href="rsync.html">sqlite3_rsync</a> command-line utility is now available for
291 doing bandwidth-efficient live backups over SSH.
292 <li> Integration with <a href="https://www.theregister.com/2024/10/02/tcltk_version_9/">TCL9</a>.
293 </ul>
294 <p>
295 See the <a href="releaselog/3_47_0.html">change log</a> for details.
296 </blockquote><hr width="50%"><a name="2024_08_13"></a><h3>2024-08-13 - <a href="releaselog/3_46_1.html">Version 3.46.1</a></h3><blockquote>
297 Version 3.46.1 is a patch release that fixes several minor
298 problems in version 3.46.0. There are minimal changes from
299 the previous release.
300 </blockquote><hr width="50%"><a name="2024_05_23"></a><h3>2024-05-23 - <a href="releaselog/3_46_0.html">Version 3.46.0</a></h3><blockquote>
301 Version 3.46.0 is an enhancement release. Enhancements include:
302 <ul>
303 <li> Improvements to the <a href="pragma.html#pragma_optimize">PRAGMA optimize</a> command
304 <li> Enhancements to the <a href="lang_datefunc.html">date and time functions</a>
305 <li> The ability to put "_" between digits in numeric literals for readability
306 <li> Added the <a href="json1.html#jpretty">json_pretty()</a> function
307 <li> Improvements to the query planner, especially a new faster implementation
308 for VALUES clauses with many terms.
309 </ul>
310 <p>
311 None of these enhancements are critical. Update at your convenience.
312 </blockquote><hr width="50%"><a name="2024_04_15"></a><h3>2024-04-15 - <a href="releaselog/3_45_3.html">Version 3.45.3</a></h3><blockquote>
313 Version 3.45.3 is a patch release that fixes a few obscure problems,
314 including:
315 <ul>
316 <li> The "old.*" values in an <a href="lang_createtrigger.html">UPDATE trigger</a> might be incorrect
317 if the trigger fires in response to an <a href="lang_upsert.html">UPSERT</a>.
318 <li> The <a href="lang_aggfunc.html#sumunc">sum()</a> function might return NULL in some cases where Infinity
319 would be a better answer.
320 </ul>
321 None of the problems are emergencies. Upgrade at your convenience.
322 </blockquote><hr width="50%"><a name="2024_03_12"></a><h3>2024-03-12 - <a href="releaselog/3_45_2.html">Version 3.45.2</a></h3><blockquote>
323 Version 3.45.2 is a patch against SQLite versions 3.45.0 and 3.45.1.
324 <p>
325 The primary reason for this patch is to fix two three-year-old
326 bugs identified by Forum posts
327 <a href="https://sqlite.org/forum/forumpost/919c6579c8">919c6579c8</a>
328 and <a href="https://sqlite.org/forum/forumpost/440f2a2f17">440f2a2f17</a>.
329 These problems could result in incorrect query results or corrupt
330 indexes. See the associated forum threads for details.
331 <p>
332 Other trifling fixes are also included in the patch.
333 </blockquote><hr width="50%"><a name="2024_01_30"></a><h3>2024-01-30 - <a href="releaselog/3_45_1.html">Version 3.45.1</a></h3><blockquote>
334 Version 3.45.1 is a patch against SQLite version 3.45.0.
335 <p>
336 The main focus of this patch release is to restore certain
337 undocumented legacy behavior in the <a href="json1.html">JSON SQL functions</a> that
338 the developers were unaware of but which some applications
339 had come to depend on. This undocumented behavior was "fixed"
340 in the 3.45.0, resulting in breakage for applications that were
341 using it. So it has now been restored and documented.
342 <p>
343 Other obscure issues that have come up since the 3.45.0 release,
344 some related to the release itself and some going back years,
345 are also fixed.
346 </blockquote><hr width="50%"><a name="2024_01_15"></a><h3>2024-01-15 - <a href="releaselog/3_45_0.html">Version 3.45.0</a></h3><blockquote>
347 Version 3.45.0 is an enhancement release of SQLite.
348 <p>
349 The most impactful change is likely enhancements to
350 the <a href="json1.html">JSON SQL functions</a> such that they are now able to
351 store their internal JSON parse trees in the database
352 as BLOB values. This can significantly increase the
353 performance of applications that process large JSON
354 strings as it omits the need to translate JSON text
355 to and from the internal binary format used by SQLite.
356 <p>
357 A second noteworthy change is that any
358 <a href="appfunc.html">application-defined SQL functions</a> that make use of
359 the <a href="c3ref/result_subtype.html">sqlite3_result_subtype()</a> interface must now include
360 the <a href="c3ref/c_deterministic.html#sqliteresultsubtype">SQLITE_RESULT_SUBTYPE</a> attribute when the function
361 is registered using <a href="c3ref/create_function.html">sqlite3_create_function()</a> or similar.
362 Failure to include the SQLITE_RESULT_SUBTYPE attribute on
363 functions that use <a href="c3ref/result_subtype.html">sqlite3_result_subtype()</a> might result
364 in incorrect answers.
365 <p>
366 See the <a href="releaselog/3_45_0.html">change log</a>
367 for additional enhancements that are part of the 3.45.0 release.
368 </blockquote><hr width="50%"><a name="2023_11_24"></a><h3>2023-11-24 - <a href="releaselog/3_44_2.html">Version 3.44.2</a></h3><blockquote>
369 The <a href="cli.html">CLI</a> fix in version 3.44.1 introduced a new bug, which is
370 fixed by patch release 3.44.2. Version 3.44.2 also fixes an
371 FTS5 problem that was found by a fuzzer just minutes after the
372 3.44.1 release.
373 </blockquote><hr width="50%"><a name="2023_11_22"></a><h3>2023-11-22 - <a href="releaselog/3_44_1.html">Version 3.44.1</a></h3><blockquote>
374 Version 3.44.1 is a patch release that fixes various obscure
375 bugs. There is no need to upgrade, unless you are having
376 problems with a prior release.
377 </blockquote><hr width="50%"><a name="2023_11_01"></a><h3>2023-11-01 - <a href="releaselog/3_44_0.html">Version 3.44.0</a></h3><blockquote>
378 Version 3.44.0 is a new enhancement release of SQLite.
379 <p>
380 It has only been 69 days since the previous major
381 release (3.43.0). The original plan was for version 3.44.0
382 to occur at a spacing of approximately 120 days from the
383 prior release. However, the code accumulated so many important
384 enhancements that it seemed better to accelerate the release
385 of 3.44.0, thus getting those enhancements into circulation.
386 This means that some enhancements that were originally
387 planned to be in 3.44.0 have been deferred until subsequent
388 releases.
389 </blockquote><hr width="50%"><a name="2023_10_10"></a><h3>2023-10-10 - <a href="releaselog/3_43_2.html">Version 3.43.2</a></h3><blockquote>
390 Version 3.43.2 is a patch release that fixes a few small inaccuracies in
391 version 3.43.0 and 3.43.1.
392 </blockquote><hr width="50%"><a name="2023_09_11"></a><h3>2023-09-11 - <a href="releaselog/3_43_1.html">Version 3.43.1</a></h3><blockquote>
393 Version 3.43.1 is a patch release that fixes a few small inaccuracies that were
394 discovered in the the 3.43.0 and/or 3.42.0 releases after the 3.43.0 release was
395 published.
396 </blockquote><hr width="50%"><a name="2023_08_24"></a><h3>2023-08-24 - <a href="releaselog/3_43_0.html">Version 3.43.0</a></h3><blockquote>
397 Version 3.43.0 is a routine enhancement release of SQLite.
398 Key enhancements in this release include added support for
399 <a href="fts5.html#clssdeltab">Contentless-Delete FTS5 Indexes</a>,
400 and performance improvements in <a href="json1.html">JSON processing</a>.
401 See the <a href="releaselog/3_43_0.html">change log</a> for
402 details.
403 </blockquote><hr width="50%"><a name="2023_05_16"></a><h3>2023-05-16 - <a href="releaselog/3_42_0.html">Version 3.42.0</a></h3><blockquote>
404 Version 3.42.0 is a routine enhancement release of SQLite.
405 Key enhancements in this release are added support for
406 <a href="json1.html#json5">JSON5</a> and the <a href="fts5.html#the_secure_delete_configuration_option">FTS5 secure-delete command</a>. See the
407 <a href="releaselog/3_42_0.html">change log</a> for a
408 summary of all enhancements in this release.
409 </blockquote><hr width="50%"><a name="2023_03_22"></a><h3>2023-03-22 - <a href="releaselog/3_41_2.html">Version 3.41.2</a></h3><blockquote>
410 Version 3.41.2 is a patch release that fixes multiple
411 fuzzer-found problems in prior releases. The worst problems
412 include reads (not writes) past the end of a buffer. Upgrading
413 is recommended.
414 </blockquote><hr width="50%"><a name="2023_03_10"></a><h3>2023-03-10 - <a href="releaselog/3_41_1.html">Version 3.41.1</a></h3><blockquote>
415 Version 3.41.1 is a patch release that fixes various obscure
416 problems found in 3.41.0 and reported by users. Upgrading
417 is optional.
418 </blockquote><hr width="50%"><a name="2023_02_21"></a><h3>2023-02-21 - <a href="releaselog/3_41_0.html">Version 3.41.0</a></h3><blockquote>
419 Version 3.41.0 is a routine enhancement release.
420 </blockquote><hr width="50%"><a name="2022_12_28"></a><h3>2022-12-28 - <a href="releaselog/3_40_1.html">Version 3.40.1</a></h3><blockquote>
421 Version 3.40.1 is a patch release that fixes some obscure problems
422 in version 3.40.0. The problems fixed have no impact on most applications.
423 Upgrading is only necessary if you encounter problems.
424 <p>
425 The two most important fixes are these:
426 <ul>
427 <li><p>
428 Fix the <a href="cli.html#safemode">safe command-line option</a> on the <a href="cli.html">CLI</a> so that it
429 correctly disallows functions with side-effects. This is a bug
430 in the CLI &mdash; <i>not</i> a bug in the
431 SQLite library &mdash; and it only affects the --safe command-line
432 option, making that option less than fully "safe". As the number
433 of systems that use the --safe command-line option in the CLI is
434 approximately zero, this is not considered an important bug. However,
435 a third-party wrote a CVE against it which caused considerable angst
436 among maintainers, so it seems good to get the fix into circulation
437 sooner rather than wait on the next major release.
438 <li><p>
439 The optional <a href="malloc.html#memsys5">memsys5</a> memory allocator picked up a bug that might
440 put it into an infinite loop for very large (500MiB) allocations.
441 Almost all systems use their native memory allocator, not memsys5.
442 Memsys5 is only used if SQLite is compiled using SQLITE_ENABLE_MEMSYS5
443 and then initialized using <a href="c3ref/config.html">sqlite3_config</a>(<a href="c3ref/c_config_covering_index_scan.html#sqliteconfigheap">SQLITE_CONFIG_HEAP</a>).
444 Very, very few systems do this, and so the problem is not considered
445 to be serious.
446 </ul>
447 <p>
448 See the <a href="https://sqlite.org/src/timeline?r=branch-3.40">branch-3.40 timeline</a>
449 for a complete listing of changes that have gone into this patch release.
450 </blockquote><hr width="50%"><a name="2022_11_16"></a><h3>2022-11-16 - <a href="releaselog/3_40_0.html">Version 3.40.0</a></h3><blockquote>
451 Version 3.40.0 is a new feature release of SQLite. See the
452 <a href="releaselog/3_40_0.html">change log</a> for details.
453 Key enhancements in this release include:
454 <ol>
455 <li><p>
456 Official support for compiling
457 <a href="https://sqlite.org/wasm/doc/trunk/index.md">SQLite to WASM</a>
458 and running it in a web browser.
459 <li><p>
460 New and improved <a href="recovery.html">recovery extension</a> for extracting
461 data from corrupted database files.
462 </ol>
463 <p>
464 This release also includes performance enhancements and
465 improvements to the query planner.
466 <p>
467 A psychological milestone: The performance benchmark that
468 the SQLite developers have used for many years has for
469 the first time dropped below 1 billion CPU cycles
470 (measured using cachegrind) when run in <a href="wal.html">WAL mode</a>.
471 This is less than half the number of CPU cycles used as
472 recently as 8 years ago. (The graph below shows SQLite using
473 a <a href="lockingv3.html#rollback">rollback journal</a> which uses fewer CPU cycles at the expense
474 of extra I/O. The benchmark passed through the 1 billion cycle
475 barrier for rollback journals for the previous release.)
476 <p align="center">
477 <img src="images/sschart20221116.jpg" align="center" style="margin:1px solid grey;"></img>
478 </p>
479 </blockquote><hr width="50%"><a name="2022_09_29"></a><h3>2022-09-29 - <a href="releaselog/3_39_4.html">Version 3.39.4</a></h3><blockquote>
480 Version 3.39.4 is a security release that addresses a single
481 long-standing problem in the <a href="fts3.html">FTS3 extension</a>. An attacker
482 who is able to execute arbitrary SQL statements and who can create
483 a corrupt database that is 2GB or larger in size might be able to trick
484 FTS3 into overflowing an integer used to size a memory allocation,
485 causing the allocation to be too small and ultimately resulting in
486 a buffer overrun. The release also includes fixes for other
487 obscure weaknesses, as described in the release notes.
488 </blockquote><hr width="50%"><a name="2022_09_05"></a><h3>2022-09-05 - <a href="releaselog/3_39_3.html">Version 3.39.3</a></h3><blockquote>
489 Version 3.39.3 is a patch release that fixes a few obscure problems
490 in the 3.39.0 release. See the release notes for details.
491 </blockquote><hr width="50%"><a name="2022_07_21"></a><h3>2022-07-21 - <a href="releaselog/3_39_2.html">Version 3.39.2</a></h3><blockquote>
492 Version 3.39.2 is a security release that addresses multiple long-standing
493 issues in SQLite. The most severe problem is identified by CVE-2022-35737.
494 That issue is associated with the auxiliary C-language APIs
495 of SQLite and cannot be reached using SQL or database inputs, and hence is
496 unlikely to affect your application. Nevertheless, upgrading is recommended.
497 The other issues are comparatively minor.
498 This release also fixes a performance regression that appeared in version
499 3.39.0 that might affect some multi-way joins that use LEFT JOIN.
500 </blockquote><hr width="50%"><a name="2022_07_13"></a><h3>2022-07-13 - <a href="releaselog/3_39_1.html">Version 3.39.1</a></h3><blockquote>
501 Version 3.39.1 is a patch release that fixes a few minor problems in version
502 3.39.0. Upgrading is optional.
503 </blockquote><hr width="50%"><a name="2022_06_25"></a><h3>2022-06-25 - <a href="releaselog/3_39_0.html">Version 3.39.0</a></h3><blockquote>
504 Version 3.39.0 is a regular maintenance release of SQLite. The key enhancement
505 in this release is added support for RIGHT and FULL JOIN. There are other
506 language and performance enhancements as well &mdash; see the
507 <a href="releaselog/3_39_0.html">release notes</a> for details.
508 </blockquote><hr width="50%"><a name="2022_05_06"></a><h3>2022-05-06 - <a href="releaselog/3_38_5.html">Version 3.38.5</a></h3><blockquote>
509 The 3.38.4 patch release included a minor change to the <a href="cli.html">CLI</a> source code
510 that did not work. The release manager only ran a subset of the normal
511 release tests, and hence did not catch the problem. As a result, the CLI
512 will segfault when using columnar output modes in version 3.38.4. This
513 blunder did not affect the core SQLite library. It only affected the CLI.
514 <p>
515 Take-away lesson: <b>Always</b> run <b>all</b> of your tests prior to
516 a release - even a trival patch release. <b>Always</b>.
517 <p>
518 The 3.38.5 patch release fixes the 3.38.4 blunder.
519 </blockquote><hr width="50%"><a name="2022_05_04"></a><h3>2022-05-04 - <a href="releaselog/3_38_4.html">Version 3.38.4</a></h3><blockquote>
520 Another user-discovered problem in the new Bloom filter optimization
521 is fixed in this patch release. Without the fix, it is possible for
522 a multi-way join that uses Bloom filters for two or more tables in
523 the join to enter an infinite loop if the key constraint on one of those
524 tables contains a NULL value.
525 </blockquote><hr width="50%"><a name="2022_04_27"></a><h3>2022-04-27 - <a href="releaselog/3_38_3.html">Version 3.38.3</a></h3><blockquote>
526 Version 3.38.3 fixes a bug in the automatic-index and Bloom filter
527 construction logic that might cause SQLite to be overly aggressive
528 in the use of ON clause constraints, resulting in an incorrect
529 automatic-index or Bloom filter that excludes some valid rows from
530 output. The bug was introduced in version 3.38.0. Other minor
531 changes were tossed in to complete the patch.
532 </blockquote><hr width="50%"><a name="2022_03_26"></a><h3>2022-03-26 - <a href="releaselog/3_38_2.html">Version 3.38.2</a></h3><blockquote>
533 Version 3.38.2 fixes another bug in the new Bloom filter
534 optimization that might cause incorrect answers for a
535 LEFT JOIN that has an IS NULL constraint on the right-hand
536 table.
537 </blockquote><hr width="50%"><a name="2022_03_12"></a><h3>2022-03-12 - <a href="releaselog/3_38_1.html">Version 3.38.1</a></h3><blockquote>
538 Version 3.38.1 fixes a pair of bugs in the Bloom filter
539 optimization that was introduced in version 3.38.0. These
540 bugs might cause incorrect answers for some obscure queries.
541 Various other minor problems and documentation typos were
542 fixed at the same time.
543 </blockquote><hr width="50%"><a name="2022_02_22"></a><h3>2022-02-22 - <a href="releaselog/3_38_0.html">Version 3.38.0</a></h3><blockquote>
544 Version 3.38.0 is a routine maintenance release of
545 SQLite. There are various minor enhancements and
546 about a 0.5% reduction in the number of CPU cycles
547 used. See the
548 <a href="releaselog/3_38_0.html">release notes</a> for
549 more detail.
550 </blockquote><hr width="50%"><a name="2022_01_06"></a><h3>2022-01-06 - <a href="releaselog/3_37_2.html">Version 3.37.2</a></h3><blockquote>
551 Version 3.37.2 fixes a
552 <a href="howtocorrupt.html#svptbug">database corruption bug</a>. You are
553 encouraged to upgrade, especially if you are using <a href="lang_savepoint.html">SAVEPOINT</a>.</p>
554
555 <p>The problem first appeared in version 3.35.0 (2021-03-12) and
556 affects all subsequent releases through 3.37.1.
557 If temporary files are stored in memory (which is not the default
558 behavior, but is sometimes selected by applications using either
559 <a href="compile.html#temp_store">-DSQLITE_TEMP_STORE</a> or <a href="pragma.html#pragma_temp_store">PRAGMA temp_store</a>) and
560 if a <a href="lang_savepoint.html">SAVEPOINT</a> is rolled back and then subsequent changes
561 within the same transaction are committed, the database file might
562 (with low but non-zero probability) go corrupt.
563 </blockquote><hr width="50%"><a name="2021_12_30"></a><h3>2021-12-30 - <a href="releaselog/3_37_1.html">Version 3.37.1</a></h3><blockquote>
564 Version 3.37.1 fixes a bug in the <a href="lang_upsert.html">UPSERT</a> logic, introduced by
565 the UPSERT enhancements of <a href="releaselog/3_35_0.html">version 3.35.0</a>, that can cause
566 incorrect byte-code to be generated in some cases, resulting
567 in an infinite loop in the byte code, or a NULL-pointer dereference.
568 This patch release also fixes some other minor problems with
569 assert() statements and in the <a href="cli.html">CLI</a>.
570 </blockquote><hr width="50%"><a name="2021_11_27"></a><h3>2021-11-27 - <a href="releaselog/3_37_0.html">Version 3.37.0</a></h3><blockquote>
571 Version 3.37.0 is a routine maintenance release of SQLite.
572 The biggest new feature in this release is support for
573 <a href="stricttables.html">STRICT tables</a>. Other enhancements are described in
574 the <a href="releaselog/3_37_0.html">release notes</a>.
575 </blockquote><hr width="50%"><a name="2021_06_18"></a><h3>2021-06-18 - <a href="releaselog/3_36_0.html">Version 3.36.0</a></h3><blockquote>
576 Version 3.36.0 is a routine maintenance release of SQLite.
577 There are no new major features, only incremental improvements
578 to existing features and small performance improvements.
579 </blockquote><hr width="50%"><a name="2021_04_19"></a><h3>2021-04-19 - Patch release 3.35.5</h3><blockquote>
580 The new ALTER TABLE DROP COLUMN capability that was added
581 in the 3.35.0 release contained a bug that might cause the
582 table content to go corrupt when the table was rewritten
583 to remove the dropped column. Fixed by this patch.
584 </blockquote><hr width="50%"><a name="2021_04_02"></a><h3>2021-04-02 - Patch release 3.35.4</h3><blockquote>
585 Version 3.35.4 is yet another patch release to fix
586 obscure problems in features associated with the 3.35.0 release.
587 </blockquote><hr width="50%"><a name="2021_03_26"></a><h3>2021-03-26 - Patch release 3.35.3</h3><blockquote>
588 Version 3.35.3 contains patches for a handful of minor
589 problems discovered in prior releases.
590 </blockquote><hr width="50%"><a name="2021_03_17"></a><h3>2021-03-17 - Patch release 3.35.2</h3><blockquote>
591 Version 3.35.2 is a small patch release to fix some minor problems
592 that were discovered shortly after the 3.35.1 release.
593 </blockquote><hr width="50%"><a name="2021_03_15"></a><h3>2021-03-15 - Patch release 3.35.1</h3><blockquote>
594 A user discovered an issue with the new DROP COLUMN capability
595 in version 3.35.0, and so version 3.35.1 was created to fix it.
596 No need to upgrade if you are not using DROP COLUMN.
597 </blockquote><hr width="50%"><a name="2021_03_12"></a><h3>2021-03-12 - Release 3.35.0</h3><blockquote>
598 SQLite version 3.35.0 is a routine maintenance release. This
599 release adds a number of new language features, including
600 support for ALTER TABLE DROP COLUMN, built-in math functions,
601 generalized UPSERT, and the MATERIALIZED hint on common table
602 expressions. There are also query planner optimizations and
603 incremental CLI improvements.
604 </blockquote><hr width="50%"><a name="2020_01_20"></a><h3>2020-01-20 - Release 3.34.1</h3><blockquote>
605 SQLite version 3.34.1 is a patch release that fixes a possible
606 use-after-free bug that can be provoked by malicious SQL. Other
607 minor issues in extensions and documentation are also fixed.
608 </blockquote><hr width="50%"><a name="2020_12_01"></a><h3>2020-12-01 - Release 3.34.0</h3><blockquote>
609 SQLite version 3.34.0 is a routine maintenance release. This
610 release adds incremental improvements to performance and features,
611 including enhancements to the query planner, multiple recursive
612 SELECTS in recursive common table expressions, and better error messages
613 from CHECK constraint failures. See the change log for details.
614 </blockquote><hr width="50%"><a name="2020_08_14"></a><h3>2020-08-14 - Release 3.33.0</h3><blockquote>
615 SQLite version 3.33.0 is a routine maintenance release. This
616 release features added support for "UPDATE FROM" following the
617 PostgreSQL syntax, and a doubling of the maximum database size
618 to 281 TB, as well as many other improvements. See the change
619 log for details.
620 </blockquote><hr width="50%"><a name="2020_06_18"></a><h3>2020-06-18 - Release 3.32.3</h3><blockquote>
621 The 3.32.3 release is a patch release that contains fixes for
622 various issues discovered by fuzzers. None of the issues fixed
623 are likely to be encountered by applications that use SQLite in
624 ordinary ways, though upgrading never hurts.
625 <p>
626 Map of all changes since the 3.32.0 release:
627 <a href="https://sqlite.org/src/timeline?p=version-3.32.3&bt=version-3.32.0">https://sqlite.org/src/timeline?p=version-3.32.3&bt=version-3.32.0</a>
628 </blockquote><hr width="50%"><a name="2020_06_04"></a><h3>2020-06-04 - Release 3.32.2</h3><blockquote>
629 The 3.32.2 release is a one-line change relative to 3.32.1
630 that fixes a long-standing bug in the COMMIT command. Since
631 <a href="releaselog/3_17_0.html">version 3.17.0</a>, if you were to retry a COMMIT command over
632 and over after it returns <a href="rescode.html#busy">SQLITE_BUSY</a>, it might eventually
633 report success, even though it was still blocked. This patch
634 fixes the problem.
635 </blockquote><hr width="50%"><a name="2020_05_25"></a><h3>2020-05-25 - Release 3.32.1</h3><blockquote>
636 <a href="https://en.wikipedia.org/wiki/Grey_hat">Grey-hats</a> published
637 information about two SQLite bugs approximately 24 hours after
638 the release of version 3.32.0. These bugs enable maliciously
639 crafted SQL to crash the process that is running SQLite. Both
640 bugs are long-standing problems that affect releases prior to
641 3.32.0. The 3.32.1 release fixes both problems.
642 </blockquote><hr width="50%"><a name="2020_05_22"></a><h3>2020-05-22 - Release 3.32.0</h3><blockquote>
643 Version 3.32.0 is an ordinary maintenance release of SQLite.
644 This release features the ability to run an
645 <a href="lang_analyze.html#approx">approximate ANALYZE</a> to gather database statistics for
646 use by the query planner, without having to scan every row
647 of every index.
648 See the <a href="releaselog/3_32_0.html">change log</a> for additional enhancements
649 and improvements.
650 </blockquote><hr width="50%"><a name="2020_01_27"></a><h3>2020-01-27 - Release 3.31.1</h3><blockquote>
651 Applications that use SQLite should only interface with SQLite
652 through the officially published APIs. Applications should not
653 depend upon or use the internal data structures of SQLite as those
654 structures might change from one release to another. However, there
655 is a popular application that does depend on the details of the
656 internal layout of data in an internal SQLite data structure, and
657 those details changed in version 3.31.0, breaking the application.
658 This is, technically, a bug in the application, not in SQLite.
659 But it is within the power of SQLite to fix it, by reverting the
660 internal data structure change, and so that is what we have done
661 for the 3.31.1 release.
662 </blockquote><hr width="50%"><a name="2020_01_22"></a><h3>2020-01-22 - Release 3.31.0</h3><blockquote>
663 Version 3.31.0 is an ordinary maintenance release of SQLite.
664 This release features the ability to define
665 <a href="gencol.html">generated columns</a> for tables as well as many other enhancements.
666 See the <a href="releaselog/3_31_0.html">change log</a> for additional information.
667 </blockquote><hr width="50%"><a name="2019_10_11"></a><h3>2019-10-11 - Release 3.30.1</h3><blockquote>
668 Version 3.30.1 is a bug-fix release that addresses a problem
669 that can occur when an aggregate function in a nested query
670 makes use of the new FILTER clause capability. Some additional
671 patches for various obscure issues are also included, for
672 completeness.
673 </blockquote><hr width="50%"><a name="2019_10_04"></a><h3>2019-10-04 - Release 3.30.0</h3><blockquote>
674 Version 3.30.0 is a regularly scheduled maintenance release
675 of SQLite containing miscellaneous performance and feature
676 enhancements. This release adds support fo the NULLS FIRST
677 and NULLS LAST clauses on ORDER BY statements and the
678 addition of FILTER clauses on all aggregate functions.
679 See the <a href="releaselog/3_30_0.html">change log</a> for details.
680 </blockquote><hr width="50%"><a name="2019_07_10"></a><h3>2019-07-10 - Release 3.29.0</h3><blockquote>
681 Version 3.29.0 is a regularly scheduled maintenance release
682 of SQLite containing miscellaneous performance and feature
683 enhancements. See the <a href="releaselog/3_29_0.html">change log</a> for
684 details.
685 <p>
686 Beginning with this release, the
687 <a href="quirks.html#dblquote">double-quoted string literal</a> misfeature is deprecated.
688 The misfeature is still enabled by default, for legacy
689 compatibility, however developers are encouraged to
690 disable it at compile-time using the
691 <a href="compile.html#dqs">-DSQLITE_DQS=0</a> option, or at run-time using
692 the <a href="c3ref/c_dbconfig_defensive.html#sqlitedbconfigdqsdml">SQLITE_DBCONFIG_DQS_DML</a> and <a href="c3ref/c_dbconfig_defensive.html#sqlitedbconfigdqsddl">SQLITE_DBCONFIG_DQS_DDL</a>
693 actions to the <a href="c3ref/db_config.html">sqlite3_db_config()</a> interface. This is
694 especially true for double-quoted string literals in
695 CREATE TABLE and CREATE INDEX statements, as those elements
696 can cause unexpected problems following an ALTER TABLE.
697 See ticket <a href="https://sqlite.org/src/info/9b78184be266fd70">9b78184be266fd70</a>
698 for an example.
699 </blockquote><hr width="50%"><a name="2019_04_16"></a><h3>2019-04-16 - Release 3.28.0</h3><blockquote>
700 Version 3.28.0 is a regularly scheduled maintenance release
701 of SQLite containing miscellaneous performance and feature
702 enhancements. See the <a href="releaselog/3_28_0.html">change log</a> for
703 details.
704 <p>
705 This release fixes an obscure security issue. Applications
706 using older versions of SQLite may be vulnerable if
707 <ol>
708 <li> SQLite is compiled with certain optional extensions
709 enabled, and
710 <li> the attacker is able to inject arbitrary SQL.
711 </ol>
712 We are not aware of any applications that are vulnerable to
713 this problem. On the other hand, we do not know about
714 every application that uses SQLite.
715 If your application allows unauthenticated users on the internet
716 (and hence potential attackers) to run arbitrary SQL and if
717 you build SQLite with any of the optional extensions enabled,
718 then you should take this upgrade at your earliest opportunity.
719 <p>
720 For further information about improving SQLite's robustness
721 in internet-facing applications, see the our
722 <a href="security.html">security recommendations</a>.
723 </blockquote><hr width="50%"><a name="2019_02_25"></a><h3>2019-02-25 - Release 3.27.2</h3><blockquote>
724 Version 3.27.2 is a patch release that
725 fixes two bugs and various documentation
726 errors found in the version 3.27.1. The
727 changes from version 3.27.1 and 3.27.0 are
728 minimal.
729 </blockquote><hr width="50%"><a name="2019_02_08"></a><h3>2019-02-08 - Release 3.27.1</h3><blockquote>
730 After release 3.27.0 was tagged, but before the build could
731 be completed and uploaded, a
732 <a href="https://sqlite.org/src/info/4e8e4857d32d401f">long-standing bug</a>
733 in the query optimizer was reported via System.Data.SQLite.
734 Since people will be upgrading anyhow, we decided to
735 publish the fix for this newly discovered problem right
736 away. Hence, 3.27.1 was released less than 24 hours after
737 3.27.0.
738 <p>
739 It would have been better if the query optimizer bug had come to
740 our attention one day earlier, so that we could have incorporated
741 a fix into 3.27.0, but sometimes that's the way things go.
742 </blockquote><hr width="50%"><a name="2019_02_07"></a><h3>2019-02-07 - Release 3.27.0</h3><blockquote>
743 SQLite <a href="releaselog/3_27_0.html">version 3.27.0</a> is a routine maintenance release with various
744 performance and feature enhancements. See the
745 <a href="releaselog/3_27_0.html">release notes</a> for details.
746 </blockquote><hr width="50%"><a name="2018_12_01"></a><h3>2018-12-01 - Release 3.26.0</h3><blockquote>
747 SQLite <a href="releaselog/3_26_0.html">version 3.26.0</a> is a routine maintenance release with various
748 performance and feature enhancements. See the
749 <a href="releaselog/3_26_0.html">release notes</a> for details.
750 </blockquote><hr width="50%"><a name="2018_11_05"></a><h3>2018-11-05 - Release 3.25.3</h3><blockquote>
751 SQLite <a href="releaselog/3_25_3.html">version 3.25.3</a> is a third patch against 3.25.0 that fixes various
752 problems that have come to light and which seem serious enough to
753 justify a patch.
754 </blockquote><hr width="50%"><a name="2018_09_25"></a><h3>2018-09-25 - Release 3.25.2</h3><blockquote>
755 SQLite <a href="releaselog/3_25_2.html">version 3.25.2</a> is another patch against 3.25.0 that fixes still
756 more problems associated with the new <a href="windowfunctions.html">window function</a> feature and the
757 <a href="lang_altertable.html">ALTER TABLE</a> enhancements. Of particular note is the new
758 <a href="pragma.html#pragma_legacy_alter_table">PRAGMA legacy_alter_table=ON</a> command, which causes the ALTER TABLE RENAME
759 command to behave in the same goofy way that it did before the enhancements
760 found in version 3.25.0 &rarr; references to renamed tables that are inside
761 the bodies of triggers and views are not updated. The legacy behavior is
762 arguably a bug, but some programs depend on the older buggy behavior. The
763 3.25.2 release also contains a fix to <a href="windowfunctions.html">window function</a> processing for
764 VIEWs. There also a slew of other minor fixes that affect obscure
765 compile-time options. See the
766 <a href="https://sqlite.org/src/timeline?r=branch-3.25">Fossil Timeline</a> for
767 details.
768 </blockquote><hr width="50%"><a name="2018_09_18"></a><h3>2018-09-18 - Release 3.25.1</h3><blockquote>
769 SQLite <a href="releaselog/3_25_1.html">version 3.25.1</a> is a patch against version 3.25.0 that contains
770 two one-line fixes for bug that were introduced in version 3.25.0.
771 See the change log for details. Upgrading from 3.25.0 is recommended.
772 </blockquote><hr width="50%"><a name="2018_09_15"></a><h3>2018-09-15 - Release 3.25.0</h3><blockquote>
773 SQLite <a href="releaselog/3_25_0.html">version 3.25.0</a> is a regularly scheduled maintenance release.
774 Two big enhancements in this release:
775 <ol>
776 <li><p>
777 Support for <a href="windowfunctions.html">window functions</a> was added, using the PostgreSQL documentation
778 as the baseline.
779 <li><p>
780 The <a href="lang_altertable.html">ALTER TABLE</a> command was enhanced to support renaming of columns, and
781 so that column and table renames are propagated into trigger bodies and views.
782 </ol>
783 <p>In addition, there are various performance enhancements and minor fixes.
784 <p>One bug of note is
785 <a href="https://sqlite.org/src/info/9936b2fa443fec03ff25">ticket 9936b2fa443fec</a>
786 which describes a hard-to-reach condition where the ORDER BY LIMIT
787 optimization might cause an infinite loop during query evaluation.
788 This ticket raised a lot of
789 concern on
790 <a href="https://news.ycombinator.com/item?id=17964243">HackerNews</a> and
791 <a href="https://www.reddit.com/r/programming/comments/9ezy8c/serious_bug_causing_infinite_loop_in_some_queries/">Reddit</a>,
792 probably due to my choice of the ticket
793 title. "Infinite Loop" sounds scary. But I argue that the bug isn't really
794 all that bad in that it is very difficult to reach, will show up during
795 testing (rather than magically appearing after a product is
796 deployed), does not cause any data loss, and does not return an
797 incorrect result. It was an important error, but not nearly as dire
798 as many people interpreted it to be. And, in any event, it is fixed now.
799 </blockquote><hr width="50%"><a name="2018_06_04"></a><h3>2018-06-04 - Release 3.24.0</h3><blockquote>
800 SQLite <a href="releaselog/3_24_0.html">version 3.24.0</a> is a regularly scheduled maintenance release.
801 Highlights of this release include support for PostgreSQL-style
802 UPSERT and improved performance, especially for ORDER BY LIMIT queries.
803 </blockquote><hr width="50%"><a name="2018_04_10"></a><h3>2018-04-10 - Release 3.23.1</h3><blockquote>
804 The <a href="releaselog/3_23_1.html">version 3.23.1</a> release fixes a bug in the new
805 <a href="optoverview.html#leftjoinreduction">LEFT JOIN strength reduction optimization</a> added to version 3.23.0.
806 A few other minor and obscure fixes were also inserted, as well as
807 a small performance optimization. Code changes relative to
808 version 3.23.0 are minimal.
809 </blockquote><hr width="50%"><a name="2018_04_02"></a><h3>2018-04-02 - Release 3.23.0</h3><blockquote>
810 The <a href="releaselog/3_23_0.html">version 3.23.0</a> release is a regularly scheduled maintenance release.
811 See the <a href="releaselog/3_23_0.html">change log</a> for a list of enhancements and bug
812 fixes.
813 </blockquote><hr width="50%"><a name="2018_01_22"></a><h3>2018-01-22 - Release 3.22.0</h3><blockquote>
814 The <a href="releaselog/3_22_0.html">version 3.22.0</a> release is a regularly scheduled maintenance release.
815 There are many minor, though interesting, enhancements in this release.
816 See the <a href="releaselog/3_22_0.html">change log</a> for details.
817 </blockquote><hr width="50%"><a name="2017_10_24"></a><h3>2017-10-24 - Release 3.21.0</h3><blockquote>
818 The <a href="releaselog/3_21_0.html">version 3.21.0</a> release is a regularly scheduled maintenance release.
819 There are lots of enhancements in this release.
820 See the <a href="releaselog/3_21_0.html">change log</a> for details.
821 </blockquote><hr width="50%"><a name="2017_08_24"></a><h3>2017-08-24 - Release 3.20.1</h3><blockquote>
822 The <a href="releaselog/3_20_1.html">version 3.20.1</a> patch release changes two lines of code in
823 the <a href="c3ref/result_blob.html">sqlite3_result_pointer()</a> interface in order to fix a rare
824 memory leak. There are no other changes relative to <a href="releaselog/3_20_0.html">version 3.20.0</a>.
825 </blockquote><hr width="50%"><a name="2017_08_01"></a><h3>2017-08-01 - Release 3.20.0</h3><blockquote>
826 SQLite <a href="releaselog/3_20_0.html">version 3.20.0</a> is a regularly scheduled maintenance release
827 of SQLite.
828 <p>
829 This release contains many minor enhancements, including:
830 <ul>
831 <li> Several new extensions
832 <li> Enhancements to the "sqlite3.exe" command-line shell
833 <li> Query planner enhancements
834 <li> Miscellaneous code optimizations for improved performance
835 <li> Fixes for some obscure bugs
836 </ul>
837 <p>
838 See the <a href="releaselog/3_20_0.html">release notes</a> for more information.
839 </blockquote><hr width="50%"><a name="2017_06_17"></a><h3>2017-06-17 - Release 3.18.2</h3><blockquote>
840 SQLite <a href="releaselog/3_18_2.html">version 3.18.2</a> is another backport of a bug fix found
841 in SQLite <a href="releaselog/3_19_0.html">version 3.19.0</a>, specifically the fix for
842 ticket <a href="https://sqlite.org/src/info/61fe9745">61fe9745</a>. Changes
843 against <a href="releaselog/3_18_0.html">version 3.18.0</a> are minimal.
844 </blockquote><hr width="50%"><a name="2017_06_16"></a><h3>2017-06-16 - Release 3.18.1</h3><blockquote>
845 SQLite <a href="releaselog/3_18_1.html">version 3.18.1</a> is a bug-fix release against <a href="releaselog/3_18_0.html">version 3.18.0</a>
846 that fixes the <a href="pragma.html#pragma_auto_vacuum">auto_vacuum</a> corruption bug described in ticket
847 <a href="https://sqlite.org/src/info/fda22108">fda22108</a>. This release was
848 created for users who need that bug fix but do not yet want to upgrade
849 to <a href="releaselog/3_19_3.html">version 3.19.3</a>.
850 </blockquote><hr width="50%"><a name="2017_06_08"></a><h3>2017-06-08 - Release 3.19.3</h3><blockquote>
851 <a href="releaselog/3_19_3.html">Version 3.19.3</a> is an emergency patch release to fix a
852 <a href="https://sqlite.org/src/info/fda22108">bug</a> in
853 <a href="pragma.html#pragma_auto_vacuum">auto_vacuum</a> logic that can lead to database corruption.
854 The bug was introduced in <a href="releaselog/3_16_0.html">version 3.16.0</a>
855 (2017-01-02). Though the bug is obscure and rarely
856 encountered, upgrading is recommended for all users, and
857 especially for users who turn on <a href="pragma.html#pragma_auto_vacuum">auto_vacuum</a>.
858 </blockquote><hr width="50%"><a name="2017_05_25"></a><h3>2017-05-25 - Release 3.19.2</h3><blockquote>
859 Still more problems have been found in the LEFT JOIN
860 <a href="https://sqlite.org/optoverview.html#flattening">flattening</a> optimization
861 that was added in the 3.19.0 release. This patch release fixes all known
862 issues with that optimization and adds new test cases. Hopefully this
863 will be the last patch.
864 </blockquote><hr width="50%"><a name="2017_05_24"></a><h3>2017-05-24 - Release 3.19.1</h3><blockquote>
865 One of the new query planner optimizations in the 3.19.0 release contained
866 bugs. The 3.19.1 patch release fixes them.
867 <p>
868 Beginning with 3.19.0, subqueries and views on the right-hand side of
869 a LEFT JOIN operator could sometimes be
870 <a href="https://sqlite.org/optoverview.html#flattening">flattened</a> into the
871 main query. The new optimization worked well for all of the test cases
872 that the developers devised, and for millions of legacy test cases, but
873 once 3.19.0 was released, users found some other cases where the optimization
874 failed. Ticket
875 <a href="https://sqlite.org/src/info/cad1ab4cb7b0fc344">cad1ab4cb7b0fc344</a> contains
876 examples.
877 <p>
878 These problems exist only in 3.19.0. Users of SQLite 3.19.0 should
879 upgrade, but users of all prior versions of SQLite are safe.
880 </blockquote><hr width="50%"><a name="2017_05_22"></a><h3>2017-05-22 - Release 3.19.0</h3><blockquote>
881 SQLite <a href="releaselog/3_19_0.html">version 3.19.0</a> is a regularly scheduled maintenance release.
882 <p>
883 The emphasis on this release is improvements to the query planner.
884 There are also some obscure bug fixes. There is no reason to upgrade
885 unless you are having problems with a prior release.
886 </blockquote><hr width="50%"><a name="2017_03_30"></a><h3>2017-03-30 - Release 3.18.0</h3><blockquote>
887 SQLite <a href="releaselog/3_18_0.html">version 3.18.0</a> is a regularly scheduled maintenance release.
888 <p>
889 This release features an initial implementation the
890 "<a href="pragma.html#pragma_optimize">PRAGMA optimize</a>" command. This command can now be used to cause
891 <a href="lang_analyze.html">ANALYZE</a> to be run on an as-needed basis. Applications should invoke
892 "PRAGMA optimize" just before closing the <a href="c3ref/sqlite3.html">database connection</a>.
893 The "PRAGMA optimize" statement will likely be enhanced to do other
894 kinds of automated database maintenance in future releases.
895 <p>
896 The <a href="https://www.fossil-scm.org/">Fossil</a> version control system that is
897 used to manage the SQLite project has been upgraded to use SHA3-256 hashes
898 instead of SHA1. Therefore, the version identifications for SQLite now
899 show a 64-hex-digit SHA3-256 hash rather than the 40-hex-digit SHA1 hash.
900 <p>
901 See the <a href="releaselog/3_18_0.html">change log</a> for other enhancements and optimizations
902 in this release.
903 </blockquote><hr width="50%"><a name="2017_02_13"></a><h3>2017-02-13 - Release 3.17.0</h3><blockquote>
904 SQLite <a href="releaselog/3_17_0.html">version 3.17.0</a> is a regularly scheduled maintenance release.
905 <p>
906 Most of the changes in this release are performance optimizations.
907 Optimizations to the <a href="rtree.html">R-Tree extension</a> are especially noticeable.
908 <p>
909 In this release, the default size of the
910 <a href="malloc.html#lookaside">lookaside buffer</a> allocated for each database connection
911 is increased from 64,000 to 120,000 bytes. This provides improved
912 performance on many common workloads in exchange for a small increase
913 in memory usage.
914 Applications that value a small memory footprint over raw speed
915 can change the lookaside buffer size back to its old value (or to zero)
916 using the <a href="compile.html#default_lookaside">SQLITE_DEFAULT_LOOKASIDE</a> compile-time option, or the
917 <a href="c3ref/c_config_covering_index_scan.html#sqliteconfiglookaside">sqlite3_config(SQLITE_CONFIG_LOOKASIDE)</a>
918 start-time setting, or the
919 <a href="c3ref/c_dbconfig_defensive.html#sqlitedbconfiglookaside">sqlite3_db_config(SQLITE_DBCONFIG_LOOKASIDE)</a>
920 run-time setting.
921 </blockquote><hr width="50%"><a name="2017_01_06"></a><h3>2017-01-06 - Release 3.16.2</h3><blockquote>
922 One of the performance optimizations added in 3.16.0 caused triggers
923 and foreign keys to malfunction for the <a href="lang_replace.html">REPLACE</a> statement on
924 <a href="withoutrowid.html">WITHOUT ROWID</a> tables that lack secondary indexes. This patch
925 release fixes the problem. See ticket
926 <a href="https://sqlite.org/src/info/30027b613b4">30027b613b4</a> for details.
927 </blockquote><hr width="50%"><a name="2017_01_03"></a><h3>2017-01-03 - Release 3.16.1</h3><blockquote>
928 SQLite <a href="releaselog/3_16_1.html">version 3.16.1</a> fixes a bug in the row-value logic for UPDATE
929 statements inside of triggers. The bug has been there since row-values
930 were added by release 3.15.0, but was not discovered until just a few
931 minutes after the 3.16.0 release was published, and so it was not fixed
932 by 3.16.0. This patch release is version 3.16.0 with the row-value bug fix.
933 </blockquote><hr width="50%"><a name="2017_01_02"></a><h3>2017-01-02 - Release 3.16.0</h3><blockquote>
934 SQLite <a href="releaselog/3_16_0.html">version 3.16.0</a> is a regularly scheduled maintenance release.</p>
935
936 <p><p>
937 This release includes many <a href="cpu.html#microopt">microoptimizations</a> that collectively reduce
938 the CPU cycle count by about 9%,
939 add there have been important enhancements to the <a href="cli.html">command-line shell</a>.</p>
940
941 <p><p>Support for <a href="pragma.html#pragfunc">PRAGMA functions</a> is added,
942 so that many pragma statements can be used as part of a larger SQL query.
943 This is considered an experimental feature.
944 We do not anticipate any changes to the <a href="pragma.html#pragfunc">PRAGMA function</a> interface, but
945 will keep continuing to call this interface "experimental" for a few release
946 cycles in case unforeseen issues arise.</p>
947
948 <p><p>See the <a href="releaselog/3_16_0.html">change log</a> for other enhancements.
949 </blockquote><hr width="50%"><a name="2016_11_28"></a><h3>2016-11-28 - Release 3.15.2</h3><blockquote>
950 SQLite <a href="releaselog/3_15_2.html">version 3.15.2</a> is a bug-fix patch release that fixes several minor
951 issues in the 3.15.0 and 3.15.1 releases.
952 </blockquote><hr width="50%"><a name="2016_11_04"></a><h3>2016-11-04 - Release 3.15.1</h3><blockquote>
953 SQLite <a href="releaselog/3_15_1.html">version 3.15.1</a> is a bug-fix patch release that fixes some minor
954 issues in the 3.15.0 release.
955 </blockquote><hr width="50%"><a name="2016_10_14"></a><h3>2016-10-14 - Release 3.15.0</h3><blockquote>
956 SQLite <a href="releaselog/3_15_0.html">version 3.15.0</a> is a regularly scheduled maintenance release.
957 The key feature in this release is the added support for
958 <a href="rowvalue.html">row values</a>. There are also other enhancements and
959 fixes for a number of obscure bugs.
960 <p>
961 The 3.15.0 release uses about 7% fewer CPU cycles than 3.14.2.
962 Most of the improvement in this release
963 is in the SQL parser, query planner, and
964 byte-code generator (the front-end) corresponding
965 to the <a href="c3ref/prepare.html">sqlite3_prepare_v2()</a> interface. Overall,
966 version 3.15.0 uses about half as much CPU time as
967 version 3.8.1 (2013-10-17). These
968 performance measurements are made using the "speedtest1.c"
969 workload on x64 compiled with gcc and -Os. Performance
970 improvements may vary with different platforms and
971 workloads.
972 </blockquote><hr width="50%"><a name="2016_09_12"></a><h3>2016-09-12 - Release 3.14.2</h3><blockquote>
973 SQLite <a href="releaselog/3_14_2.html">version 3.14.2</a> fixes several obscure bugs and adds
974 improved support for building SQLite using the STDCALL calling
975 convention on 32-bit windows systems. Upgrading from versions
976 3.14 and 3.14.1 is optional.
977 </blockquote><hr width="50%"><a name="2016_08_11"></a><h3>2016-08-11 - Release 3.14.1</h3><blockquote>
978 SQLite <a href="releaselog/3_14_1.html">version 3.14.1</a> adds a small patch to improve the performance
979 of the pcache1TruncateUnsafe() routine for cases when the only a few
980 pages on the end of the cache are being removed. This causes COMMITs
981 to run faster when there is a very large page cache. Upgrading from
982 version 3.14 is optional.
983 </blockquote><hr width="50%"><a name="2016_08_08"></a><h3>2016-08-08 - Release 3.14</h3><blockquote>
984 SQLite <a href="releaselog/3_14.html">version 3.14</a> (the "&#960;" release)
985 is a regularly scheduled maintenance
986 release containing performance enhancements, new features, and fixes for
987 obscure bugs.
988 </blockquote><hr width="50%"><a name="2016_05_18"></a><h3>2016-05-18 - Release 3.13.0</h3><blockquote>
989 SQLite <a href="releaselog/3_13_0.html">version 3.13.0</a> is a regularly scheduled maintenance release containing
990 performance enhancements and fixes for obscure bugs.
991 </blockquote><hr width="50%"><a name="2016_04_18"></a><h3>2016-04-18 - Release 3.12.2</h3><blockquote>
992 <p>Yikes! The 3.12.0 and 3.12.1 releases contain a backwards compatibility bug!
993 Tables that declare a column with type <tt>"INTEGER" PRIMARY KEY</tt>
994 (where the datatype name INTEGER is quoted) generate an incompatible
995 database file. The mistake came about because the developers have never
996 thought to put a typename in quotes before, and so there was no documentation
997 of that capability nor any tests. (There are tests now, though, of course.)
998 Instances of quoting the datatype name are probably infrequent in the wild,
999 so we do not expect the impact of this bug to be too severe.
1000 Upgrading is still strongly recommended.
1001 <p>Fixes for three other minor issues were included in this patch release.
1002 The other issues would have normally been deferred until the next scheduled
1003 release, but since a patch release is being issued anyhow, they might as
1004 well be included.
1005 </blockquote><hr width="50%"><a name="2016_04_08"></a><h3>2016-04-08 - Release 3.12.1</h3><blockquote>
1006 <p>SQLite <a href="releaselog/3_12_1.html">version 3.12.1</a> is an emergency patch release to address a
1007 <a href="https://sqlite.org/src/info/7f7f8026eda38">crash bug</a> that snuck
1008 into <a href="releaselog/3_12_0.html">version 3.12.0</a>. Upgrading from version 3.12.0 is highly
1009 recommended.
1010 <p>Another minor problem involving datatypes on <a href="lang_createview.html">view</a> columns, and
1011 a query planner deficiency are fixed at the same time. These two
1012 issues did not justify a new release on their own, but since a release
1013 is being issued to deal with the crash bug, we included these other
1014 fixes for good measure.
1015 </blockquote><hr width="50%"><a name="2016_03_29"></a><h3>2016-03-29 - Release 3.12.0</h3><blockquote>
1016 <p>SQLite <a href="releaselog/3_12_0.html">version 3.12.0</a> is a regularly scheduled maintenance release.
1017 A notable change in this release is an
1018 <a href="pgszchng2016.html">increase in the default page size</a> for newly created database files.
1019 There are also various performance improvements.
1020 See the <a href="releaselog/3_12_0.html">change log</a> for details.
1021 </blockquote><hr width="50%"><a name="2016_03_03"></a><h3>2016-03-03 - Release 3.11.1</h3><blockquote>
1022 <p>SQLite <a href="releaselog/3_11_1.html">version 3.11.1</a> is a patch release that fixes problems in the
1023 new <a href="fts5.html">FTS5</a> extension and increases a default setting in the <a href="spellfix1.html">spellfix1</a>
1024 extension, and implements enhancements to some of the Windows makefiles.
1025 The SQLite core is unchanged from 3.11.0. Upgrading is optional.
1026 </blockquote><hr width="50%"><a name="2016_02_15"></a><h3>2016-02-15 - Release 3.11.0</h3><blockquote>
1027 <p>SQLite <a href="releaselog/3_11_0.html">version 3.11.0</a> is a regularly scheduled maintenance release.
1028 </blockquote><hr width="50%"><a name="2016_01_20"></a><h3>2016-01-20 - Release 3.10.2</h3><blockquote>
1029 <p>Yikes! An optimization attempt gone bad resulted in a
1030 <a href="https://sqlite.org/src/info/80369eddd5c94">bug in the LIKE operator</a>
1031 which is fixed by this patch release.
1032 Three other minor but low-risk fixes are also included in the patch.
1033 </blockquote><hr width="50%"><a name="2016_01_14"></a><h3>2016-01-14 - Release 3.10.1</h3><blockquote>
1034 <p>SQLite <a href="releaselog/3_10_1.html">version 3.10.1</a> is a bug-fix release primarily targeting the
1035 fix for the query planner bug
1036 <a href="https://sqlite.org/src/info/cb3aa0641d9a4">cb3aa0641d9a4</a> discovered by
1037 Mapscape. Also included is a minor API enhancement requested by
1038 the Firefox developers at Mozilla. The differences from version
1039 3.10.0 are minimal.
1040 </blockquote><hr width="50%"><a name="2016_01_06"></a><h3>2016-01-06 - Release 3.10.0</h3><blockquote>
1041 <p>SQLite <a href="releaselog/3_10_0.html">version 3.10.0</a> is a regularly scheduled maintenance release.
1042 </blockquote><hr width="50%">
1043
1044 <a href="oldnews.html">Old news...</a>
1045 <p align="center"><small><i>This page was last updated on 2026-06-03 19:15:00Z </small></i></p>
1046