SQLite

All files named ”tool/showdb.c”
Login

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

History for tool/showdb.c

2025-02-12
20:19
[3956d71e51] part of check-in [9377766647] Fix a few 32-bit overflow problems in showdb.c. (check-in: [9377766647] user: dan branch: trunk, size: 34446)
2024-09-13
11:14
[81b04bfaa9] part of check-in [4cad385b90] Further enhancement to PTRMAP display in showdb: Show the details of invalid entries that are within the range of the database file. Continue to ignore invalid entries beyond the end of the database file. (check-in: [4cad385b90] user: drh branch: trunk, size: 34429)
2024-09-12
21:58
[14215f764f] part of check-in [a9f95fe5ce] Enhancement to the "showdb" utility such that the "ptrmap" command shows PTRMAP entries that extend off the end of the database, as long as they appear to be well-formatted. (check-in: [a9f95fe5ce] user: drh branch: trunk, size: 34282)
2023-09-14
14:05
[0f74b54cc6] part of check-in [6bf3e90687] Avoid a segfault in test program showdb.c that could occur when analyzing a corrupt db. (check-in: [6bf3e90687] user: dan branch: trunk, size: 34134)
2023-02-03
12:03
[495a43b759] part of check-in [75cdaafc77] Improved detection of invalid command-line arguments to the showdb and showwal debugging utility programs. (check-in: [75cdaafc77] user: drh branch: trunk, size: 33992)
2021-12-31
18:26
[72239e95e1] part of check-in [a9bfb62109] Fix harmless compiler warnings seen with MSVC. (check-in: [a9bfb62109] user: mistachkin branch: trunk, size: 33618)
2021-06-16
13:26
[7cc12c6dee] part of check-in [f8d7ac0104] Avoid ominous warning in showdb.c (check-in: [f8d7ac0104] user: larrybr branch: trunk, size: 33608)
2021-06-08
17:56
[6554d4af76] part of check-in [e3188a8663] Try to avoid a double-free in the showdb utility program when running pgidx on a corrupt database. See forum post a60ea5a4d4 for context (check-in: [e3188a8663] user: drh branch: trunk, size: 33608)
2021-04-27
00:05
[8c6b1cbb86] part of check-in [7e18e114b2] Better error messages on showdb. (check-in: [7e18e114b2] user: drh branch: trunk, size: 33574)
2021-04-26
23:57
[d99bd18f83] part of check-in [3eabac2ee5] Improved robustness of the "showdb" debugging program when it is parsing corrupt database files. (check-in: [3eabac2ee5] user: drh branch: trunk, size: 33544)
2020-07-22
11:42
[49e810f5c4] part of check-in [a8200327d4] Enhance showdb to be 32-bit clean. (check-in: [a8200327d4] user: drh branch: larger-databases, size: 33274)
2020-06-19
15:24
[cdf631fe4c] part of check-in [7a876209a6] Extend the refactoring into extensions. Clean up stray newlines. (check-in: [7a876209a6] user: drh branch: trunk, size: 32922)
2020-01-14
13:24
[9b2dbb4b7a] part of check-in [9ce2192b81] For the showdb utility program, more accurate detection of when the database is in autovacuum mode for the "pgidx" subcommand. (check-in: [9ce2192b81] user: drh branch: trunk, size: 32922)
2019-04-17
13:23
[97d14a1ce3] part of check-in [2bda9dc41c] In the "pgidx" report from "showdb", also show the number of rows on each database btree page. (check-in: [2bda9dc41c] user: drh branch: trunk, size: 32910)
12:29
[b4cd49d8f4] part of check-in [eed701ef91] In the "pgidx" command of the showdb utility, try to identify orphaned pages and show when pages have been zeroed out. (check-in: [eed701ef91] user: drh branch: trunk, size: 32709)
2019-03-05
23:49
[af978d1437] part of check-in [3803e75038] Fix a potential 32-bit integer overflow in the "showdb" utility program when it is trying to interpret a corrupt database file. (check-in: [3803e75038] user: drh branch: trunk, size: 32061)
2017-03-16
13:14
[e6bc9dba23] part of check-in [eb7680a1c0] Fix a problem in the "showdb" utility that prevents it from correctly decoding cells with no content beyond the record header. (check-in: [eb7680a1c0] user: drh branch: trunk, size: 32046)
2016-04-12
20:05
[c695a5d5c8] part of check-in [ab69527c16] More harmless compiler warning fixes. (check-in: [ab69527c16] user: mistachkin branch: warnings, size: 32045)
2015-12-16
22:06
[82dca79a99] part of check-in [18f531e1cf] Fix some more harmless compiler warnings. (check-in: [18f531e1cf] user: mistachkin branch: msvcWarn, size: 32032)
2015-10-29
13:48
[d4476e000a] part of check-in [34eb6911af] Fix uses of ctype functions (ex: isspace()) on signed characters in test programs and in some obscure extensions. No changes to the core. (check-in: [34eb6911af] user: drh branch: trunk, size: 32032)
2015-08-04
15:29
[b1e1617438] part of check-in [e3c6d4b6e7] 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. (check-in: [e3c6d4b6e7] user: dan branch: trunk, size: 31938)
15:23
[95ed172060] part of check-in [9699e9bd9a] 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. (check-in: [9699e9bd9a] user: dan branch: showdb-uri-option, size: 31934)
2015-08-03
17:03
[8b65966a80] part of check-in [90e34d5119] 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. (check-in: [90e34d5119] user: dan branch: showdb-uri-option, size: 31892)
2015-04-15
15:29
[3b5d335d53] part of check-in [61d72e1791] Enhance the showdb utility program so that it can read the last partial page of a truncated database file. (check-in: [61d72e1791] user: drh branch: trunk, size: 28840)
2015-03-21
02:22
[63cdef19e7] part of check-in [737630b873] Improvements to the MSVC build. Fix harmless compiler warnings. Enable use of 'stdcall'. (check-in: [737630b873] user: mistachkin branch: trunk, size: 28786)
2014-08-20
10:42
[bd073a78bc] part of check-in [6c66beae97] Fix a typo in the showdb usage message. (check-in: [6c66beae97] user: dan branch: trunk, size: 28782)
2014-07-19
15:40
[b9ee6b6c81] part of check-in [29ac9336db] Fix warnings related to having a 64-bit size_t. (check-in: [29ac9336db] user: mistachkin branch: toolWarnings, size: 28782)
15:30
[d7d354c52f] part of check-in [89634a419d] Fix warnings caused by the previous commit. (check-in: [89634a419d] user: mistachkin branch: toolWarnings, size: 28762)
2014-07-18
21:16
[3c78d10af9] part of check-in [6dc7b2f119] Fix harmless compiler warnings for MSVC in the showdb/showwal command line tools. (check-in: [6dc7b2f119] user: mistachkin branch: toolWarnings, size: 28765)
2014-06-30
11:14
[213e028850] part of check-in [6f86d89b88] Add makefile targets for various diagnostic tools, such as showstat4. Fix harmless compiler warnings in diagnostic tools. (check-in: [6f86d89b88] user: drh branch: trunk, size: 28742)
2014-06-20
13:55
[b018a8a69d] part of check-in [f735c2497e] Improved display of record data in the "NNNbd" output of the showdb.exe utility program. (check-in: [f735c2497e] user: drh branch: trunk, size: 28678)
01:32
[eef4bd98ba] part of check-in [b451fe0cb9] 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. (check-in: [b451fe0cb9] user: drh branch: trunk, size: 28123)
2014-06-19
23:38
[c080dea3ad] part of check-in [306b461d7c] Add the ability to decode the headers of individual cells, byte-by-byte, in the "showdb.exe" utility. (check-in: [306b461d7c] user: drh branch: trunk, size: 27047)
2014-01-28
20:36
[1f3fe634d6] part of check-in [27c27daa33] Fix harmless compiler warnings in the showdb utility program. (check-in: [27c27daa33] user: drh branch: trunk, size: 23053)
2013-05-01
19:49
[525ecc4435] part of check-in [28c9e7fdee] 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. (check-in: [28c9e7fdee] user: drh branch: application-id, size: 23065)
2013-03-05
01:46
[acd24ea035] part of check-in [8e0ced1af7] Simplified error message on the showdb utility. (check-in: [8e0ced1af7] user: drh branch: trunk, size: 23058)
2013-02-19
22:26
[16960a5ce5] part of check-in [06bd91305e] Enhance the showdb tool with options to show PTRMAP usage and content. (check-in: [06bd91305e] user: drh branch: trunk, size: 23073)
20:25
[2292b90184] part of check-in [4507f0b3d4] 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. (check-in: [4507f0b3d4] user: drh branch: trunk, size: 21058)
18:45
[8fa54c57cd] part of check-in [d14263a719] Enhance the pgidx of the showdb utility so that it provides better information even if the sqlite_master table is corrupt. (check-in: [d14263a719] user: drh branch: trunk, size: 21068)
2012-10-13
09:31
[aca2644aa4] part of check-in [dce391fc63] Allow the showdb tool to be compiled with MSVC. (check-in: [dce391fc63] user: mistachkin branch: trunk, size: 20813)
2012-04-03
15:10
[2e28d8e499] part of check-in [4b16141501] If the SELECT that finds all root pages in the showdb fails, then report an error. (check-in: [4b16141501] user: drh branch: trunk, size: 20781)
14:59
[9cdc45377f] part of check-in [4b5737014c] Enhance the "showdb" utility program with the "pgidx" option. Now requires linkage with the amalgamation. (check-in: [4b5737014c] user: drh branch: trunk, size: 20702)
2011-04-13
16:52
[43e913d954] part of check-in [8744ced4ec] Fix a usage comment typo in the showdb utility. (check-in: [8744ced4ec] user: drh branch: trunk, size: 15027)
2011-01-06
15:51
[471c0f8fa4] part of check-in [cda5eab18f] Enhance the showdb tool to show overflow page pointers at the end of overflow cells. (check-in: [cda5eab18f] user: drh branch: trunk, size: 15028)
01:26
[65c209d59a] part of check-in [57ffa07e26] Enhance the showdb tool to show a btree page layout. Add limit checks so that overflow content does not overflow the buffer. (check-in: [57ffa07e26] user: drh branch: trunk, size: 14773)
2011-01-05
21:46
[2f4d20922d] part of check-in [65a13faf1e] Fix a bug in the showdb utility: the serial types for BLOB and TEXT where reversed. (check-in: [65a13faf1e] user: drh branch: trunk, size: 12952)
21:20
[1496ea81d2] part of check-in [e9023a4e1e] Enhancements to the "showdb" debugging tool. Add the ability to display the content of a cell. (check-in: [e9023a4e1e] user: drh branch: trunk, size: 12947)
2010-08-23
15:26
[c7a978cf52] part of check-in [1070918e3b] Update the "showdb" debug utility to handle 64K pages and with extra options to decode the freelist structure. (check-in: [1070918e3b] user: drh branch: trunk, size: 10987)
2010-06-17
02:13
[01c20e8181] part of check-in [f80c3f922a] 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. (check-in: [f80c3f922a] user: drh branch: trunk, size: 8934)
2010-04-26
17:30
[12fbece856] part of check-in [245d934b72] Identify the SQLite version meta-value entry in the db-header output of showdb. (check-in: [245d934b72] user: drh branch: trunk, size: 8909)
16:47
[4ab96e7f50] part of check-in [2ff824e58c] Further enhancements to the showdb utility: A page number followed by "b" causes a btree decoding to occur on the page. (check-in: [2ff824e58c] user: drh branch: trunk, size: 8896)
15:44
[f36a0d6250] part of check-in [23eb408b5d] Enhancements to the showdb.c utility program. Automatically detect the page size and adjust the display accordingly. Add the "dbheader" display option. (check-in: [23eb408b5d] user: drh branch: trunk, size: 6546)
2009-05-19
03:21
[8ab8b3b538] part of check-in [9675b62236] Update the showdb.c utility so that it works with databases larger than 4GiB. (CVS 6656) (check-in: [9675b62236] user: drh branch: trunk, size: 2000)
2005-11-04
22:03
[a086a3d788] part of check-in [1b6bf4188e] VACUUM works even on an empty database. Ticket #1512. (CVS 2760) (check-in: [1b6bf4188e] user: drh branch: trunk, size: 1985)
2002-07-06
16:32
Added: [3559eac5a3] part of check-in [00f83c2576] Prepare for the 2.5.5 release. (CVS 661) (check-in: [00f83c2576] user: drh branch: trunk, size: 1945)