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 »
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 »
Marie Helene asked a very good question: Does the “for run” dependency list only list direct dependencies, or depends of depends too? The answer is yes, only direct dependencies, but all the information is there to provide a complete list of all dependencies. The table looks like this: Here is the list of dependencies for
DEPENDS – direct or recursive? Read More »