Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Updates to talk about the auto-explain changes to the shell. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
5a67b7f1784a00ce8d8b80e8728ed061 |
User & Date: | drh 2016-02-09 22:53:55.323 |
Context
2016-02-10
| ||
03:48 | Merge typo fixes from the 3.10 branch. (check-in: f26e661484 user: drh tags: trunk) | |
2016-02-09
| ||
22:53 | Updates to talk about the auto-explain changes to the shell. (check-in: 5a67b7f178 user: drh tags: trunk) | |
14:46 | Merge enhancements from the 3.10.0 branch. (check-in: 35017ac57c user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 | for better durability. The [SQLITE_EXTRA_DURABLE] compile-time option enables [PRAGMA synchronous=EXTRA] by default. <li>Enhanced the [query planner] so that it is able to use a [covering index] as part of the [OR optimization]. <li>Many micro-optimizations, resulting in a library that is both smaller and faster than the previous release. <p><b>Enhancements to the [command-line shell]:</b> <li>Added the ".vfslist" [dot-commands|dot-command]. <p><b>Enhancements to the [TCL Interface]:</b> <li>If a database connection is opened with the "-uri 1" option, then [URI filenames] are honored by the "backup" and "restore" commands. <li>Added the "-sourceid" option to the "sqlite3" command. <p><b>Makefile improvements:</b> <li>Improved pthreads detection in configure scripts. <li>Add the ability to do MSVC Windows builds from the [amalgamation tarball]. | > > > > | 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 | for better durability. The [SQLITE_EXTRA_DURABLE] compile-time option enables [PRAGMA synchronous=EXTRA] by default. <li>Enhanced the [query planner] so that it is able to use a [covering index] as part of the [OR optimization]. <li>Many micro-optimizations, resulting in a library that is both smaller and faster than the previous release. <p><b>Enhancements to the [command-line shell]:</b> <li>By default, the shell is now in "auto-explain" mode. The output of [EXPLAIN] commands is automatically formatted. <li>Added the ".vfslist" [dot-commands|dot-command]. <li>The [SQLITE_ENABLE_EXPLAIN_COMMENTS] compile-time option is now turned on by default in the standard builds. <p><b>Enhancements to the [TCL Interface]:</b> <li>If a database connection is opened with the "-uri 1" option, then [URI filenames] are honored by the "backup" and "restore" commands. <li>Added the "-sourceid" option to the "sqlite3" command. <p><b>Makefile improvements:</b> <li>Improved pthreads detection in configure scripts. <li>Add the ability to do MSVC Windows builds from the [amalgamation tarball]. |
︙ | ︙ |
Changes to pages/cli.in.
︙ | ︙ | |||
148 149 150 151 152 153 154 | .dbinfo ?DB? Show status information about the database .dump ?TABLE? ... Dump the database in an SQL text format If TABLE specified, only dump tables matching LIKE pattern TABLE. .echo on|off Turn command echo on or off .eqp on|off Enable or disable automatic EXPLAIN QUERY PLAN .exit Exit this program | | < | 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 | .dbinfo ?DB? Show status information about the database .dump ?TABLE? ... Dump the database in an SQL text format If TABLE specified, only dump tables matching LIKE pattern TABLE. .echo on|off Turn command echo on or off .eqp on|off Enable or disable automatic EXPLAIN QUERY PLAN .exit Exit this program .explain ?on|off|auto? Turn EXPLAIN output mode on or off or to automatic .fullschema Show schema and the content of sqlite_stat tables .headers on|off Turn display of headers on or off .help Show this message .import FILE TABLE Import data from FILE into TABLE .indexes ?TABLE? Show names of all indexes If TABLE specified, only show indexes for tables matching LIKE pattern TABLE. |
︙ | ︙ | |||
197 198 199 200 201 202 203 204 205 206 207 208 209 210 | .tables ?TABLE? List names of tables If TABLE specified, only list tables matching LIKE pattern TABLE. .timeout MS Try opening locked tables for MS milliseconds .timer on|off Turn SQL timer on or off .trace FILE|off Output each SQL statement as it is run .vfsinfo ?AUX? Information about the top-level VFS .vfsname ?AUX? Print the name of the VFS stack .width NUM1 NUM2 ... Set column widths for "column" mode Negative values right-justify sqlite> }</tcl> <h3>Rules for "dot-commands"</h3> | > | 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 | .tables ?TABLE? List names of tables If TABLE specified, only list tables matching LIKE pattern TABLE. .timeout MS Try opening locked tables for MS milliseconds .timer on|off Turn SQL timer on or off .trace FILE|off Output each SQL statement as it is run .vfsinfo ?AUX? Information about the top-level VFS .vfslist List all available VFSes .vfsname ?AUX? Print the name of the VFS stack .width NUM1 NUM2 ... Set column widths for "column" mode Negative values right-justify sqlite> }</tcl> <h3>Rules for "dot-commands"</h3> |
︙ | ︙ | |||
361 362 363 364 365 366 367 | all of the intervening <TR>s, <TH>s, and <TD>s are. The html output mode is envisioned as being useful for CGI.</p> <tcl>hd_fragment explain {explain dot-command}</tcl> <p>The ".explain" dot command can be used to set the output mode to "column" and to set the column widths to values that are reasonable | | < < < < < < > | | < < < < < < < < < < < < < < < < < < < < < < < < < < | < < | 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 | all of the intervening <TR>s, <TH>s, and <TD>s are. The html output mode is envisioned as being useful for CGI.</p> <tcl>hd_fragment explain {explain dot-command}</tcl> <p>The ".explain" dot command can be used to set the output mode to "column" and to set the column widths to values that are reasonable for looking at the output of an [EXPLAIN] command. <p>Beginning with [Version 3.11.0], the command-line shell defaults to "auto-explain" mode, in which the EXPLAIN commands are automatically detected and the output is automatically formatted. So the ".explain" command has become superfluous. <h3>Writing results to a file</h3> <p>By default, sqlite3 sends query results to standard output. You can change this using the ".output" and ".once" commands. Just put the name of an output file as an argument to .output and all subsequent query results will be written to that file. Or use the .once command |
︙ | ︙ |