New ideas

Moving distfiles to a new filesystem & deleting unused distfiles

FreshPorts pulls down a lot of distfiles (the file distributed by the software author which contains the software). Much more than your average user. Every distfile for every commit is fetched. Let’s look at my private FreshPorts development instance: [13:18 dvl-ingress01 dvl /jails/freshports/usr/ports] % du -ch -d 0 distfiles 125G distfiles 125G total That’s 125GB. […]

Moving distfiles to a new filesystem & deleting unused distfiles Read More »

Using triggers to update a table with calculated values

This was originally written in September 2018, but never published (for unknown reasons). I found it in the drafts section of the website today. In this post, you will see me change approach and not use a secondary table in one instance, but use multiple secondary tables in another. In one case, you will also

Using triggers to update a table with calculated values Read More »

What ports are dependant upon this port?

An interesting discussion started earlier this week: upstream dependents. At present, FreshPorts captures and displays the information output from: make -V BUILD_DEPENDS -V RUN_DEPENDS -V LIB_DEPENDS For a given port, this tells up what that port depends upon for building, running, and libraries. The request is for this same information, but in the reverse ordering;

What ports are dependant upon this port? Read More »

Scroll to Top