Path to this page:
./
databases/sqlite3-diff,
Display content differences between SQLite databases
Branch: CURRENT,
Version: 3.49.2,
Package name: sqlite3-diff-3.49.2,
Maintainer: schmonzsqldiff is a command-line utility program that displays content
differences between SQLite databases. The usual output is an SQL script
that will transform the source database into the destination database.
The sqldiff utility works by finding rows in the source and destination
that are logical "pairs". The default behavior is to treat two rows as
pairs if they are in tables with the same name and they have the same
rowid, or in the case of a WITHOUT ROWID table if they have the same
PRIMARY KEY. Any differences in the content of paired rows are output as
UPDATEs. Rows in the source database that could not be paired are output
as DELETEs. Rows in the destination database that could not be paired
are output as INSERTs.
Master sites:
Filesize: 14040.73 KB
Version history: (Expand)
- (2025-05-20) Package added to pkgsrc.se, version sqlite3-diff-3.49.2 (created)
CVS history: (Expand)
2025-05-20 18:46:24 by Amitai Schleier | Files touched by this commit (4) |
Log message:
Add sqlite3-diff: Display content differences between SQLite databases
sqldiff is a command-line utility program that displays content
differences between SQLite databases. The usual output is an SQL script
that will transform the source database into the destination database.
The sqldiff utility works by finding rows in the source and destination
that are logical "pairs". The default behavior is to treat two rows as
pairs if they are in tables with the same name and they have the same
rowid, or in the case of a WITHOUT ROWID table if they have the same
PRIMARY KEY. Any differences in the content of paired rows are output as
UPDATEs. Rows in the source database that could not be paired are output
as DELETEs. Rows in the destination database that could not be paired
are output as INSERTs.
|