It could be nice to include `bin/sqlite3_analyzer` (available from the sqlite download page) in the port, or in a different port (I think it depends on TCL). http://www.sqlite.org/sqlanalyze.html http://www.sqlite.org/download.html
Hello. In the distribution that is used for this port, there are no corresponding files. But, do not despair. You can use the new port. Look: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=220528 or their source https://github.com/pol73/sqlite-src Thanks.
Created attachment 215100 [details] proposed /usr/ports/databases/sqlite3_analyzer/Makefile
Created attachment 215101 [details] distinfo
Created attachment 215102 [details] pkg-descr
You can try to use linux binaries built via meta-port.
There's no need to use linux binaries for this. sqlite3 provides complete source tarball, sqlite-src-3340100.zip (as opposed to currently used sqlite-autoconf-3340100.tar.gz), which contain analyzer and a bunch of other stuff (such as tests). sqlite3 should probably be switched to it.
Created attachment 222490 [details] Patch A proposed patch to switch sqlite3 from sqlite-autoconf distfile to sqlite-src. Because of that, tcl is now required at buildtime, manpage needs to be installed manually, patch is no longer needed. Additionally, add TCL option which installs sqlite_analyzer and tcl extensions along the way. Also, switch to pkg-plist, PLIST_FILES this long is discouraged.