BSD Ports

databases/sqlite3-diff 3.53.4 NetBSD

Display content differences between SQLite databases

System
NetBSD
Repository
pkgsrc
Maintainer
[email protected]
Last update
Commit
f041ebb2a2
License
public-domain
Categories
databases
Package size
462.9 KiB, 1051.1 KiB installed

Description

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.

Install

Binary package:

pkgin install sqlite3-diff

From pkgsrc:

cd /usr/pkgsrc/databases/sqlite3-diff && make install clean

Dependencies

Required by 1

Commit history 3

DateCommitCreditsLog message
f041ebb2a2 adam sqlite3: updated to 3.54.1
3.54.1 (2026-10-16): Fix a possible heap-buffer overflow on 32-bit builds. (64-bit builds are not affected by this problem.) Fixes other problems in 3.54.0 reported by users. See the check-in timeline for details.
907887a37a adam sqlite3: updated to 3.54.0
3.54.0 CLI enhancements: CLI prompt strings may contain escape sequences that expand to show state information. The initial CLI prompt is now be initialized the values of the SQLITE_PS1 and SQLITE_PS2 environment variables, if those variables exist. The default CLI prompt has been enhanced to take advantage of the new escape sequences described in the previous. For columnar output modes, the CLI now shows the column name header by default even if the query returns no rows. Use the new diskused() extension to implement the ".diskused" dot-command. The replaces the separate sqlite3_analyzer utility program, which is now deprecated. On unix, the CLI preserves zero bytes when outputing unformatted BLOB values. …
3d1e6729e3 adam sqlite3: updated to 3.53.4
3.53.4 (2026-07-24): Fixes for problems in 3.53.0 (and 3.53.1, 3.53.2, and 3.53.3) mostly coming from AIs. See the check-in timeline for details.