Description:
Displays the differences between SQLite databases
|
|
Type: Formula
|
Latest Version: 3.51.3@0
|
Tracked Since: Dec 28, 2025
|
|
Links:
Homepage |
formulae.brew.sh
|
|
Category: Databases
|
|
Tags:
sqlite
diff
database
cli
synchronization
|
|
Install:
brew install sqldiff
|
About:
Sqldiff is a command-line utility that compares two SQLite database files and outputs the differences in SQL. It can generate SQL INSERT, UPDATE, or DELETE statements to transform one database into another. This is highly useful for synchronizing databases or debugging data discrepancies.
|
Key Features:
- Compares schema and data between two SQLite databases
- Outputs standard SQL statements for easy application
- Can output data differences in CSV format
- Part of the official SQLite toolset
|
Use Cases:
- Synchronizing a development database with a production database
- Debugging why two databases contain different data
- Generating incremental update scripts for an application
|
Alternatives:
-
sqldiff (Python)
– A different Python-based tool for diffing SQL files, not specifically optimized for SQLite internals.
|
| Detected |
Version |
Rev |
Change |
Commit |
| Mar 16, 2026 10:17am |
3.51.3 |
0 |
VERSION_BUMP |
8375e258 |
| Mar 11, 2026 1:41pm |
3.52.0 |
0 |
VERSION_BUMP |
fd4270c9 |
| Jan 9, 2026 9:59pm |
3.51.2 |
0 |
VERSION_BUMP |
9255ddb1 |
| Sep 15, 2025 12:04pm |
3.50.4 |
0 |
VERSION_BUMP |
2aa7ee05 |
| Oct 23, 2024 10:21am |
3.47.0 |
0 |
VERSION_BUMP |
77488925 |
| Aug 15, 2024 9:07pm |
3.46.1 |
0 |
VERSION_BUMP |
a6a9a76b |
| Apr 16, 2024 10:21pm |
3.45.3 |
0 |
VERSION_BUMP |
e6d04dd9 |
| Jan 30, 2024 8:23pm |
3.45.1 |
0 |
VERSION_BUMP |
ba5c3f4f |
| Jan 15, 2024 7:02pm |
3.45.0 |
0 |
VERSION_BUMP |
11edf079 |
| Nov 28, 2023 12:49am |
3.44.2 |
0 |
VERSION_BUMP |
b069503a |
| Nov 26, 2023 12:47am |
3.44.1 |
0 |
VERSION_BUMP |
9587dc46 |
| Nov 26, 2023 12:04am |
3.44.0 |
0 |
VERSION_BUMP |
4a6e8766 |
| Nov 25, 2023 7:21pm |
3.44.1 |
0 |
VERSION_BUMP |
4dee147f |
| Nov 3, 2023 6:19pm |
3.44.0 |
0 |
VERSION_BUMP |
c1a24924 |
| Sep 25, 2023 2:03am |
3.43.1 |
0 |
VERSION_BUMP |
2b185c70 |
| May 17, 2023 1:03am |
3.42.0 |
0 |
VERSION_BUMP |
e892635a |
|