When FreshPorts started, it used unique numbers to identify ports. This number was the primary key in the ports table. It was during a talk at a local LUG that I discovered how easy it would be to implement the solution you see now (e.g. sysutils/bacula-server. On the FreshPorts webserver, there is […]

I’m pretty sure I want to implement more caching on FreshPorts. My first thought was to write the files to disk and then remove them when they need updating. I recall a caching program that either works with PostgreSQL is is implemented in PostgreSQL. Putting to cache into a database would be […]

When I mentioned in the #postgresql channel that FreshPorts/FreshSource had moved to PostgreSQL, the first question was: where’s your Powered By PostgreSQL logo? My reply? At the bottom of the FreshPorts about page. Granted, those logos could be a little higher up on the page.
But that’s not what prompted this post. […]

Last night, after an initial failed attempt, I moved FreshPorts and FreshSource to the new webserver. Both websites use the same database, so it makes sense to keep them on the same server.
When I first loaded up the FreshPorts database, I saw some errors that concerned me:

NOTICE: ALTER TABLE / ADD PRIMARY KEY […]

It was about a month ago that krion pointed out that when a port moves from one category to another, your watch list is left with the old port and it ignores the new port. For more details on this problem, please read my first post on this subject.
I’ve coded up an initial solution […]

There is a NEW! FreshPorts available. It looks pretty much like the old on, but there are a few differences that should stand out:

Old
NEW!

CPU
PII 800MHz
P4 2.40GHz

RAM
512 MB
1GB

OS
FreeBSD 4.11-STABLE
FreeBSD 6.0-STABLE

Database
PostgreSQL 7.4.7
PosgreSQL 8.1

NIC
fxp
sis

There are many variables here. Not everything may be tuned for peak performance. Time will tell.
If you want to test out the […]

I’m heading out to ShmooCon 2006. I’m arriving in Washington DC on Wednesday the 11th, and departing on Sunday the 12th. I’m arriving early in case the weather closes in. Washington doesn’t cope with snow well. What they call a blizzard would shutdown the city for two days. In Ottawa, the […]