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 »
Yesterday, I wrote about some great progress on getting FreshPorts to work with multiple repositories to cater for the branches of the FreeBSD ports tree. At the end of that post, I talked briefly about wanting global settings or variables for my stored procedures. Shortly after posting that, I found a solution in the form
Session variables! Almost. Not quite. Read More »
Earlier today, I wrote about a fix which broke search. At the end of that post, I mentioned a few things which needed to be done to fix up the broken relationships. clean up the database add a foreign key, on delete set null trigger to find the right value when set null Let’s get
Fixing up a referential integrity issue Read More »