Archive for the 'PostgreSQL' Category

The committer field is not always an email address

Tuesday, November 1st, 2011

This issue was brought to my attention by wxs (Wesley Shields). The issue is evident at http://www.freshports.org/graphs2.php. When you get there, click on click on Commits Over Time by Committer and then wait for the page to load.
Scroll down to the D’s. There you’ll see a few committers suffixed with ‘(ports committer)’.
Looking […]

mail/horde4-imp vulnerability

Sunday, September 25th, 2011

Mr Thomas wrote me regarding mail/horde4-imp and a particular vulnerability. Specifically, he figured that a recent commit (link to mail archives) fixed a bad entry in vuxml. Let’s look into that now.
I first compared dev, beta, and production. All three had the port flagged as vulnerable. This situation is indicated by […]

What ports are dependant upon this port?

Saturday, February 5th, 2011

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

RESTRICTED not correctly reported

Friday, May 15th, 2009

The RESTRICTED value on ports has been incorrectly recorded for some time.
The code fix:

$ cvs di port.pm
Index: port.pm
===================================================================
RCS file: /home/repositories/freshports-1/scripts/port.pm,v
retrieving revision 1.54
diff -r1.54 port.pm
168c168
< $restricted_alt = FreshPorts::Utilities::NULLIfEmpty($dbh, $this->{restricted_alt});

> […]

Master/slave relationships

Friday, October 12th, 2007

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

more on the X.org 7.2 commit deadlock

Monday, May 21st, 2007

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

Stripping HTML from announcements

Friday, April 6th, 2007

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

Sunday, March 4th, 2007

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

Merging from branch to HEAD

Monday, December 18th, 2006

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

The PostgreSQL Conference

Tuesday, November 28th, 2006

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.