Debian Codegraph @

www/releaselog/3_51_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.51.0 On 2025-11-04</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.51.0 On 2025-11-04</h2><p><ol class='lessindent'>
119 <li> New macros in <tt>sqlite3.h</tt>:
120 <ol type="a">
121 <li> <tt>SQLITE_SCM_BRANCH</tt> &rarr; the name of the branch from which the source code is taken.
122 <li> <tt>SQLITE_SCM_TAGS</tt> &rarr; space-separated list of tags on the source code check-in.
123 <li> <tt>SQLITE_SCM_DATETIME</tt> &rarr; ISO-8601 date and time of the source code check-in.
124 </ol>
125 <li>Two new JSON functions, <a href="../json1.html#jbeach">jsonb_each()</a> and <a href="../json1.html#jbtree">jsonb_tree()</a> work the same as the existing
126 json_each() and json_tree() functions except that they return <a href="../json1.html#jsonbx">JSONB</a> for the "value" column
127 when the "type" is 'array' or 'object'.
128 <li>The <a href="../carray.html">carray</a> and <a href="../percentile.html">percentile</a> extensions are now built
129 into <a href="../amalgamation.html">the amalgamation</a>, though they are disabled by default and must be activated
130 at compile-time using the
131 <a href="../compile.html#enable_carray">-DSQLITE_ENABLE_CARRAY</a> and/or <a href="../compile.html#enable_percentile">-DSQLITE_ENABLE_PERCENTILE</a> options, respectively.
132 <li>Enhancements to <a href="../tclsqlite.html">TCL Interface</a>:
133 <ol type="a">
134 <li> Add the <code>-asdict</code> flag to the <code>eval</code> command
135 to have it set the row data as a dict instead of an array.
136 <li> User-defined functions may now <code>break</code> to return an
137 SQL NULL.
138 </ol>
139 <li><a href="../cli.html">CLI</a> enhancements:
140 <ol type="a">
141 <li> Increase the precision of ".timer" to microseconds.
142 <li> Enhance the "box" and "column" formatting modes to deal
143 with double-wide characters.
144 <li> The ".imposter" command provides read-only <a href="../imposter.html">imposter tables</a>
145 that work with <a href="../lang_vacuum.html">VACUUM</a> and do not require the --unsafe-testing
146 option.
147 <li> Add the --ifexists option to the CLI command-line option and to
148 the <a href="../cli.html#dotopen">.open command</a>.
149 <li> Limit columns widths set by the ".width" command to 30,000 or less,
150 as there is not good reason to have wider columns, but supporting
151 wider columns provides opportunity to malefactors.
152 </ol>
153 <li>Performance enhancements:
154 <ol type="a">
155 <li> Use fewer CPU cycles to commit a read transaction.
156 <li> Early detection of joins that return no rows due to one or more
157 of the tables containing no rows.
158 <li> Avoid evaluation of scalar subqueries if the result of the subquery
159 does not change the result of the overall expression.
160 <li> Faster window function queries when using
161 "<tt>BETWEEN :x FOLLOWING AND :y FOLLOWING</tt>" with a large :y.
162 </ol>
163 <li>Add the <a href="../pragma.html#pragma_wal_checkpoint">PRAGMA wal_checkpoint=NOOP;</a> command and the
164 <a href="../c3ref/c_checkpoint_full.html">SQLITE_CHECKPOINT_NOOP</a> argument for <a href="../c3ref/wal_checkpoint_v2.html">sqlite3_wal_checkpoint_v2()</a>.
165 <li>Add the <a href="../c3ref/set_errmsg.html">sqlite3_set_errmsg()</a> API for use by extensions.
166 <li>Add the <a href="../c3ref/db_status.html">sqlite3_db_status64()</a> API, which works just like the existing
167 <a href="../c3ref/db_status.html">sqlite3_db_status()</a> API except that it returns 64-bit results.
168 <li>Add the <a href="../c3ref/c_dbstatus_options.html">SQLITE_DBSTATUS_TEMPBUF_SPILL</a> option to the <a href="../c3ref/db_status.html">sqlite3_db_status()</a>
169 and <a href="../c3ref/db_status.html">sqlite3_db_status64()</a> interfaces.
170 <li>In the <a href="../sessionintro.html">session extension</a> add the <a href="../session/sqlite3changeset_apply.html">sqlite3changeset_apply_v3()</a> interface.
171 <li>For the <a href="../printf.html">built-in printf()</a> and the <a href="../lang_corefunc.html#format">format() SQL function</a>,
172 omit the leading '-' from negative floating point numbers if the
173 '+' flag is omitted and the "#" flag is present and all displayed digits are '0'.
174 Use '%#f' or similar to avoid outputs like '-0.00' and instead show just '0.00'.
175 <li>Improved error messages generated by <a href="../fts5.html">FTS5</a>.
176 <li>Enforce STRICT typing on computed columns.
177 <li>Improved support for VxWorks
178 <li> JavaScript/WASM now supports 64-bit WASM. The canonical builds continue to be
179 32-bit but creating one's own 64-bit build is now as simple
180 as running "make".
181 <li>Improved resistance to database corruption caused by an application
182 <a href="../howtocorrupt.html#posix_close_bug">breaking Posix advisory locks using close()</a>.
183 <p><b>Hashes:</b>
184 <li>SQLITE_SOURCE_ID: 2025-11-04 19:38:17 fb2c931ae597f8d00a37574ff67aeed3eced4e5547f9120744ae4bfa8e74527b
185 <li>SHA3-256 for sqlite3.c: e2add951748f73587cadd1b2684defb4f39fa58dca14b16162d4237e50af9afa
186
187 </ol></p>
188
189 <p>A <a href="../changes.html">complete list of SQLite releases</a>
190 in a single page and a <a href="../chronology.html">chronology</a> are both also available.
191 A detailed history of every
192 check-in is available at
193 <a href="https://sqlite.org/src/timeline">
194 SQLite version control site</a>.</p>
195
196