/ File History
Login

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

History of src/shell.c.in

2019-11-25
23:55
Experimental file-controls for controlling the use of the -shm file. file: [6ecf8033] check-in: [12b8fa23] user: drh branch: reuse-shm, size: 339763
2019-11-18
17:46
Add support for SQLITE_OPEN_NOFOLLOW. file: [4a3a9e1c] check-in: [cb79c828] user: drh branch: trunk, size: 339285
2019-11-07
19:59
Experimental branch to provide SQLITE_LIMIT_HEAP_K to limit the amount of allocated memory used by each database connection, individually. file: [5e402d7f] check-in: [4ab9dbb9] user: drh branch: limit_heap_k, size: 338744
2019-11-02
00:00
Restore the on-line ".help" for the ".explain" command in the CLI. file: [c06961f2] check-in: [28b8f103] user: drh branch: trunk, size: 338669
2019-10-29
16:18
Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab] file: [a17d143f] check-in: [4d424f30] user: drh branch: trunk, size: 338808
2019-10-26
16:02
Fix a problem in the legacy ".explain on" formatting when it is used on a query with more than 8 output columns. file: [01d14c1e] check-in: [070b4982] user: drh branch: trunk, size: 338735
2019-10-18
15:58
Enhance the ".imposter" command in the CLI so that the first argument can be an existing WITHOUT ROWID table instead of an index. The resulting imposter is the same table, but with columns in storage order and with all constraints removed. file: [3093bdf5] check-in: [9dc0d345] user: drh branch: trunk, size: 338648
2019-10-04
15:31
Bring the reuse-schema branch up-to-date with version 3.30.0. file: [2c49eff3] check-in: [6e09afec] user: drh branch: reuse-schema, size: 346284
2019-10-02
00:25
Disable sqlite3_drop_module() tests when virtual tables are omitted from the build. file: [d70bcf63] check-in: [9f4035f9] user: drh branch: trunk, size: 337778
2019-09-30
16:57
Merge in the 3.30.0 beta 1 changes. file: [a2d3a981] check-in: [06796124] user: drh branch: reuse-schema, size: 346240
2019-09-26
20:05
Allow DROP TABLE to work on tables name "sqlite_parameters" just as it does with tables named "sqlite_stat%". Fix for the ".parameter clear" command in the shell. file: [026d8a5b] check-in: [e768179b] user: drh branch: trunk, size: 337734
2019-09-16
12:35
Merge all recent trunk enhancements into the reuse-schema branch. file: [f3f258a9] check-in: [27eb2236] user: drh branch: reuse-schema, size: 346493
2019-09-14
16:44
Add the --no-rowids option to the ".recover" command. file: [68698630] check-in: [01d71b94] user: dan branch: trunk, size: 337987
2019-08-26
14:57
Tweak the shell tool ".recover" command so that it can recover rows that consist of a rowid and no fields. file: [e5fb9150] check-in: [279ac7fd] user: dan branch: trunk, size: 337513
12:50
Enforce 80-character line discipline in the CLI. Minor improvements to the CLI built-in help. file: [596e4160] check-in: [9690013a] user: drh branch: trunk, size: 337505
2019-08-23
23:05
Fix the built-in edit() SQL function in the CLI so that it works with zero-length blobs. file: [9a0706cd] check-in: [e3249012] user: drh branch: trunk, size: 337676
2019-08-19
20:35
Omit the "_except" term from the name of the new interface. file: [e0f0758b] check-in: [e5ba47c2] user: drh branch: sqlite3_drop_modules_except, size: 337684
2019-08-17
19:45
The experimental sqlite3_drop_modules_except() interface. file: [e0754f1d] check-in: [0851db4d] user: drh branch: sqlite3_drop_modules_except, size: 337622
15:27
Activatate introspection pragmas by default. The new option SQLITE_OMIT_INTROSPECTION_PRAGMAS must be provided to keep them out. file: [48f7a9ee] check-in: [9c4bca64] user: drh branch: trunk, size: 337239
2019-08-16
22:58
Add the ability to unregister a virtual table module by invoking sqlite3_create_module() with a NULL sqlite3_module pointer. file: [d2465e77] check-in: [31e34fa3] user: drh branch: trunk, size: 337233
2019-08-15
21:27
Add the SQLITE_DBCONFIG_ENABLE_VIEW option, together with a "db config" command in the TCL interface that can access that option as well as all the other sqlite3_db_config() boolean options. file: [b748cfb4] check-in: [61b4bccd] user: drh branch: trunk, size: 336807
2019-08-13
15:22
Merge latest trunk changes with this branch. file: [42051fc4] check-in: [5b4689d8] user: dan branch: reuse-schema, size: 345240
2019-08-12
16:25
For the ".testctrl prng_seed" command in the CLI, if the argument is "random" then select a random integer seed and print the seed value on stdout. file: [66cd8289] check-in: [636ca447] user: drh branch: trunk, size: 336734
15:19
Make the sha3 extension part of the amalgamation, enabled using SQLITE_ENABLE_SHA3. file: [4dac87db] check-in: [a48a7b78] user: drh branch: sha3, size: 336538
14:17
Add a TESTCTRL that disables the verification of type, name, and tbl_name in the sqlite_master table. file: [1b9efc93] check-in: [48d9b48a] user: drh branch: trunk, size: 336563
2019-08-08
19:40
Fix harmless compiler warnings. file: [920360b4] check-in: [1eef4dde] user: drh branch: trunk, size: 336478
15:24
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. file: [3f2c64bf] check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 336450
2019-08-06
20:26
Enhance the ".recover" output in the shell to use double-quotes around table and column identifiers. file: [97714cd5] check-in: [846d2d2d] user: drh branch: trunk, size: 336603
18:40
Add "PRAGMA foreign_keys=OFF;" to the start of the script output by ".recover", just as is done for ".dump". file: [486dbf00] check-in: [bfc29e62] user: dan branch: trunk, size: 335875
2019-08-03
01:39
Give the SQLITE_TESTCTRL_PRNG_SEED two arguments. The second argument if not NULL is a pointer to a database connection which seeds the connection from its schema cookie. In this way, fuzzers can control the PRNG seed. file: [e5351f14] check-in: [49aa3448] user: drh branch: prng-seed-test-control, size: 335580
2019-08-02
20:45
Add the SQLITE_TESTCTRL_PRNG_SEED test control. file: [5ab94c68] check-in: [3ac57231] user: drh branch: prng-seed-test-control, size: 335066
2019-07-26
20:54
Merge latest changes from trunk into this branch. file: [8b51039f] check-in: [7f1e4e4b] user: dan branch: reuse-schema, size: 343532
2019-07-24
20:10
Improve the ".recover" command so that it handles intkey pages linked into non-intkey b-trees, and vice-versa, better. file: [9c203a8c] check-in: [9c458acb] user: dan branch: trunk, size: 335026
19:20
Improve the ".recover" command's handling of corrupt database schemas. file: [8bc78eac] check-in: [becaaa4d] user: dan branch: trunk, size: 334636
08:15
Improve the ".recover" command in the shell tool so that it is not confused by auto-vacuum databases. And so that it can recover tables for which one or more of the column names are SQL keywords. file: [68ef28e3] check-in: [87d76047] user: dan branch: trunk, size: 334601
2019-07-17
15:05
Improvement to the hexdb interpreter built into the CLI and into the TCL test harness: Round the "size" up to the next multiple of the "pagesize". file: [a571d51d] check-in: [9ec92939] user: drh branch: trunk, size: 334012
07:23
Add casts to shell.c.in to avoid warnings on systems where size_t is 32 bits. file: [360607dc] check-in: [fe014288] user: dan branch: trunk, size: 333862
2019-07-13
17:21
Fix a double-quoted string literal used in the ".schema" command of the CLI. file: [5c0171b6] check-in: [fcd937d9] user: drh branch: trunk, size: 333838
2019-07-08
21:32
Merge recent trunk enhancements into the reuse-schema branch. file: [46729dfe] check-in: [fae92fee] user: drh branch: reuse-schema, size: 342332
2019-06-21
14:05
Fix a typo in an option name for the .dbconfig command in shell.c.in: s/wriable_schema/writable_schema/ file: [82f8a473] check-in: [1c58522e] user: dan branch: trunk, size: 333826
2019-06-17
13:56
Improved interface to double-quoted string literal enabling/disabling. file: [6edadde4] check-in: [923cfd53] user: drh branch: new-dbconfig-options, size: 333826
2019-06-14
21:25
Add SQLITE_DBCONFIG options LEGACY_ALTER_TABLE, NO_DQS_SCHEMA, and NO_DQS. file: [21e30c2c] check-in: [1fad2092] user: drh branch: new-dbconfig-options, size: 333826
2019-06-13
14:07
Do not use the %lld printf conversion in the platform printf() as some legacy platforms do not support it. file: [ad3405c9] check-in: [f8696b60] user: drh branch: trunk, size: 333525
13:52
Fix a minor error in a test script, and harmless compiler warnings in the CLI code. file: [fec94208] check-in: [eaa34626] user: drh branch: trunk, size: 333447
2019-06-05
14:29
CLI enhancements: Add the ".filectrl" command. Make the ".testctrl" command visible to ".help". file: [9648bc20] check-in: [7b3a99fc] user: drh branch: trunk, size: 333437
2019-06-04
18:21
In the CLI, add a small delay (0.1 seconds) after launching the output command for ".once" before deleting the temporary file. file: [6a58aac0] check-in: [4979f138] user: drh branch: trunk, size: 329021
2019-06-03
13:46
In the CLI, add ".help" text for the .shared-schema command. file: [a0011aba] check-in: [3ba6f790] user: drh branch: reuse-schema, size: 337501
2019-05-24
13:15
The ".shared-schema" command in the CLI requires the sqlite_dbpage table, so disable it if the build does not include that extension. file: [ce8c9243] check-in: [0913ff4d] user: drh branch: reuse-schema, size: 337205
2019-05-14
22:25
Merge all the latest trunk enhancements into the reuse-schema branch. file: [9353bb93] check-in: [018f3199] user: drh branch: reuse-schema, size: 337121
2019-05-10
17:50
Fix harmless compiler warnings in the CLI. file: [6c992809] check-in: [2846bc04] user: drh branch: trunk, size: 328995
2019-05-09
18:33
Fix a problem in the ".recover" command allowing a circular loop of b-tree pages in a database file to cause an infinite loop. file: [1f3e8c70] check-in: [8d2a062e] user: dan branch: trunk, size: 328112
18:13
Make the ".schema" command in the CLI resistant to corrupt database files. file: [332af861] check-in: [f22c7e22] user: drh branch: trunk, size: 328115
16:57
Avoid long delays that can occur when ".recover"ing data from a database with a corrupt freelist. file: [6aa1d26e] check-in: [20f06bf2] user: dan branch: trunk, size: 328069
14:15
Have ".recover" handle cases where the sqlite_master table contains malformed SQL statements. file: [f5d3a1f3] check-in: [e736da9c] user: dan branch: trunk, size: 328057
11:45
Fix a problem with running the ".recover" command on a database that is zero pages in size. file: [517b3e2a] check-in: [47fa6534] user: dan branch: trunk, size: 328015
11:18
Improved error handling for the ".open --hexdb" command of the CLI. file: [5d0e2b03] check-in: [4fa831d5] user: drh branch: trunk, size: 327996
2019-05-03
02:41
Fix the ".open --hexdb" command in the CLI so that it works even with terminal input. file: [5470f088] check-in: [9b5d9434] user: drh branch: trunk, size: 328046
2019-04-29
11:41
Fix a buffer overwrite in shell.c.in (part of the new .recover code). file: [567236da] check-in: [92facbc7] user: dan branch: trunk, size: 328018
2019-04-27
20:15
Fix building the shell with SQLITE_OMIT_VIRTUAL_TABLE. And without SQLITE_ENABLE_DBPAGE_VTAB. file: [104bbae9] check-in: [425d708c] user: dan branch: dbdata, size: 328018
19:36
Add comments and fix formatting issues in new code in shell.c.in. file: [2316b9ee] check-in: [b91d819b] user: dan branch: dbdata, size: 327368
18:47
Add the "--lost-and-found" option to the ".recover" command. For setting the name of the orphaned rows table. file: [51f027f6] check-in: [67bb88e2] user: dan branch: dbdata, size: 326074
15:35
Fix a problem in the .recover command with recovering WITHOUT ROWID tables where the PK columns are not the leftmost in the CREATE TABLE statement. file: [3701177f] check-in: [91df4b8e] user: dan branch: dbdata, size: 323450
2019-04-26
21:11
Have .recover store all orphaned rows in a single table, with extra columns to indicate the orphaned page and sub-tree they were discovered within. file: [146dbc27] check-in: [7221f6e3] user: dan branch: dbdata, size: 323011
17:20
An experimental interface for retrieving the estimated cost and estimated number of output rows for a query. file: [7544d689] check-in: [1b25fa10] user: drh branch: cost-est, size: 302279
15:40
Fix another problem with database freelist handling in the ".recover" command. file: [44dce9f5] check-in: [bee2652a] user: dan branch: dbdata, size: 321983
15:14
Fix a locking-page related problem with the ".recover" command. file: [63b10758] check-in: [afdae104] user: dan branch: dbdata, size: 321918
2019-04-25
20:06
Merge latest trunk changes into this branch. file: [78004b10] check-in: [1da302d8] user: dan branch: dbdata, size: 321103
19:23
Unless the "--freelist-corrupt" option is specified, do not have the .recover command attempt to recover data from pages that are on the database free-list. file: [a3b1bb23] check-in: [8d2f52bb] user: dan branch: dbdata, size: 321119
16:20
Fix a bug preventing .recover from working on databases where the final page of the db is corrupt. file: [2e9b6b05] check-in: [959bbd11] user: dan branch: dbdata, size: 318831
2019-04-24
20:48
Improve the performance of the .recover command. file: [569ee1f7] check-in: [a5076831] user: dan branch: dbdata, size: 318774
2019-04-23
20:48
Have ".recover" handle "\r" and "\n" in the same way as ".dump". file: [6e56c606] check-in: [f95f0f02] user: dan branch: dbdata, size: 318346
18:03
Fixes for the ".recover" shell command. file: [6c02cbd1] check-in: [8dcc1d89] user: dan branch: dbdata, size: 316049
15:30
Changes to the --hexdb decoder option in the shell (and also in the TCL test code) so that it works on systems where sscanf() does not recognize "%hhx" as wanting to delivery results into a character-size variable. file: [bcfa17eb] check-in: [4258e42d] user: drh branch: trunk, size: 302024
2019-04-22
20:52
Enhance the ".recover" command. Fix a problem with overflow pages in dbdata.c. file: [7dd0babc] check-in: [f193ca58] user: dan branch: dbdata, size: 314766
2019-04-20
20:57
Add the ".recovery" command to the shell tool. For recovering the maximum amount data from corrupt databases. Still needs work. file: [3646e448] check-in: [7461d2e1] user: dan branch: dbdata, size: 309929
2019-04-17
23:32
Work around lack of a C99 feature in MSVC. file: [903dafb0] check-in: [f6ebe1c2] user: mistachkin branch: msvc, size: 302272
13:58
Fix a typo in the CLI help output for the ".dump" command. file: [0d1a1abd] check-in: [57638248] user: drh branch: trunk, size: 302042
2019-04-04
20:21
Provide a DBCONFIG to enable or disable virtual tables that match a LIKE pattern. file: [bf49f877] check-in: [b40a4edc] user: drh branch: disable-vtab, size: 302514
2019-03-26
11:57
Merge recent trunk enhancements. file: [30eac60e] check-in: [db4e2cc3] user: drh branch: reuse-schema, size: 310513
2019-03-25
22:05
Fix an obsolete comment in the CLI. No code changes. file: [c1986496] check-in: [fade103c] user: drh branch: trunk, size: 302040
21:56
In the CLI, code the "sqlite_parameters" name directly rather than using a macro, for clarity of presentation for users who are reading the code for the purpose of seeing how the CLI implements parameter binding. file: [3e95f0e2] check-in: [e775ef00] user: drh branch: trunk, size: 302036
21:35
Change the name of the parameter table in the CLI to "sqlite_parameters". Doing so involves adding SQLITE_DBCONFIG_WRITABLE_SCHEMA and allowing the creation of tables whose names begin with "sqlite_" and that are indexed while writable_schema is on. file: [35d0257c] check-in: [24ef3844] user: drh branch: trunk, size: 302162
15:09
Improvements to the help text in the CLI. file: [9c166e41] check-in: [919fec91] user: drh branch: trunk, size: 301687
14:24
For the ".archive --update" command in the CLI, only update files if their mtime or mode has changed. To force an update, use the new --insert instead. file: [652ba411] check-in: [191a023a] user: drh branch: trunk, size: 301685
2019-03-21
17:22
Merge latest trunk changes with this branch. file: [2030093c] check-in: [3196f5f4] user: dan branch: reuse-schema, size: 308972
17:13
Disable the feature on this branch in non-SQLITE_ENABLE_SHARED_SCHEMA builds. file: [c82e5dce] check-in: [b8e53608] user: dan branch: reuse-schema, size: 308608
2019-03-20
18:22
In the CLI, give better error messages if something goes wrong with the ".dbinfo" command. file: [576ba793] check-in: [3649a77b] user: drh branch: trunk, size: 300499
16:03
Merge latest trunk changes into this branch. file: [84f22bfb] check-in: [4cd20ca6] user: dan branch: reuse-schema, size: 308609
2019-03-06
14:53
Add the sqlite3_stmt_isexplain() interface. file: [01c0cc01] check-in: [ee642d3e] user: drh branch: trunk, size: 300135
2019-03-04
07:25
Merge latest trunk changes into this branch. file: [0ba39416] check-in: [97a9604d] user: dan branch: reuse-schema, size: 308749
2019-02-28
20:10
Add the ".parameter" command to the CLI. file: [249c0bf3] check-in: [1f9fa585] user: drh branch: trunk, size: 300275
2019-02-26
15:43
Add the ".shared-schema check|fix DB1 DB2..." command to the shell tool. For checking if a database is eligible to share an in-memory with the main database, and for fixing small problems that prevent it from being so. file: [89848d1e] check-in: [7d8e8a95] user: dan branch: reuse-schema, size: 302872
2019-02-25
18:43
Enhance the command-line shell to accept bound parameters, using the TEMP table named "$Parameters" to look up the values for bound parameters. file: [a238f3f8] check-in: [7c941ce5] user: drh branch: trunk, size: 295995
2019-02-14
18:38
Change the name of the SQLITE_OPEN_REUSE_SCHEMA flag to SQLITE_OPEN_SHARED_SCHEMA. file: [d7d63fd1] check-in: [7257fcc8] user: dan branch: reuse-schema, size: 294959
2019-02-11
20:13
Merge latest trunk changes into this branch. file: [e32838e3] check-in: [dbedd81b] user: dan branch: reuse-schema, size: 294960
2019-02-05
20:51
Omit the ".progress" command from the shell if it is compiled with the SQLITE_OMIT_PROGRESS_CALLBACK option. file: [f2c1adbe] check-in: [4d0a949f] user: drh branch: trunk, size: 294398
19:51
Merge latest trunk into this branch. file: [d3c5b1c0] check-in: [c089cc4f] user: dan branch: reuse-schema, size: 294723
19:48
Fix compiler warnings on Windows. file: [b5149a7d] check-in: [4978ee8b] user: drh branch: trunk, size: 294191
2019-02-04
19:52
Mention the new -memtrace command-line option in the -help output of the CLI. file: [72a09544] check-in: [ada91aef] user: drh branch: trunk, size: 294161
14:53
Add the ".progress" command to the CLI. file: [d9898bed] check-in: [ad84ca24] user: drh branch: trunk, size: 294084
2019-01-27
19:50
Improvements to the ".eqp trace" command in the CLI so that it ensures that the schema has been read prior to activing the tracing feature, to avoid cluttering the output with a trace of the schema parse. file: [705a00be] check-in: [42687d45] user: drh branch: trunk, size: 291271
2019-01-26
15:40
Add the ".eqp trace" command to the CLI when using SQLITE_DEBUG, as a convenient shorthand for "PRAGMA vdbe_debug=ON" but with automatic indentation feature for program listings provided by the CLI. file: [324bc8df] check-in: [626502fa] user: drh branch: trunk, size: 291264
2019-01-22
16:44
Use _strdup() instead of strdup() on Windows builds of the CLI, to avoid a compiler warning reported on the mailing list. file: [58f69c91] check-in: [a7126a4f] user: drh branch: trunk, size: 290484
16:06
Enhancements to deserialize: (1) Add the SQLITE_FCNTL_SIZE_LIMIT file control to set a maximum size for an in-memory database, defaulting to SQLITE_MEMDB_DEFAULT_MAXSIZE or 1GiB. (2) Honor the SQLITE_DESERIALIZE_READONLY flag. (3) Enhance the TCL interface to support -maxsize N and -readonly BOOLEAN. (4) Add the --maxsize option to the ".open" command and on the command-line for the CLI. file: [7649cd10] check-in: [30f08d58] user: drh branch: trunk, size: 290435
2019-01-21
14:55
Add the --memtrace option to the CLI. file: [58b94d24] check-in: [a1e12fa2] user: drh branch: trunk, size: 289620
2019-01-11
17:19
Omit errors about missing SAVEPOINTs when aborting the .archive command in the CLI. file: [b3cd745b] check-in: [2a47387b] user: drh branch: trunk, size: 289454
2019-01-04
14:29
If the ".open" command fails in the CLI, reopen to :memory: so that at least some database is available for subsequent commands. file: [0722a9e3] check-in: [d7f55c62] user: drh branch: trunk, size: 289438
2018-12-17
22:19
Move variable declaration to address compilation issue (C89). file: [207da303] check-in: [d64f248d] user: mistachkin branch: trunk, size: 289379
2018-12-13
22:58
Fix the dbtotxt decoder in the CLI so that it ignores excess bytes. file: [e1790e0d] check-in: [18740bd4] user: drh branch: trunk, size: 289369
18:59
Fix the CLI to keep proper track of input line numbers for use in error messages, even after processing in-line hex database inputs using ".open --hexdb". file: [a9b26ab3] check-in: [7ffa9858] user: drh branch: trunk, size: 289457
18:30
Fix the CLI so that the ".open --hexdb" command works even if it is contained in a subscript that is read using ".read". file: [b998c6d7] check-in: [67a87399] user: drh branch: trunk, size: 289174
15:06
Add the "dbtotxt" utility program and the ability to read "dbtotxt" output as a deserialized input database in the CLI, using the --hexdb option to the ".open" command. file: [6c06ff40] check-in: [e3bf1d3e] user: drh branch: trunk, size: 289014
2018-12-08
01:09
Add the --async option to the ".backup" command in the CLI. file: [5f38bd0e] check-in: [7b6a605b] user: drh branch: vacuum-into, size: 286173
2018-12-05
13:39
Enhance the sqlite3_normalize_sql() interface so that it works even if the prepared statement was not initially compiled using SQLITE_PREPARE_NORMALIZED. Enhance the ".trace" command in the CLI so that it is able to access the full scope of functionality provided by sqlite3_trace_v2() and in particular so that it is able to show normalized SQL output using the newly enhanced sqlite3_normalize_sql() interface. file: [1f0819e6] check-in: [7da617e9] user: drh branch: trunk, size: 285865
2018-11-26
18:09
Do not allow direct access to internal-use SQL functions such as sqlite_rename_column() and sqlite3_rename_table() except when the new SQLITE_TESTCTRL_INTERNAL_FUNCTIONS flag is set. file: [482e23a3] check-in: [6e133054] user: drh branch: trunk, size: 282805
2018-11-17
18:45
Merge latest trunk changes into this branch. file: [91ccfc85] check-in: [9fdd1868] user: dan branch: reuse-schema1, size: 283233
2018-11-16
14:36
In order to avoid exporting a symbol, use a macro instead of a function to replace sqlite3_complete() in the shell code when SQLITE_OMIT_COMPLETE is defined. file: [6a9d8a56] check-in: [d584a0cb] user: dan branch: trunk, size: 282671
2018-11-15
21:20
Fix some problems with the feature on this branch. Many problems remain. file: [9f517c22] check-in: [31b6aee7] user: dan branch: reuse-schema1, size: 283255
2018-11-09
18:44
Merge latest trunk changes with this branch. file: [37a6b4c3] check-in: [ae88f8e1] user: dan branch: reuse-schema, size: 283253
2018-11-03
16:09
Add the SQLITE_DBCONFIG_DEFENSIVE flag. file: [060ccc32] check-in: [af3f29d4] user: drh branch: dbconfig-defensive, size: 282693
2018-10-30
15:31
Modify the CLI so that the --deserialize option is only available if it is compiled with SQLITE_ENABLE_DESERIALIZE. DESERIALIZE is now off by default for the main.mk makefile, but on for Makefile.in and Makefile.msc. file: [f5a89e43] check-in: [90b2a684] user: drh branch: trunk, size: 282621
14:36
In the CLI, when opening a file that begins with the normal SQLite prefix, open the file as a normal database even if it has a ZIP for AppendVFS record at the end. file: [a1fa7476] check-in: [7989bbda] user: drh branch: trunk, size: 282416
13:19
Enable sqlite3_deserialize() in the CLI. The --deserialize option associated with opening a new database cause the database file to be read into memory and accessed using the sqlite3_deserialize() API. This simplifies running tests on a database without risk of modifying the file on disk. file: [ac4a731d] check-in: [5e0129ee] user: drh branch: trunk, size: 282282
2018-10-11
16:53
Fix harmless compiler warnings in the CLI. file: [248af8c0] check-in: [1916d291] user: drh branch: trunk, size: 281318
10:37
In the CLI, fix a file descriptor leak following OOM and a missing va_end() call. file: [fa815984] check-in: [ec36d15a] user: drh branch: trunk, size: 281308
2018-10-10
18:56
In the CLI, allow the SQLITE_HISTORY environment variable, if it exists, to specify an alternative file in which to store the shell edit history. file: [d574c3be] check-in: [696e82f7] user: drh branch: trunk, size: 281277
2018-10-08
23:29
Add the ability to open a database connection in -reuseschema mode in the CLI. Adjust memory allocation accounting so that a shared schema is allocated across each database sharing it. file: [f6c19d23] check-in: [3869b210] user: drh branch: reuse-schema, size: 281712
2018-10-06
14:38
Fix the ".help -all" option in the command-line shell. file: [09342e09] check-in: [aac8f1df] user: drh branch: trunk, size: 281181
2018-10-03
11:13
Change a type in shell.c.in from "int" to "sqlite3_int64" in order to avoid a compiler warning and possible integer overflow. file: [6046da2a] check-in: [bf0a6634] user: dan branch: trunk, size: 281060
2018-09-26
18:02
Further improvements to the ".help" command in the CLI. file: [2162b1dc] check-in: [edc3d18e] user: drh branch: trunk, size: 281050
16:53
Begin revamping the ".help" command in the command-line shell so that it can accept an argument and will do a search for commands that match that argument. file: [03d87b06] check-in: [209afb8d] user: drh branch: trunk, size: 280262
2018-08-06
02:08
Enhance the edit() function so that it converts text from \r\n back into \n only if the original unedited copy contained no \r\n values. file: [6e0aad85] check-in: [20c995d3] user: drh branch: trunk, size: 278499
2018-07-29
18:56
In the command-line shell, always exit if realloc() fails. file: [5e4c1397] check-in: [e390023c] user: drh branch: trunk, size: 277889
2018-07-22
06:25
In the Win32 VFS, when truncating a file, unmap it first. file: [f6ebd05c] check-in: [21510a66] user: mistachkin branch: trunk, size: 277850
2018-07-18
19:09
Add the SQLITE_FCNTL_DATA_VERSION file control file: [239aee55] check-in: [a5087c5c] user: drh branch: trunk, size: 277405
2018-07-05
17:35
Fix the .dump command in the command-line shell so that it does not show extraneous SELECT statements when ".echo on" is enabled. file: [f1c79c53] check-in: [11763cac] user: drh branch: trunk, size: 277235
2018-06-19
21:15
Make the ieee754() a built-in function. Add the --ieee754 option to the ".dump" command in the shell to cause it to output floating-point values as ieee754() calls, so that the floating point number will be reproduced exactly. Not sure yet that we want to go this way, but it is one option. file: [5473740b] check-in: [7fa8f16e] user: drh branch: ieee754, size: 278242
2018-06-13
17:19
Output infinity as 1e999 in the ".dump" command of the command-line shell. file: [8578421c] check-in: [ee431d55] user: drh branch: trunk, size: 277148
2018-06-07
17:32
Remove the NextIfOpen and PrevIfOpen opcodes which are no longer needed when the IN-early-out optimization is working. file: [4d0ddf10] check-in: [439c8162] user: drh branch: multikey-opt-idea, size: 276877
15:23
Avoid using a prepared statement for ".stats on" after it has been closed by the ".eqp full" logic. Fix for ticket [7be932dfa60a8a6b3b26bcf76]. file: [3151c40b] check-in: [bb87c054] user: drh branch: trunk, size: 276932
2018-06-06
01:18
Fix the ".archive" command in the CLI (and the corresponding -A command-line option) so that it silently ignores filenames that contain "../" in their names. This prevents the "Zip Slip" attack. file: [099edada] check-in: [27291f2d] user: drh branch: trunk, size: 276890
2018-05-30
07:24
Fix a typo in an error message in the CLI. file: [c29cb307] check-in: [80883980] user: drh branch: trunk, size: 276853
2018-05-18
17:11
In the CLI, detect and report errors on sqlite3_close(). Clear global variables prior to exit to so that valgrind can better detect resource leaks. file: [51c10020] check-in: [e3b2e0a0] user: drh branch: trunk, size: 276857
2018-05-17
20:04
In the CLI with the -A command, if the file does not previously exist and its name looks like a ZIP archive name, then create it as a ZIP archive. file: [e0f00698] check-in: [33dc8fad] user: drh branch: trunk, size: 276466
14:09
Improved error and help messages for the ".archive" command and "-A" option to the CLI. If a memory leak in --list processing. file: [d9154a6b] check-in: [02541ac6] user: drh branch: trunk, size: 275815
13:29
Fix memory errors associated with argv in the CLI when it is compiled on Windows. file: [e4086ed1] check-in: [4474d69b] user: drh branch: trunk, size: 275414
2018-05-14
12:23
Fix typo in the shell.c source file. file: [53affa90] check-in: [389dc0a9] user: mistachkin branch: trunk, size: 275230
00:41
Export the deduceDatabaseType() function the shell.c source file. file: [bd7ea498] check-in: [d0f35739] user: drh branch: trunk, size: 275232
00:23
Add the --append option to the ".backup" command in the CLI. file: [05d9da22] check-in: [0dfdbdee] user: drh branch: trunk, size: 275239
2018-05-12
23:56
In the CLI, allow comment lines that begin with '#', but only in a context where a dot-command is allowed. In other words, '#' at the beginning of a line in the middle of an SQL statement is just part of the SQL. file: [df40a09c] check-in: [4ee136d6] user: drh branch: trunk, size: 275031
2018-05-11
19:11
In the CLI, return non-zero if there are errors on the command-line. file: [4caa8c44] check-in: [13e7300a] user: drh branch: trunk, size: 274949
14:02
Fix a typo in the help message from the ".sha3sum" command in the CLI. file: [c625e817] check-in: [e76f676c] user: drh branch: geojson, size: 274908
14:00
Make sure the open_db() routine in the CLI does not invoke access() with a NULL filename. file: [c696c384] check-in: [2b8fd3b4] user: drh branch: geojson, size: 274908
2018-05-08
23:17
Correctly format the STAT1 and STAT4 content in the output from the ".fullschema" command in the CLI. Fix for ticket [e63a34a0045832dc850367552]. file: [df233d55] check-in: [0c3f128f] user: drh branch: trunk, size: 274786
2018-05-07
11:37
Fix harmless compiler warnings associated with the new EXPLAIN QUERY PLAN logic. file: [e41979d8] check-in: [374d8e26] user: drh branch: trunk, size: 274774
2018-05-02
00:33
Begin reengineering the EXPLAIN QUERY PLAN function to provide more intuitive output. file: [29309f2a] check-in: [70b48a79] user: drh branch: rework-EQP, size: 274769
2018-04-28
12:43
Add the SQLITE_DBCONFIG_RESET_DATABASE control as a replacement for the reset_database pragma. Resetting the database should be hard enough to do that it cannot be done by accident. file: [54b902ab] check-in: [ff836cb8] user: drh branch: reset-database, size: 274862
2018-04-27
20:49
Better comments on the bindvtab.c implementation. All the two-argument version of the .set command. All bindings from .set and -D are still string. file: [d751c9e8] check-in: [7b2a65a6] user: drh branch: shell-bindings, size: 274547
17:39
Add the ability to use bind parameters in the CLI. The new ".set KEY=VALUE" dot-command works to set bindings. Or use the "-Dkey=value" command-line option. Or use the built-in shell_bindings(k,v) virtual table to set, delete, or changing bindings. file: [3bac9ab3] check-in: [1f2944d1] user: drh branch: shell-bindings, size: 274241
2018-04-25
19:02
Add new interfaces for accessing the list of SQL keywords: sqlite3_keyword_count(), sqlite3_keyword_name(), sqlite3_keyword_check(). file: [d63f06c8] check-in: [7dd34e37] user: drh branch: trunk, size: 273403
17:10
Add the new DO and NOTHING keywords to the keyword lists maintained by various extensions and auxiliary programs. file: [be819b84] check-in: [77a98a07] user: drh branch: trunk, size: 275440
13:27
Add the new SQLITE_SHELL_INIT_PROC compile-time entry point to the CLI. This is needed to work around the tighter sqlite3_config() constraints now in the CLI. file: [38aa5740] check-in: [3bcdbccf] user: drh branch: trunk, size: 275419
2018-04-24
13:07
Enhance the CLI to render EXPLAIN QUERY PLAN using an ASCII-art graph. This works with ".eqp" modes and when the query begins with exactly "EXPLAIN QUERY PLAN". To see the original output format, add extra space characters in between words of the initial "EXPLAIN QUERY PLAN". file: [fc3f9e47] check-in: [f53716ee] user: drh branch: trunk, size: 274990
2018-04-23
18:38
Add the ".imposter off" variant of the ".imposter" dot-command in the CLI. file: [4115df36] check-in: [d3dad06f] user: drh branch: trunk, size: 271465
2018-04-18
19:56
Add the "sorter-reference" optimization, allowing SQLite to be configured so that some required values may be loaded from the database after external sorting occurs for SELECT statements with ORDER BY clauses that are not satisfied by database indexes. file: [8ab4687d] check-in: [ef74090a] user: dan branch: trunk, size: 271230
15:21
Add the --sorterref N option to the CLI. file: [6c9e2c11] check-in: [902a4089] user: drh branch: sorter-reference, size: 270604
10:44
Add checks to the CLI that issue a warning if SQLite gets initialized prior to the last sqlite3_config() call. file: [bcde676b] check-in: [40b11734] user: drh branch: trunk, size: 270795
09:16
Fix a problem in the shell preventing it from working with SQLITE_OMIT_AUTOINIT builds. file: [7fbdc5c5] check-in: [89209000] user: dan branch: trunk, size: 270391
2018-04-10
10:37
Remove an unnecessary SQLITE_UNTESTABLE compile-time conditional from the command-line shell. file: [cc960721] check-in: [80b75a34] user: drh branch: trunk, size: 270169
2018-03-23
16:08
Fix the -readonly option on the CLI so that it actually works. file: [d6a07811] check-in: [0477fb3f] user: drh branch: trunk, size: 270208
14:24
Enhance .schema in shell to enable matching patterns with literal underscores. file: [8e7fb346] check-in: [98e3f524] user: mistachkin branch: trunk, size: 270123
13:18
Fix an error in the CLI in the previous ([0249d9aecf69948]) check-in. Only the pattern to sqlite3_strlike() need to be escaped. file: [be2afd4b] check-in: [71d5f6e6] user: drh branch: trunk, size: 269926
12:59
Fix the ANALYZE command so that it will process tables whose names begin with "sqlite" as long as they do not being with "sqlite_". file: [f5687352] check-in: [0249d9ae] user: drh branch: trunk, size: 269938
00:31
Fix harmless compiler warnings seen with MSVC. file: [211a99f5] check-in: [2f2be1b1] user: mistachkin branch: trunk, size: 269921
2018-03-20
12:04
In the CLI, avoid extra .selecttrace and .wheretrace output when in ".eqp full" mode. file: [911b9e3b] check-in: [427bbf31] user: drh branch: push-down-disable, size: 269869
2018-03-17
16:26
Do not use sqlite3_column_decltype() in the CLI if it is compiled with SQLITE_OMIT_DECLTYPE. file: [52b1b3f5] check-in: [442e816b] user: drh branch: trunk, size: 269651
2018-03-14
14:53
Add the SQLITE_DBSTATUS_CACHE_SPILL option to sqlite3_db_status() file: [9b7e7ac1] check-in: [3faeb851] user: drh branch: dbstatus-cache-spill, size: 269621
2018-03-09
22:18
Fix the .archive command in the CLI so that it actually compresses content. file: [b0aad885] check-in: [3c2e3c2d] user: drh branch: trunk, size: 269444
21:54
Enhance the ".ar" command in the CLI so that it is able to update and create ZIP Archives. file: [b499275d] check-in: [9404765e] user: drh branch: trunk, size: 269459
16:37
Setting ".stats 2" in the CLI causes column metadata for each prepared statement to be displayed. file: [75490510] check-in: [7fea00fd] user: drh branch: trunk, size: 267987
15:24
Simplification to the shell_exec() mechanism in the CLI. file: [23eb7501] check-in: [72e8f529] user: drh branch: trunk, size: 266589
2018-03-08
18:14
Add the --append and --zip options of the CLI to the --help message. file: [edbc1b73] check-in: [f010c86e] user: drh branch: trunk, size: 267385
2018-03-05
20:21
Improved command-line help for the -A option on the CLI. file: [8c6ea9b4] check-in: [d937ac18] user: drh branch: trunk, size: 267217
20:20
A new way of doing archive commands on the command-line for the CLI. The -A option means that everything that follows is a ".archive" command, including any suffix on the -A option. file: [4b2b00d2] check-in: [9d8081fa] user: drh branch: trunk, size: 267223
19:34
In the CLI, add a new command-line option "--archive" (also "--ar") that passes all subsequent arguments to the ".archive" command. file: [2115621c] check-in: [a5c4d30a] user: drh branch: trunk, size: 267131
2018-02-26
16:49
Fix heap issue in the shell on Win32 caused by allocator mismatch. file: [47dac081] check-in: [7b3a7551] user: mistachkin branch: trunk, size: 266335
2018-02-15
01:03
Fix the --heap, --pagecache, --lookaside and other options to the command-line shell that invoke sqlite3_config() so that they work again. file: [c1b14bc0] check-in: [00707f2f] user: drh branch: trunk, size: 266351
2018-02-14
23:27
Add the --readonly option to the ".open" command in the CLI. file: [6fdccd0a] check-in: [06870bb1] user: drh branch: trunk, size: 265777
2018-02-04
20:33
In the CLI, make sure sqlite3_initialize() is called correctly even for non-UTF8 hosts. file: [0b2c8d55] check-in: [a3591fb5] user: drh branch: trunk, size: 265266
2018-01-31
01:38
Changes to the autoconf tarball so that it does not try to use system() when building on iOS. file: [ada6d184] check-in: [32ed9c10] user: drh branch: trunk, size: 265266
2018-01-24
01:58
Make the shell functional even if compiled with SQLITE_OMIT_COMPLETE. Omit the sqlite3_complete() call from the fuzzing interface if it is compiled with SQLITE_OMIT_COMPLETE. file: [7cea439c] check-in: [c3e816cc] user: drh branch: trunk, size: 264887
2018-01-23
00:05
Fix harmless compiler warnings seen with MSVC. file: [06ffe417] check-in: [76a11a80] user: mistachkin branch: trunk, size: 264537
2018-01-17
13:15
Fix harmless compiler warnings, mostly unused parameters for UDFs in the CLI. file: [4e1bcf8c] check-in: [bfbeffab] user: drh branch: trunk, size: 264478
2018-01-16
20:05
Move the ZLIB version announcement in the CLI out of the default banner and put it in the ".version" command. file: [568aacb5] check-in: [231679d6] user: drh branch: trunk, size: 264412
19:03
Show version of zlib in use when running the shell tool in interactive mode. file: [594f9427] check-in: [a8906b52] user: mistachkin branch: trunk, size: 263906
2018-01-11
00:38
Update the .help screen in the CLI. Make sure the temporary files for ".open" are not deleted too soon. file: [b87abffd] check-in: [b8d92d8d] user: drh branch: trunk, size: 263821
00:04
Add the built-in edit(VALUE) and edit(VALUE,EDITOR) function to the CLI. file: [52aef9f2] check-in: [ef823c47] user: drh branch: trunk, size: 263624
2018-01-10
22:27
Save and restore the output mode when doing ".once -x" or ".excel". file: [0baa3d01] check-in: [f697c164] user: drh branch: excel-shell-cmd, size: 260228
22:15
An attempt to get ".once -e" working reliably on Windows. file: [8ac56c0e] check-in: [9b97f9d2] user: drh branch: excel-shell-cmd, size: 259613
21:50
Fix a potential SQLITE_MISUSE in the .excel command when no database is open. file: [362e3af7] check-in: [9b95ff1a] user: drh branch: excel-shell-cmd, size: 259450
21:41
Add support for the ".excel" command (and ".once -e" and ".once -x") in the CLI. file: [d1dbc151] check-in: [23fa7c57] user: drh branch: excel-shell-cmd, size: 259429
18:09
Modify the new "--append" option to the .archive so that it takes a filename argument, the same as "--file". file: [2e72b9dc] check-in: [58e3b07c] user: drh branch: trunk, size: 256958
17:39
Fix minor problems with the new ".archive" command changes. file: [4cb216da] check-in: [612b30c9] user: drh branch: archive-improvements, size: 256930
17:19
In the fileio.c extension, change the filetype(MODE) function into lsmode(MODE). Use the new lsmode(MODE) function in shell.c. file: [926858c0] check-in: [52d12ba9] user: drh branch: archive-improvements, size: 256791
16:50
Implement the ".ar --create" command using a single "REPLACE INTO sqlar SELECT ... FROM fsdir();" statement. Add the shell_putsnl() SQL function for providing --verbose output. file: [f8ae3a79] check-in: [28ab9304] user: drh branch: archive-improvements, size: 257405
15:17
The ".ar" command deduces whether or not the target file is a ZIP or SQLAR and does the appropropriate thing. The "-z" option is omitted. The "--append" option is added to open auxiliary databases using apndvfs. file: [7d49ed78] check-in: [430d1a7d] user: drh branch: archive-improvements, size: 258215
13:44
Checked into the wrong branch. file: [aae06c14] check-in: [55116dc3] user: drh branch: mistake, size: 257638
13:11
Work on the ".archive" command. (1) Add the --dryrun option. (2) Do not require --file when open on a ZIP archive. (3) Miscellaneous code simplifications. This is an incremental check-in of work in progress. file: [f86200b0] check-in: [a2baada4] user: drh branch: archive-improvements, size: 257380
00:53
Rearrange some routines in shell.c to avoid the need to forward reference a static function. file: [1e50d66d] check-in: [fd7f51a1] user: drh branch: trunk, size: 256677
2018-01-09
15:57
Fix another -fsanitize issue in new shell code. file: [4121ecd9] check-in: [6ee7b54c] user: dan branch: trunk, size: 256729
15:25
Fix the shell so that it can be built with SQLITE_OMIT_VIRTUALTABLE. file: [2a752aed] check-in: [931421a2] user: dan branch: trunk, size: 256675
00:28
Improve portability of compile-time MinGW detection for the command line shell. file: [fb615970] check-in: [4a723614] user: mistachkin branch: trunk, size: 256478
2018-01-08
19:59
Update the zipfile module so that it matches the documentation. file: [2aa65d15] check-in: [7e7e472f] user: dan branch: trunk, size: 256474
17:05
Fix a malloc/sqlite3_free mismatch in the shell tool code. file: [be04d679] check-in: [fe053b2e] user: dan branch: trunk, size: 256508
2018-01-07
21:58
Remove the dependency on test_windirent.h from the generated shell.c file. file: [0e20ac49] check-in: [0a50c9e3] user: drh branch: trunk, size: 256468
20:38
Modify the sqltclsh startup script to look for a properly formatted SQLAR at the end of the executable. Fix the CLI so that it automatically links against appendvfs and so that the --append command-line option works. file: [ffcef0e1] check-in: [67c4a8c6] user: drh branch: trunk, size: 256443
2018-01-06
21:46
The shell detects and opens ZIP archives using the zipfile extension. file: [c2231d96] check-in: [05c99eb8] user: drh branch: trunk, size: 256185
19:19
In the shell, include the ".archive" command only if compiling with SQLITE_HAVE_ZLIB. Add ".archive" to the ".help" output. file: [9f2ab2d0] check-in: [366469f5] user: drh branch: trunk, size: 253918
15:49
Better whitespace in the "CREATE TABLE sqlar()" statement for the ".ar" command. file: [1f1d02e8] check-in: [252ee55a] user: drh branch: trunk, size: 253324
15:46
Improved output from ".schema --indent" when a column definition is followed by a comment. file: [8874828e] check-in: [87da7eff] user: drh branch: trunk, size: 253308
2018-01-05
21:01
Make sure i64 and u64 typedefs are available throughout shell.c. file: [4cfa9394] check-in: [656fb5aa] user: drh branch: trunk, size: 252819
20:26
MinGW does not define the S_ISLNK macro; therefore, define it in the shell when needed. file: [df0e5728] check-in: [73023feb] user: mistachkin branch: trunk, size: 252764
20:08
Fix shell compilation with MinGW by including the 'dirent.h' header. file: [54b689b5] check-in: [dfe510b5] user: mistachkin branch: trunk, size: 252708
14:55
Fix compiler warnings. file: [17fc2866] check-in: [364ac333] user: drh branch: sqlar-shell-support, size: 252583
00:53
Add missing #ifdef. file: [f57fa72e] check-in: [a0e18aea] user: mistachkin branch: sqlar-shell-support, size: 252707
2018-01-04
22:50
Remove 'timespec' related code from the shell that has no effect and a (now) superfluous 'timespec' typedef from the Win32 dirent header file. file: [84af7b92] check-in: [57dac995] user: mistachkin branch: sqlar-shell-support, size: 252676
22:46
Get the shell enhancements compiling with MSVC. file: [e17f15b3] check-in: [335387f9] user: mistachkin branch: sqlar-shell-support, size: 252769
19:54
Merge in all recent trunk enhancements. file: [3e2db269] check-in: [406f7918] user: drh branch: sqlar-shell-support, size: 252625
2018-01-03
23:54
Fix compiler warnings on Windows. file: [23b0207a] check-in: [512b8e40] user: drh branch: memdb, size: 231374
2018-01-02
12:50
Do not attempt to use pragma_module_list in the command-line shell unless it has been compiled with -DSQLITE_INTROSPECTION_PRAGMAS. file: [a418ddce] check-in: [39ca5fcd] user: drh branch: trunk, size: 231372
00:04
The ".schema" command in the command-line shell now shows the structure of table-valued functions and eponymous virtual tables if they are named on the ".schema" command line. Example: ".schema sql%" shows the structure of the "sqlite_dbstat" and "sqlite_stmt" virtual tables. file: [6b1ec35f] check-in: [f80f6651] user: drh branch: trunk, size: 231329
2018-01-01
21:49
Improved name quoting and escaping in the auxiliary column info section of the ".schema" output for views and virtual tables. file: [e0d3ef67] check-in: [d64b14e3] user: drh branch: trunk, size: 230411
21:28
In the output of ".schema", show the column names of virtual tables and views in a separate comment. file: [f151a118] check-in: [2234a87f] user: drh branch: trunk, size: 230031
20:11
Minor simplification to the ".schema" logic in the command-line shell. file: [a3f30523] check-in: [add45c47] user: drh branch: trunk, size: 228677
2017-12-27
21:13
Improve the shell tool ".ar --list --verbose" command. file: [9177b6cc] check-in: [b64681a6] user: dan branch: sqlar-shell-support, size: 250054
18:54
Have the shell tool ".ar --list" and ".ar --extract" commands support zip files. Currently the "-zip" switch is required. file: [d1be3030] check-in: [a532a0f6] user: dan branch: sqlar-shell-support, size: 248943
2017-12-26
20:39
Add new file ext/misc/zipfile.c, containing a virtual table for read-only access to simple zip archives. file: [1c927f94] check-in: [8e366b99] user: dan branch: sqlar-shell-support, size: 247569
18:04
Add support for measuring and reporting coverage of the parser state machine using the SQLITE_TESTCTRL_PARSER_COVERAGE test-control. file: [f3ec8f90] check-in: [1253a872] user: drh branch: lemon-improvements, size: 229094
2017-12-23
18:34
Merge enhancements from trunk. file: [e739db28] check-in: [150f07fe] user: drh branch: sqlar-shell-support, size: 247500
2017-12-21
21:02
Add the ".eqp trigger" option to the ".eqp" command in the command-line shell. Implemented using the new SQLITE_DBCONFIG_TRIGGER_EQP control. file: [339169a3] check-in: [2c51644a] user: drh branch: trunk, size: 228801
18:55
Add the ".expert" command to the shell tool's ".help" output. file: [ef343d70] check-in: [fc6193af] user: dan branch: trunk, size: 228204
2017-12-19
17:42
Experimentally add the SQLite expert functionality to the shell tool. file: [87a048fa] check-in: [51068dba] user: dan branch: expert-in-shell, size: 228123
2017-12-16
19:11
Do not use the compress() and uncompress() functions in ext/misc/compress.c - they are not quite compatible with the spec. Instead use new functions in ext/misc/sqlar.c. file: [ad8c13b9] check-in: [7652b3c2] user: dan branch: sqlar-shell-support, size: 242256
2017-12-14
19:15
Have the writefile() function optionally set the modification-time of the files it writes or creates. And many small fixes to the new code on this branch. file: [074b2129] check-in: [7b51269c] user: dan branch: sqlar-shell-support, size: 243234
15:40
Improve error and usage messages output by the shell ".ar" command. file: [4bdd2efe] check-in: [b9d2d5d9] user: dan branch: sqlar-shell-support, size: 243209
2017-12-13
20:17
Add the shell tool ".ar --update" command. file: [12313c05] check-in: [825e3c03] user: dan branch: sqlar-shell-support, size: 241382
20:04
Add support for the "--list" command. And for arguments to the "--extract" command. file: [b53eddcb] check-in: [32c4fa25] user: dan branch: sqlar-shell-support, size: 240689
2017-12-12
20:28
Add tests and fixes for the shell ".ar" command -f option. file: [a09773c8] check-in: [1a986797] user: dan branch: sqlar-shell-support, size: 237416
20:04
Add support for parsing options in non-traditional tar form to the ".ar" command. Have writefile() attempt to create any missing path components. And not to throw an exception if it is called to create a directory that already exists. file: [0ab6e3c1] check-in: [38dbeb1e] user: dan branch: sqlar-shell-support, size: 237340
2017-12-11
20:22
Enhance virtual table "fsdir" in ext/misc/fileio.c. Add support for "-C" to the shell command's ".ar c" command. file: [4c7a2c12] check-in: [0394889a] user: dan branch: sqlar-shell-support, size: 233622
2017-12-09
18:28
Add support for -C to ".ar x". file: [8e57abbd] check-in: [8cd70960] user: dan branch: sqlar-shell-support, size: 233763
17:58
Improve parsing of ".ar" commands. Add new test file for the same. file: [907661ee] check-in: [840401cc] user: dan branch: sqlar-shell-support, size: 233426
2017-12-07
21:03
Add the ".ar x" command to the shell. For extracting the contents of sqlar archives. file: [2f9ae0be] check-in: [0cc699d1] user: dan branch: sqlar-shell-support, size: 230700
15:44
Begin adding support for the sqlar archive format to shell.c. There is no "extract" command so far, only "create". file: [56c4c091] check-in: [c9827a01] user: dan branch: sqlar-shell-support, size: 229729
2017-12-05
18:32
If SQLITE_HAVE_ZLIB is defined at build-time, include the functions in ext/misc/compress.c in the shell. file: [ab727c09] check-in: [0296286a] user: dan branch: sqlar-shell-support, size: 223689
2017-12-01
18:40
Fix the ".lint fkey-indexes" shell command so that it works with WITHOUT ROWID tables. file: [6ffed0c5] check-in: [5771b1d6] user: dan branch: trunk, size: 223556
2017-11-26
02:14
Fix an CSV output quoting problem in the command-line shell on Windows. file: [c441d7dd] check-in: [6500cdbd] user: drh branch: trunk, size: 223554
2017-11-21
21:14
Fix compilation issue (C99-ism) in the shell seen with MSVC. file: [cb1b5e41] check-in: [9cb47430] user: mistachkin branch: trunk, size: 223578
2017-11-15
19:14
Futher improvements to the .testctrl interface in the shell. file: [a87f3094] check-in: [1ca3b8cc] user: drh branch: trunk, size: 223563
17:07
UI improvements on the .testctrl dot-command in the shell. file: [e261e3c2] check-in: [5d66219c] user: drh branch: trunk, size: 223981
2017-10-27
17:09
Handle the Ctrl-C event for the shell on Win32. file: [08cbffc3] check-in: [c8aaf371] user: mistachkin branch: trunk, size: 223352
2017-10-17
13:44
Fix the ".check" command of the command-line shell to return 1 (error) rather than 2 (exit) on a test failure. file: [f13262c8] check-in: [e2af0cc6] user: drh branch: trunk, size: 222915
2017-10-12
20:37
Add the sqlite_dbpage virtual table (enabled using SQLITE_ENABLE_DBPAGE_VTAB). Make that virtual table and dbstat available to the command-line shell. file: [5446de0a] check-in: [eaeeb09d] user: drh branch: trunk, size: 222915
10:28
Make sure the tableColumnList() routine of the command-line shell does not cause a null-pointer dereference in an error condition. file: [423944f4] check-in: [5d0ceb8d] user: drh branch: branch-3.21, size: 222773
2017-10-11
18:26
Add the checkfreelist extension to the command-line shell. file: [7842db26] check-in: [48418f2e] user: drh branch: dbpage, size: 222969
17:51
Convert the implementation of the ".dbstat" dot-command of the command-line shell to use the sqlite_dbpage table. file: [73d8000b] check-in: [497409e1] user: drh branch: dbpage, size: 222888
2017-10-05
19:12
Fix the command-line shell so that the ".schema --indent" command does a better job of dealing with \r\n in the middle of a CREATE statement in the schema. file: [e03f7d47] check-in: [4258fb57] user: drh branch: trunk, size: 222746
2017-09-13
18:38
Experimental sqlite3_stmt_retryable() interface. file: [30d6799f] check-in: [ebada072] user: drh branch: sqlite3_stmt_retryable, size: 223012
2017-09-09
00:51
Fix harmless compiler warnings seen with MSVC. file: [bb9720a8] check-in: [faa22e29] user: mistachkin branch: trunk, size: 222702
2017-08-28
17:26
Remove the rarely-used scratch memory allocator. This makes the code smaller, faster, and easier to maintain. In place of the scratch allocator, add the SQLITE_CONFIG_SMALL_MALLOC configuration option that provides a hint to SQLite that large memory allocations should be avoided. file: [6bd94bfe] check-in: [cc440400] user: drh branch: begin-concurrent-branch-3.19, size: 222631
15:51
Remove the rarely-used scratch memory allocator. This makes the code smaller, faster, and easier to maintain. In place of the scratch allocator, add the SQLITE_CONFIG_SMALL_MALLOC configuration option that provides a hint to SQLite that large memory allocations should be avoided. file: [af3fb9ea] check-in: [54b00024] user: drh branch: trunk, size: 222701
14:33
Backport changes to shell.c into shell.c.in. file: [31cd78c3] check-in: [2348045f] user: drh branch: trunk, size: 223870
2017-07-18
20:59
Fix shell.c.in so that it aligns with shell.c. file: [b5725aca] check-in: [505fdc8f] user: drh branch: trunk, size: 223800
2017-07-14
00:28
Fix harmless compiler warnings in the readline tab-completion logic of the command-line shell. file: [dae43a6a] check-in: [271ca4ac] user: drh branch: trunk, size: 223799
2017-07-11
18:11
Fix harmless compiler warnings in the core. file: [98bfdeeb] check-in: [55e93f25] user: drh branch: trunk, size: 223798
13:59
Add support for tab-completion (using the ext/misc/completion.c virtual table) to the command-line shell. file: [18510e3f] check-in: [95cd1d9f] user: drh branch: trunk, size: 223781
13:34
Change the src/shell.c file so that it is generated from a new script at tool/mkshellc.tcl and the template file src/shell.c.in, and automatically includes the extensions it needs out of ext/misc. file: [9d75c83c] check-in: [17e0bb12] user: drh branch: trunk, size: 221535 Added