The dbhash.exe Utility Program

The dbhash.exe Utility Program

1. Overview

The dbhash (or dbhash.exe on Windows) utility is a command-line program that computes the SHA1 hash of the schema and content for an SQLite database.

Dbhash ignores extraneous formatting details and hashes only the database schema and content. Hence the hash is constant even if the database file is modified by:

• VACUUM
• PRAGMA page_size
• PRAGMA journal_mode
• REINDEX
• ANALYZE
• copied via the backup API
• ... and so forth

The operations above can potentially cause vast changes the raw database file, and hence cause very different S