According to the sqlite site, https://www.sqlite.org/sqldiff.html `sqldiff` should be part of the sqlite. However, I have sqlite on my FreeBSD box (13.0p8) yet it doesn't seem to include sqldiff, nor do I see sqldiff as its own package $ for p in sqlite{,3} ; do pkg info $p | head -3 ; done sqlite-2.8.17_5 Name : sqlite Version : 2.8.17_5 sqlite3-3.37.2,1 Name : sqlite3 Version : 3.37.2,1 $ pkg search sqldiff || echo nope nope $ find /usr/local -name 'sqldiff*' 2>/dev/null # no results $ which sqldiff || echo nope nope I'm not sure what's required to either include this as part of the sqlite package, or to make it its own stand-alone package, but I was encouraged to report it here: https://twitter.com/FreeBSDHelp/status/1524174819742212096 so here's a bug-tracker entry to do so.
Thank you for the report Tim!
Created attachment 234054 [details] Patch to add sqldiff This patch will add sqldiff to the package. Some other tools (as sqlite3_analyzer) are added depending on the TCL option. Some Linux distributions provide a sqlite3-tools package that provides all this tools separately. sqlite web page itself has a binary package for precisely this (https://sqlite.org/2022/sqlite-tools-linux-x86-3380500.zip) I honestly would not bother to create just another package in this case. It makes sense to have sqldiff shipped with the normal package.
(In reply to Fernando Apesteguía from comment #2) Hello. This patch has been taken into account when updating the port to the new version. (https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=264173) Thank you.
Done in bug #264173