/ File History
Login

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

History of tool/showdb.c

2019-04-17
13:23
In the "pgidx" report from "showdb", also show the number of rows on each database btree page. file: [97d14a1c] check-in: [2bda9dc4] user: drh branch: trunk, size: 32910
12:29
In the "pgidx" command of the showdb utility, try to identify orphaned pages and show when pages have been zeroed out. file: [b4cd49d8] check-in: [eed701ef] user: drh branch: trunk, size: 32709
2019-03-05
23:49
Fix a potential 32-bit integer overflow in the "showdb" utility program when it is trying to interpret a corrupt database file. file: [af978d14] check-in: [3803e750] user: drh branch: trunk, size: 32061
2017-03-16
13:14
Fix a problem in the "showdb" utility that prevents it from correctly decoding cells with no content beyond the record header. file: [e6bc9dba] check-in: [eb7680a1] user: drh branch: trunk, size: 32046
2016-04-12
20:05
More harmless compiler warning fixes. file: [c695a5d5] check-in: [ab69527c] user: mistachkin branch: warnings, size: 32045
2015-12-16
22:06
Fix some more harmless compiler warnings. file: [82dca79a] check-in: [18f531e1] user: mistachkin branch: msvcWarn, size: 32032
2015-10-29
13:48
Fix uses of ctype functions (ex: isspace()) on signed characters in test programs and in some obscure extensions. No changes to the core. file: [d4476e00] check-in: [34eb6911] user: drh branch: trunk, size: 32032
2015-08-04
15:29
Update the [showdb] program so that the database file is read directly (bypassing the SQLite VFS) only if the --raw option is specified. Otherwise, it is read using the default VFS. Also, the URI syntax may be used on the command line to specify the name of the database file to examine, so an alternative VFS may be requested using a URI parameter. file: [b1e16174] check-in: [e3c6d4b6] user: dan branch: trunk, size: 31938
15:23
Update the [showdb] program so that the database file is read directly (bypassing the SQLite VFS) only if the --raw option is specified. Otherwise, it is read using the default VFS. An alternative VFS may be specified by specifying the database file to open using the URI syntax. file: [95ed1720] check-in: [9699e9bd] user: dan branch: showdb-uri-option, size: 31934
2015-08-03
17:03
Add the "--uri" option to utility program "showdb". This option causes showdb to use sqlite with the SQLITE_OPEN_URI option to open the database file, instead of opening it directly using the OS open() function. file: [8b65966a] check-in: [90e34d51] user: dan branch: showdb-uri-option, size: 31892
2015-04-15
15:29
Enhance the showdb utility program so that it can read the last partial page of a truncated database file. file: [3b5d335d] check-in: [61d72e17] user: drh branch: trunk, size: 28840
2015-03-21
02:22
Improvements to the MSVC build. Fix harmless compiler warnings. Enable use of 'stdcall'. file: [63cdef19] check-in: [737630b8] user: mistachkin branch: trunk, size: 28786
2014-08-20
10:42
Fix a typo in the showdb usage message. file: [bd073a78] check-in: [6c66beae] user: dan branch: trunk, size: 28782
2014-07-19
15:40
Fix warnings related to having a 64-bit size_t. file: [b9ee6b6c] check-in: [29ac9336] user: mistachkin branch: toolWarnings, size: 28782
15:30
Fix warnings caused by the previous commit. file: [d7d354c5] check-in: [89634a41] user: mistachkin branch: toolWarnings, size: 28762
2014-07-18
21:16
Fix harmless compiler warnings for MSVC in the showdb/showwal command line tools. file: [3c78d10a] check-in: [6dc7b2f1] user: mistachkin branch: toolWarnings, size: 28765
2014-06-30
11:14
Add makefile targets for various diagnostic tools, such as showstat4. Fix harmless compiler warnings in diagnostic tools. file: [213e0288] check-in: [6f86d89b] user: drh branch: trunk, size: 28742
2014-06-20
13:55
Improved display of record data in the "NNNbd" output of the showdb.exe utility program. file: [b018a8a6] check-in: [f735c249] user: drh branch: trunk, size: 28678
01:32
In the showdb.exe utility, for the "NNNbd" command, also show data fields in addition to header fields on each record decoded. Improvements to formatting. file: [eef4bd98] check-in: [b451fe0c] user: drh branch: trunk, size: 28123
2014-06-19
23:38
Add the ability to decode the headers of individual cells, byte-by-byte, in the "showdb.exe" utility. file: [c080dea3] check-in: [306b461d] user: drh branch: trunk, size: 27047
2014-01-28
20:36
Fix harmless compiler warnings in the showdb utility program. file: [1f3fe634] check-in: [27c27daa] user: drh branch: trunk, size: 23053
2013-05-01
19:49
Allocate 4 bytes of unused header space for an "Application ID". Add the "PRAGMA application_id" command to set and query this identifier. Add the "magic.txt" file to show how the posix file command might use this application id. file: [525ecc44] check-in: [28c9e7fd] user: drh branch: application-id, size: 23065
2013-03-05
01:46
Simplified error message on the showdb utility. file: [acd24ea0] check-in: [8e0ced1a] user: drh branch: trunk, size: 23058
2013-02-19
22:26
Enhance the showdb tool with options to show PTRMAP usage and content. file: [16960a5c] check-in: [06bd9130] user: drh branch: trunk, size: 23073
20:25
Fix the showdb utility so that it displays the correct secondary usage of a page when reporting on an error of a page being used more than once. file: [2292b901] check-in: [4507f0b3] user: drh branch: trunk, size: 21058
18:45
Enhance the pgidx of the showdb utility so that it provides better information even if the sqlite_master table is corrupt. file: [8fa54c57] check-in: [d14263a7] user: drh branch: trunk, size: 21068
2012-10-13
09:31
Allow the showdb tool to be compiled with MSVC. file: [aca2644a] check-in: [dce391fc] user: mistachkin branch: trunk, size: 20813
2012-04-03
15:10
If the SELECT that finds all root pages in the showdb fails, then report an error. file: [2e28d8e4] check-in: [4b161415] user: drh branch: trunk, size: 20781
14:59
Enhance the "showdb" utility program with the "pgidx" option. Now requires linkage with the amalgamation. file: [9cdc4537] check-in: [4b573701] user: drh branch: trunk, size: 20702
2011-04-13
16:52
Fix a usage comment typo in the showdb utility. file: [43e913d9] check-in: [8744ced4] user: drh branch: trunk, size: 15027
2011-01-06
15:51
Enhance the showdb tool to show overflow page pointers at the end of overflow cells. file: [471c0f8f] check-in: [cda5eab1] user: drh branch: trunk, size: 15028
01:26
Enhance the showdb tool to show a btree page layout. Add limit checks so that overflow content does not overflow the buffer. file: [65c209d5] check-in: [57ffa07e] user: drh branch: trunk, size: 14773
2011-01-05
21:46
Fix a bug in the showdb utility: the serial types for BLOB and TEXT where reversed. file: [2f4d2092] check-in: [65a13faf] user: drh branch: trunk, size: 12952
21:20
Enhancements to the "showdb" debugging tool. Add the ability to display the content of a cell. file: [1496ea81] check-in: [e9023a4e] user: drh branch: trunk, size: 12947
2010-08-23
15:26
Update the "showdb" debug utility to handle 64K pages and with extra options to decode the freelist structure. file: [c7a978cf] check-in: [1070918e] user: drh branch: trunk, size: 10987
2010-06-17
02:13
Bug fix: Only trust the database size number at offset 28 if the change counter at offset 24 matches the version number counter at offset 92. This prevents corruption in the case of two applications writing to the database where one is an older version of SQLite and the other is a newer version. file: [01c20e81] check-in: [f80c3f92] user: drh branch: trunk, size: 8934
2010-04-26
17:30
Identify the SQLite version meta-value entry in the db-header output of showdb. file: [12fbece8] check-in: [245d934b] user: drh branch: trunk, size: 8909
16:47
Further enhancements to the showdb utility: A page number followed by "b" causes a btree decoding to occur on the page. file: [4ab96e7f] check-in: [2ff824e5] user: drh branch: trunk, size: 8896
15:44
Enhancements to the showdb.c utility program. Automatically detect the page size and adjust the display accordingly. Add the "dbheader" display option. file: [f36a0d62] check-in: [23eb408b] user: drh branch: trunk, size: 6546
2009-05-19
03:21
Update the showdb.c utility so that it works with databases larger than 4GiB. (CVS 6656) file: [8ab8b3b5] check-in: [9675b622] user: drh branch: trunk, size: 2000
2005-11-04
22:03
VACUUM works even on an empty database. Ticket #1512. (CVS 2760) file: [a086a3d7] check-in: [1b6bf418] user: drh branch: trunk, size: 1985
2002-07-06
16:32
Prepare for the 2.5.5 release. (CVS 661) file: [3559eac5] check-in: [00f83c25] user: drh branch: trunk, size: 1945 Added