Description:
Computes the SHA1 hash of schema and content of a SQLite database
|
|
Type: Formula
|
Latest Version: 3.51.3@0
|
Tracked Since: Dec 17, 2025
|
|
Links:
Homepage |
formulae.brew.sh
|
|
Category: Databases
|
|
Tags:
sqlite
hashing
database
integrity
cli
verification
|
|
Install:
brew install dbhash
|
About:
dbhash is a command-line utility included with SQLite that computes the SHA1 hash of both the schema and the content of a SQLite database file. This creates a unique fingerprint that accurately reflects the database's structure and data state. It is particularly useful for verifying database integrity, detecting changes, and comparing different versions of a database.
|
Key Features:
- Computes SHA1 hash of database schema and content
- Provides a single fingerprint for the entire database state
- Simple command-line interface for easy scripting and automation
- Helps in detecting accidental or unauthorized changes to a database
|
Use Cases:
- Verifying database integrity after migrations or backups
- Comparing two databases to ensure they contain identical data and schema
- Generating a unique version identifier for a database snapshot
|
Alternatives:
-
sha1sum
– Hashes the raw database file bytes, which can change even if logical content is identical due to internal SQLite formatting.
-
checksum
– A generic utility for file integrity, but not aware of SQLite's internal structure.
|
|
License: blessing
|
|
Bottles available for: arm64_tahoe, arm64_sequoia, arm64_sonoma, tahoe, sequoia, sonoma, arm64_linux, x86_64_linux
|
| Detected |
Version |
Rev |
Change |
Commit |
| Mar 16, 2026 10:16am |
3.51.3 |
0 |
VERSION_BUMP |
731c1823 |
| Mar 11, 2026 1:41pm |
3.52.0 |
0 |
VERSION_BUMP |
6be6e931 |
| Jan 9, 2026 9:59pm |
3.51.2 |
0 |
VERSION_BUMP |
0d1749fd |
| Sep 15, 2025 6:38am |
3.50.4 |
0 |
VERSION_BUMP |
7bacdd4c |
| Oct 23, 2024 10:21am |
3.47.0 |
0 |
VERSION_BUMP |
b7938799 |
| Sep 11, 2024 7:41pm |
3.46.1 |
0 |
VERSION_BUMP |
0f6d2420 |
| Aug 15, 2024 9:07pm |
3.46.1 |
0 |
VERSION_BUMP |
9bfdf643 |
| Apr 16, 2024 11:12pm |
3.45.3 |
0 |
VERSION_BUMP |
e5340d5f |
| Apr 16, 2024 10:21pm |
3.45.3 |
0 |
VERSION_BUMP |
255a236c |
| Jan 30, 2024 8:23pm |
3.45.1 |
0 |
VERSION_BUMP |
5f65ecf7 |
| Jan 15, 2024 7:02pm |
3.45.0 |
0 |
VERSION_BUMP |
4ecc962a |
| Nov 26, 2023 12:47am |
3.44.1 |
0 |
VERSION_BUMP |
22144187 |
| Nov 26, 2023 12:04am |
3.44.0 |
0 |
VERSION_BUMP |
afc8c7d5 |
| Nov 25, 2023 7:21pm |
3.44.1 |
0 |
VERSION_BUMP |
a72782da |
| Nov 3, 2023 6:19pm |
3.44.0 |
0 |
VERSION_BUMP |
a9350ce5 |
| Oct 1, 2023 6:02am |
3.43.1 |
0 |
VERSION_BUMP |
a982e16a |
| May 17, 2023 1:03am |
3.42.0 |
0 |
VERSION_BUMP |
bb0ee471 |
|