Bug 221735 - databases/sqlite3: could be nice to include sqlite3_analyzer
Summary: databases/sqlite3: could be nice to include sqlite3_analyzer
Status: New
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Only Me
Assignee: Dmitry Marakasov
URL:
Keywords:
Depends on: 220528
Blocks:
  Show dependency treegraph
 
Reported: 2017-08-23 09:04 UTC by Lapo Luchini
Modified: 2021-02-16 15:10 UTC (History)
3 users (show)

See Also:
bugzilla: maintainer-feedback? (pavelivolkov)


Attachments
proposed /usr/ports/databases/sqlite3_analyzer/Makefile (629 bytes, text/plain)
2020-05-31 12:25 UTC, a.milevsky
no flags Details
distinfo (186 bytes, text/plain)
2020-05-31 12:25 UTC, a.milevsky
no flags Details
pkg-descr (276 bytes, text/plain)
2020-05-31 12:25 UTC, a.milevsky
no flags Details
Patch (4.62 KB, patch)
2021-02-16 15:10 UTC, Dmitry Marakasov
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Lapo Luchini 2017-08-23 09:04:07 UTC
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
Comment 1 Pavel Volkov 2017-08-27 10:27:55 UTC
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.
Comment 2 a.milevsky 2020-05-31 12:25:06 UTC
Created attachment 215100 [details]
proposed /usr/ports/databases/sqlite3_analyzer/Makefile
Comment 3 a.milevsky 2020-05-31 12:25:32 UTC
Created attachment 215101 [details]
distinfo
Comment 4 a.milevsky 2020-05-31 12:25:50 UTC
Created attachment 215102 [details]
pkg-descr
Comment 5 a.milevsky 2020-05-31 12:26:51 UTC
You can try to use linux binaries built via meta-port.
Comment 6 Dmitry Marakasov freebsd_committer 2021-02-16 15:06:34 UTC
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.
Comment 7 Dmitry Marakasov freebsd_committer 2021-02-16 15:10:37 UTC
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.