From time to time, ports/security/vuxml/vuln.xml gets a date field containing an invalid date. FreshPorts stores these entries in a table that looks like this:

freshports.org=# \d vuxml
[…]

I have no idea what caused the server to freeze up at about 00:10 GMT on 13 Feb 2011. Everything, including ping, stopped working then. Service was restored at about 17:26 GMT. Why so long? I was occupied elsewhere.
FreshPorts appears to have caught up with everything on the commit list.

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 depend upon […]

A few months ago, Dmitry Marakasov asked for a new feature: a link to diff.
The problem I had was figuring out the previous revision. The code always has the current revision. That is stored in the table:

freshports.org=# \d commit_log_elements
[…]

Quite some time ago, FreshPorts and The FreeBSD Diary both moved from clear text passwords to password hashes. As such, you are no longer able to recover your password. You had to email me. This is extra work for everyone. Let us automate this.
The first, step, is a table:

create table user_password_reset(
[…]

Today I found a new issue with commit emails. They aren’t perfect. Neither is the code.
The problem arose with this email:

philip 2010-07-31 14:57:38 UTC

FreeBSD src repository

Modified files:
. […]

In a previous post, I wrote about a suspected LIMIT problem. It turns out that suspicion proved correct. The solution was to move to a nested query which limits the underlying data and then allows the outer query to grab all the associated fluff that surrounds it.
Here is the fix to the original […]

Bjoern A. Zeeb pointed out a problem today. On the following URL, there should be more commits per page. Only three are shown (at the time of writing).
http://www.freshports.org/search.php?stype=committer&method=exact&query=jb&num=100&orderby=category&orderbyupdown=asc&search=Search&include_src_commits=include_src_commits
The page is showing 100 results per page. This should be 100 commits, but the result set is showing only 100 files. The SQL […]

Help them meet their 2009 target: http://www.freebsdfoundation.org/donate/

All FreshPorts servers are now running PostgreSQL 8.4 (they were running 8.3). The upgrade process was rather straight forward. I documented it during the first upgrade (of my development server). I then used the same process for both the beta server and the production server. All went well.
Merry Christmas.