Debian Codegraph @

www/releaselog/3_53_0.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>SQLite Release 3.53.0 On 2026-04-09</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 <h2>SQLite Release 3.53.0 On 2026-04-09</h2><p><ol class='lessindent'>
119 <li> Fix the <a href="../wal.html#walresetbug">WAL-reset database corruption bug</a>.
120 <li> Add the <a href="https://sqlite.org/src/file/ext/qrf">Query Result Formatter (QRF)</a>
121 library for formatting the results of SQL queries for human readability
122 on a fixed-pitch font screen.
123 <ol type="a">
124 <li> Add the <a href="../tclsqlite.html#format">format method</a> to the <a href="../tclsqlite.html">TCL Interface</a> so that QRF is
125 accessible from TCL.
126 <li> QRF is used for result formatting in the <a href="../cli.html">CLI</a>, resulting in improved
127 display capabilities.
128 </ol>
129 <li> New SQL language features:
130 <ol type="a">
131 <li> Enhance <a href="../lang_altertable.html">ALTER TABLE</a> to permit adding and removing NOT NULL
132 and CHECK constraints.
133 <li> The <a href="../lang_reindex.html">REINDEX EXPRESSIONS</a> statement rebuilds expression indexes.
134 (Useful to repair <a href="../staleexpridx.html">stale expression indexes</a>.)
135 <li> The body of <a href="../lang_createtrigger.html#temptrig">TEMP triggers</a> may now modify and/or query tables in
136 the main schema.
137 <li> Enhance <a href="../lang_vacuum.html#vacuuminto">VACUUM INTO</a> so that if a <a href="../uri.html">URI filename</a> is used as the
138 target and that filename has a reserve=N query parameter with N
139 between 0 and 255, then the <a href="../fileformat2.html#resbyte">reserve amount</a> for
140 the generated database copy is set to N.
141 </ol>
142 <li> New SQL functions:
143 <ol type="a">
144 <li> <a href="../json1.html#jarrayins">json_array_insert()</a>
145 <li> <a href="../json1.html#jarrayins">jsonb_array_insert()</a>
146 </ol>
147 <li> Renovations to the <a href="../cli.html">CLI</a>:
148 <ol type="a">
149 <li> Major enhancements to the <a href="../climode.html">.mode command</a>.
150 <li> Improved result formatting, due to the addition of the
151 <a href="https://sqlite.org/src/file/ext/qrf">QRF extension</a>.
152 For example, numeric values are now right-justified by default
153 in <a href="../climode.html#clmnr">tabular output modes</a>.
154 <li> The default output mode for interactive CLI sessions now uses
155 QRF to display query results in boxes formed using Unicode
156 box-drawing characters, for improved legibility. Batch CLI
157 sessions use the legacy output format for compatibility.
158 <li> Bare (unquoted) semicolons at the end of <a href="../cli.html#dotcmd">dot-commands</a> are
159 silently ignored. &emsp;&larr;&nbsp;Potential incompatibility!
160 <li> Fix the .testcase and .check commands so that they actually
161 work, and use those commands in scripts that are part of
162 the standard SQLite test suite included with the source tree.
163 <li> Command-line arguments that match *.sql or *.txt and are
164 the names of non-empty files are read and interpreted as scripts
165 of SQL statements and/or <a href="../cli.html#dotcmd">dot-commands</a>.
166 <li> The argument to the ".timer" command can now be "once", to run
167 the timer on only the next SQL statement.
168 <li> The new "--timeout S" option to the ".progress" dot-command
169 causes SQL statements to interrupt after S seconds.
170 <li> The ".indexes" command was changed so that the PATTERN argument
171 matches the name of the index, not the name of the table
172 being indexed (thus making the PATTERN argument actually useful).
173 And, several new options were added to ".indexes".
174 </ol>
175 <li> New C-language interfaces:
176 <ol type="a">
177 <li> <a href="../c3ref/str_append.html">sqlite3_str_truncate()</a>
178 <li> <a href="../c3ref/str_finish.html">sqlite3_str_free()</a>
179 <li> <a href="../c3ref/carray_bind.html">sqlite3_carray_bind_v2()</a>
180 <li> Add the <a href="../c3ref/c_prepare_dont_log.html#sqlitepreparefromddl">SQLITE_PREPARE_FROM_DDL</a> option to <a href="../c3ref/prepare.html">sqlite3_prepare_v3()</a> which
181 permits <a href="../vtab.html">virtual table</a> implementations to safely prepare SQL statements
182 that are derived from the database schema.
183 <li> Added the <a href="../c3ref/c_any.html#sqliteutf8zt">SQLITE_UTF8_ZT</a> constant which can be used as the encoding parameter to
184 <a href="../c3ref/result_blob.html">sqlite3_result_text64()</a> or <a href="../c3ref/bind_blob.html">sqlite3_bind_text64()</a> to indicate that the value
185 is UTF-8 encoded and zero terminated.
186 <li> The <a href="../c3ref/c_limit_attached.html#sqlitelimitparserdepth">SQLITE_LIMIT_PARSER_DEPTH</a> option is added to <a href="../c3ref/limit.html">sqlite3_limit()</a>.
187 <li> The <a href="../c3ref/c_dbconfig_defensive.html#sqlitedbconfigfpdigits">SQLITE_DBCONFIG_FP_DIGITS</a> option is added to <a href="../c3ref/db_config.html">sqlite3_db_config()</a>.
188 See also item 9b below.
189 </ol>
190 <li> Query planner improvements:
191 <ol type="a">
192 <li> Always use a sort-and-merge algorithm for EXCEPT, INTERSECT, and
193 UNION, since this is almost always faster than using a hash table.
194 <li> Improvements to join order selection in large multi-way joins on
195 a star schema.
196 <li> Enhance the EXISTS-to-JOIN optimization so that the inserted JOIN
197 terms are not required to be on the inner-most loops, as long as
198 all dependencies for the EXISTS-to-JOIN loops are in outer loops.
199 <li> Enhance the omit-noop-join optimization so that it is able to omit
200 a chain of joins that do not affect the output.
201 <li> Allow queries that use "GROUP BY e1 ORDER BY e2" where e1 and e2
202 are identical apart from ASC/DESC sort-orders to be optimized using
203 a single index.
204 <li> Allow virtual tables to optimize DISTINCT in cases where the
205 result-set of a query does not exactly match the ORDER BY clause.
206 </ol>
207 <li> Add new interfaces to the <a href="../sessionintro.html">session extension</a>
208 that enable an application to add changes one at
209 a time to the sqlite3_changegroup object:
210 <ol type="a">
211 <li> <a href="../session/sqlite3changegroup_change_begin.html">sqlite3changegroup_change_begin()</a>
212 <li> <a href="../session/sqlite3changegroup_change_blob.html">sqlite3changegroup_change_blob()</a>
213 <li> <a href="../session/sqlite3changegroup_change_double.html">sqlite3changegroup_change_double()</a>
214 <li> <a href="../session/sqlite3changegroup_change_int64.html">sqlite3changegroup_change_int64()</a>
215 <li> <a href="../session/sqlite3changegroup_change_null.html">sqlite3changegroup_change_null()</a>
216 <li> <a href="../session/sqlite3changegroup_change_text.html">sqlite3changegroup_change_text()</a>
217 <li> <a href="../session/sqlite3changegroup_change_finish.html">sqlite3changegroup_change_finish()</a>
218 <li> <a href="../session/sqlite3changegroup_config.html">sqlite3changegroup_config()</a>
219 </ol>
220 <li> Improvements to floating-point &harr; text conversions.
221 <ol type="a">
222 <li> Reimplemented to improve performance.
223 <li> Rounding is now done by <a href="../floatingpoint.html#*fpdigits">default to 17 significant digits</a>,
224 instead of 15, as was the case for all prior versions.
225 The <a href="../c3ref/db_config.html">sqlite3_db_config</a>(<a href="../c3ref/c_dbconfig_defensive.html#sqlitedbconfigfpdigits">SQLITE_DBCONFIG_FP_DIGITS</a>) API (item 6g above)
226 can change this, if desired.
227 </ol>
228 <li> Added the <a href="../staleexpridx.html#selfheal">self-healing index</a> feature to deal with the
229 <a href="../staleexpridx.html">stale expression index</a> problem.
230 <li> Add the "-p|--port" option to <a href="../rsync.html">sqlite3_rsync</a>.
231 <li> Discontinue support for <a href="https://en.wikipedia.org/wiki/Windows_RT">Windows RT</a>.
232 <li> JavaScript/WASM
233 <ol type="a">
234 <li> Add the "opfs-wl" VFS, functionally identical to the "opfs" VFS but
235 using Web Locks for locking, which can promise fairer lock sharing
236 than the "opfs" bespoke protocol can. "opfs-wl" requires
237 <code>Atomics.waitAsync()</code>, so requires newer browsers than "opfs"
238 does.
239 </ol>
240 </li>
241 <p><b>Hashes:</b>
242 <li>SQLITE_SOURCE_ID: 2026-04-09 11:41:38 4525003a53a7fc63ca75c59b22c79608659ca12f0131f52c18637f829977f20b
243 <li>SHA3-256 for sqlite3.c: bb317fbbd2b3bc53233ddd5894bf4d2dc6f533445f350d4235dbcc86f65af4ec
244
245 </ol></p>
246
247 <p>A <a href="../changes.html">complete list of SQLite releases</a>
248 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
249 A detailed history of every
250 check-in is available at
251 <a href="https://sqlite.org/src/timeline">
252 SQLite version control site</a>.</p>
253
254