The FreshPorts website has moved. It was at 216.168.29.4 and is now at 64.147.113.42, on the other side of the country.
If your DNS is lagged, you will be redirected from http://www.freshports.org/ to http://beta.freshports.org/. Once your DNS catches up, you won’t be directed. This wonderful solution is accomplished with this directive on the […]

A very key point in this article. Product vs project.
Read: http://people.planetpostgresql.org/greg/index.php?/archives/120-Postgres-is-not-for-sale.html

Want $200? Free admission to BSDCan? And tutorials?
Read this: http://blog.kozubik.com/john_kozubik/2007/12/bounty-posted-f.html

I’ve found work. Details here.

Here is the patch I just comitted which reduces the amount of RAM consumed.

[dan@ngaio:/usr/websites/freshports.org/classes] $ cvs di -ub display_commit.php
Index: display_commit.php
===================================================================
RCS file: /home/repositories/freshports-1/classes/display_commit.php,v
retrieving revision 1.8
diff -u -b -r1.8 display_commit.php
— display_commit.php 10 Jul 2007 11:39:07 -0000 1.8
+++ display_commit.php 22 Oct 2007 17:22:23 -0000
@@ -87,19 +87,16 @@

[…]

I was scanning the error logs this morning, looking for anything unusual. I found it:

[Mon Oct 22 12:31:10 2007] [error] PHP Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 512 bytes) in display_commit.php on line 91

I have seen this before, but could not recall where. I also could […]

FreshPorts encountered its first corrupted cvs-all email today. It handled it correctly. It errored out, put the emails aside in the retry queue, and sent me a notice.
Af first, I thought the email had been corrupted on the way into my system. But after checking the above URL, I realised it was […]

I’m looking for work. I’m a software developer with lots of sysadmin experience. My ideal job would require multiple skills and involve development of high availability strategy, some coding, database design, and some sysadmin work, although not necessarily in that order.
My resume: http://www.freebsddiary.org/dan_langille.php
Will consider relocation.

It was quite some time ago that I [finally] moved FreshPorts onto the new server. Today I moved FreshSource over too. Both websites use the same database instance. That is, each website is a different view of the same database.
Now that FreshSource is over here, we should be able to start doing […]

This is a starting introduction to the FreshPorts database. Hopefully it will prompt questions. Ask.
The key data component of FreshPorts is the commit. These are stored in the commit_log table. Each commit affects one or more files, known in the database as elements.
The elements table is a self-referencing table and represents the […]