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 »
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 »
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 »
About two weeks ago, I wrote a function for creating a port. This will take the port from head and copy it to a branch. This is vital because of the reasons discussed here: creating a new port and copying a port from head to a branch. This function worked and was useful, but it
New function for creating a port Read More »
See the issue raised here. On 1 April 2016, we had some large commits (you can see them all here). This ground the front page to a halt. But as you can see, that link above loads rather quickly. Why? At first, I thought it was because the date-based page was caching the results. I
Improving the home page query Read More »
A great feature of FreshPorts is the ability to see all the ports which are dependent upon a given port. For example, it allows you to see what ports depend upon security/polarssl. This list is stored in a the port_dependencies table, which looks like this: This information is gathered when a port is updated. The
Display the updated dependencies when a dependent port updates Read More »
FreshPorts is a tender beast. It is both massive and sensitive. One example of that sensitivity came to light today. Jeffrey Bouquet wrote in to tell me of a problem with paths on FreshSource (our sister website, which displays more, but less). The problem has been corrected, but I took screen shots to illustrate this
hostname change causes missing links and pathnames Read More »
mandree reported a problem with security/openvpn-auth-ldap. Looking in the database: Looking at the database, the webpage is displaying what is there: Let’s looking at that commit in the database: OK, that’s not the commit which changed the BROKEN flag. Let’s look at that commit: The the date_added fields? These commits were processed out of order.
Today I noticed a bug with the recently added Fetch, Patch, and Extract dependencies. The are correctly displayed on the port page, but not on the dependent port page. The problem If you look at sysutils/libchk, you will see lang/ruby20 listed under Extract dependencies. However, at lang/ruby20, there is no mention of Patch, Fetch, or
bug with Fetch, Patch, and Extract dependencies Read More »