portsview

Portsview is a Ruby CGI script to query the OpenBSD sqlports database.

The port is here: portsview.tar.gz

To use it you need to enable httpd and install ruby, mod_ruby, ruby-sqlite3, sqlports, and sqlite3. The port also needs man2web during installation. The required packages are all expressed as dependencies in the port provided. However, note that mod_ruby must be explicitly enabled, as must httpd as well.

Then browse to

	http://localhost/cgi-bin/portsview

Features of portsview:

• Query by package name or keyword.
• Drill-down by package category.
• Displays either a brief or full desciption of the port's build parameters
• Hyperlinks to dependent or referenced packages.
• Hyperlinks to bsd.port.mk definition of Makefile parameters.
• Hyperlinks to system libs and port specific libs.

Screenshots

• top-level query
• category drill-down
• port detail

Installation Notes

During installation portsview extends the sqlports schema with two new tables and an new column. These extensions enable the ruby script to distinguish between /usr/lib system libraries, X windows libraries, and other port library dependencies. It takes some time to initialize them. However pkg_add does not report progress in realtime. So don't give up when it looks like pkg_add is hung.

Tested on i386 and amd64.

Fred Druseikis (fredd at cse dot sc dot edu)

June 3, 2007