Databases use relational integrity to enforce expected situations. A common scenario is duplicates. Case in point, I present the port_dependencies table: For those not familiar with FreeBSD ports, each port (you could also refer to them as a package or application) can have zero or more dependencies. The FreshPorts database extracts and lists these dependencies […]
Duplicate dependency issues – avoiding duplicate rows Read More »
Jochen Neumeister noticed that FreshPorts no longer lists phpunit6. see also https://github.com/FreshPorts/freshports/issues/72. Sure enough, I went searching and failed to find it. It did not turn up. Then I checked Include deleted ports, then clicked on Search again. Ahh, there it it. Sure enough, it is marked as deleted. Look for the small icon at
Where did phpunit6 go? Read More »
For several weeks, FreshPorts had a vuxml processing problem. In this blog post, I will share what I found. Introduction Incoming events for FreshPorts are handled by a small Python script which checks for flags and incoming commits. This ensures that work is carried out serially because parallel work can have unintended consequences. After each
Details of the vuxml processing problem Read More »
The previous post on this blog was nearly 10 months ago. However, things have not stood still. There have been a few issues fixed and some are still in progress. The biggest thing underway is a major rework of the backend, the part that processes the incoming commits. There is nothing major; no huge code
Redesign of FreshPorts backend Read More »
Tonight, I was contacted by jrm on IRC, who told me that FreshPorts was missing something on a search. Yep. It was not in there. I looked on dev and I saw the same thing. Finding the cause I started by enabling debug on dev. I found this SQL: I started by removing one LEFT
Where is en-aspell? Read More »
Committing to a branch (e.g. 2016Q4) when the port in question has slave ports is getting tricky, especially if the port was added after the branch was created. Case in point, www/linux-c7-flashplugin11 was added to the tree on 19 Oct 2016. The 2016Q4 branch was created on 3 Oct, and therefore that port does not
Committing to a branch when there are slave ports Read More »
$ grep -c 142.217.121.133 /usr/websites/log/freshports.org-access.log.0 72446
Hey 142.217.121.133, what are you doing? Read More »
I was asked if this was a known bug. It’s not. I don’t think anyone knows about it. dvl: ping. FreshPorts truncates COMMENT. Known issue? https://www.freshports.org/devel/include-what-you-use/ Here’s what I found there: Tool for use with clang to analyze Here is what the Makefile contains: $ grep COMMENT Makefile COMMENT= Tool for use with clang to
It’s not me. It’s you. Read More »
FreshPorts uses a cache for every port page (e.g. https://www.freshports.org/sysutils/bacula-server/). When an update to a port occurs, we must clear the cache for that port. This sounds simple, and it is. The various ways in which updates occur complicates the situation. This post is all about fixing one edge case: the addition or removal of
When dependencies change, both ports need to be updated Read More »
Recently, I’ve been adding more and more file content into the database, mostly because it’s useful. For example, we add the contents of the distinfo, because that information is useful. Next, it was pkg-plist, and before I was done that, someone suggested added in the Makefile. Neither pkg-plist nor Makefile will be perfect: Not all
Adding Makefile and pkg-plist to the mix Read More »