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

I am just back from OSCON.
While there, I attempted to incorporate some CSS patches into FreshPorts…. I failed.
It is time to Open Source FreshPorts. It uses PHP (website), Perl (message processing), and Python (cache). It’ll take me a while to get the infrastructure into place. I have servers suitable for this purpose. […]

For more detail, read Duplicate file in cvs-all commit causes problems.
[dan@ngaio:/usr/websites/freshports.org/scripts] $ cvs di process_cvs_mail.pl
Index: process_cvs_mail.pl
===================================================================
RCS file: /home/repositories/freshports-1/scripts/process_cvs_mail.pl,v
retrieving revision 1.10
diff -r1.10 process_cvs_mail.pl
70c70
< FreshPorts::Utilities::ReportError(’err’, “No message ID found for this commit message (” . $Message_Subject . “).\n\nIs this a corrupted commit or […]

For more detail, read Duplicate file in cvs-all commit causes problems.

$ cvs di -u utilities.pm
Index: utilities.pm
===================================================================
RCS file: /home/repositories/freshports-1/scripts/utilities.pm,v
retrieving revision 1.14
diff -u -r1.14 utilities.pm
— utilities.pm 17 Mar 2007 13:49:42 -0000 1.14
+++ utilities.pm 27 Jun 2007 02:27:26 -0000
@@ […]

Søren Straarup brought this up today. FreshSource does not link to the right place in CVSWEB for commits to CVSROOT. For example, look at this commit. If you click on the diff link, it goes to the wrong place. It goes to
http://www.freebsd.org/cgi/cvsweb.cgi/CVSROOT/modules.diff?r1=1.18319&r2=1.18318
instead of
http://www.freebsd.org/cgi/cvsweb.cgi/CVSROOT-ports/modules.diff?r1=1.18319&r2=1.18318
After discussions with Simon Nielsen and is Søren […]

Greetings from southern Florida. If you haven’t heard, I moved to Jupiter, Florida. Yes, PGCon and BSDCan will be in Ottawa in 2008. My relocation does not affect those events.
It was this commit to print/gutenprint that caused the problem. You will notice that one file is touched twice by that commit. […]

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

The much-anticipated X.org 7.2 commit has occurred. Unfortunately, the commit is causing a deadlock on FreshPorts. The error message I see is:

[36978]: [1-1] 2007-05-20 00:01:55.591 EDT freshports.org 36978 ERROR: deadlock detected
[1-2] 2007-05-20 00:01:55.591 EDT freshports.org 36978 DETAIL: Process 36978 waits for ShareLock on transaction 15047015; blocked by
[1-3] process 37015.
[1-4] Process […]

The deadline for voting has passed. The Candidates | The Contest Details
The table holding the results is:

freshports.org=# \d design_results
Table “public.design_results”
Column | […]

The candidates from the Design Contest are now available for review and voting.
Vote early. Vote often.
Enjoy.