The NetBSD Project

CVS log for pkgsrc/databases/sqlite3-diff/PLIST

[BACK] Up to [cvs.NetBSD.org] / pkgsrc / databases / sqlite3-diff

Request diff between arbitrary revisions


Keyword substitution: kv
Default branch: MAIN


Revision 1.1: download - view: text, markup, annotated - select for diffs
Tue May 20 16:46:24 2025 UTC (17 months, 3 weeks ago) by schmonz
Branches: MAIN
CVS tags: pkgsrc-2026Q3-base, pkgsrc-2026Q3, pkgsrc-2026Q2-base, pkgsrc-2026Q2, pkgsrc-2026Q1-base, pkgsrc-2026Q1, pkgsrc-2025Q4-base, pkgsrc-2025Q4, pkgsrc-2025Q3-base, pkgsrc-2025Q3, pkgsrc-2025Q2-base, pkgsrc-2025Q2, HEAD
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.

Diff request

This form allows you to request diffs between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

Log view options

CVSweb <webmaster@jp.NetBSD.org>