Default sqlite3 package lacks sqldiff

[huangsijun17]

I need the sqlidiff command of sqlite3 to analyze differences between multiple sqlite3 database files. However, the sqlite3(-devel) package in openSUSE Leap 15.6 does not include the sqldiff command by default. I noticed that the version of sqlite3 in the package is 3.50.3, dated 2025-07-17 13:25:10, while the official version includes the sqldiff command. I would like to inquire about the reason for removing this component during compilation and hope that the SUSE compiled version can include it.And I would like to ask, how can I find out which community version includes this command?

❯ sqlite3  --version
3.50.3 2025-07-17 13:25:10 3ce993b8657d6d9deda380a93cdd6404a8c8ba1b185b2bc423703e41ae5falt1 (64-bit)

[marel]

Hi, Welcome to the forum.

On how the sqlite3 build package is build see:

Embeddable SQL Database Engine

In the sqlite3.spec file you can find the commands that are executed to make the build and no, sqldiff is not excluded.

Under Compiling for Unix-like systems you can find that one has to build sqldiff separately, so to make it available that step should be added.