Debian Codegraph @

www/dbhash.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>The dbhash.exe Utility Program</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 <div class=fancy>
119 <div class=nosearch>
120 <div class="fancy_title">
121 The dbhash.exe Utility Program
122 </div>
123 </div>
124
125
126
127
128 <h1 id="overview"><span>1. </span>Overview</h1>
129
130 <p>The <b>dbhash</b> (or <b>dbhash.exe</b> on Windows) utility is a
131 command-line program that computes the SHA1 hash of the schema and content
132 for an SQLite database.
133
134 </p><p>Dbhash ignores extraneous formatting details and hashes only the database
135 schema and content. Hence the hash is constant even if the database file
136 is modified by:
137
138 </p><ul>
139 <li> <a href="lang_vacuum.html">VACUUM</a>
140 </li><li> <a href="pragma.html#pragma_page_size">PRAGMA page_size</a>
141 </li><li> <a href="pragma.html#pragma_journal_mode">PRAGMA journal_mode</a>
142 </li><li> <a href="lang_reindex.html">REINDEX</a>
143 </li><li> <a href="lang_analyze.html">ANALYZE</a>
144 </li><li> copied via the <a href="backup.html">backup API</a>
145 </li><li> ... and so forth
146 </li></ul>
147
148 <p>The operations above can potentially cause vast changes in the raw database
149 file, and hence cause very different SHA1 hashes at the file level.
150 But since the content represented in the database file is unchanged by these
151 operations, the hash computed by dbhash is also unchanged.
152
153 </p><p>Dbhash can be used to compare two databases to confirm that they
154 are equivalent, even though their representation on disk is quite different.
155 Dbhash might also be used to verify the content of a remote database without having
156 to transmit the entire content of the remote database over a slow link.
157
158 </p><h1 id="usage"><span>2. </span>Usage</h1>
159
160 <p>Dbhash is a command-line utility.
161 To run it, type "dbhash" on a command-line prompt followed by the names of
162 one or more SQLite database files that are to be hashed.
163 The database hashes will be displayed on standard output.
164 For example:
165
166 </p><div class="codeblock"><pre>drh@bella:~/sqlite/bld$ dbhash ~/Fossils/sqlite.fossil
167 8d3da9ff87196312aaa33076627ccb7943ef79e3 /home/drh/Fossils/sqlite.fossil
168 </pre></div>
169
170 <p>Dbhash supports command-line options that can restrict the tables of the
171 database file that are hashed, or restrict the hash to only content or only
172 the schema. Run "dbhash --help" for further information.
173
174 </p><h1 id="building"><span>3. </span>Building</h1>
175
176 <p>To build a copy of the dbhash utility program on unix, get a copy of the
177 canonical SQLite source code and enter:
178
179 </p><div class="codeblock"><pre>./configure
180 make dbhash
181 </pre></div>
182
183 <p>On Windows, enter:
184
185 </p><div class="codeblock"><pre>nmake /f makefile.msc dbhash.exe
186 </pre></div>
187
188 <p>The dbhash program is implemented by a single file of C-code
189 called <a href="https://sqlite.org/src/artifact?ci=trunk&filename=tool/dbhash.c">dbhash.c</a>.
190 To build the dbhash program manually, simply compile the dbhash.c source file
191 and link it against the SQLite library.
192 </p><p align="center"><small><i>This page was last updated on 2025-05-31 13:08:22Z </small></i></p>
193