At present, master/slave relationships in FreshPorts are not stored optimally. Each port has a field, master_port, which contains the category/port of its master_port, otherwise, it is an empty string.
The ideal situation would be a table such as this:

create table master_slave
(
master_port_id integer […]

Today was the first day of PGCon 2007. I sat in on the Performance tuturial. The room was overflowing, so we moved to a larger room. 58 people for a tutorial is pretty impressive. The connection to FreshPorts? I came up with an idea for solving the problem. Tonight […]

Some of you may be noticing HTML in the daily outgoing messages. I apologise for that. You must have seen the various notices that appear at the top of each FreshPorts webpage. At present, they look like this:

Absolute BSD - $25 shipped - order yours now

I’m looking for work. […]

Repo copies are evil. What are repo copies? A repo copy occurs when you move things around in the repository manually. For example, this commit contains a lot of repo copy work. Ports are being moved from their current category to a new category, ports-mgmt. The original files in the […]

FreshPorts has a CVS history that dates back to mid 2000 (and that’s just what I could find with a quick search). It started on a MySQL, which isn’t really up to the job. It quickly moved to PostgreSQL, the finest database server out there, and it just happens to be Open Source. […]

There will be a PostgreSQL Conference in May 2007. I’ll definintely be there! I’m looking forward to this.
It’s right after a BSD conference. There will be quite a few people attending both conferences. One trip, two conferences, a great time.

Earlier this week, we had a bit of a crisis. The colo which provides bandwidth and servers to FreshPorts (and all the other websites I run), was unexpectedly shutdown. BChosting sold their Vancouver facilities to Netluxe, who, by all accounts, shut down the ops center without notifying customers. Well, I wasn’t notified. […]

Christian Ullrich found a problem with the Watch List updating pages. Over the past few weeks, we’ve been working on fixing it. I’ve been coding. He’s been verifying. Today we fixed it. The changes should go into production soon (if they aren’t already).
The other thing he mentioned was sorting by last […]

I’ve spoken about pagination before. Use the search to see where. I’ve started adding pagination to the Search page. I’ll be using Pager form PEAR again.

The Python listening script is now in production. With a few luser-type problems along the way. Specifically: I have discovered, quite recently, that having the same name for both the NOTIFY command and the LISTEN command is kind of a good strategy when you actually want your listener to be notified. The […]