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 no sysutils directory. […]
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 interesting. It’s not
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. Someone actually found
The things you learn on IRC Read More »
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
FreshPorts/FreshSource have moved Read More »
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
Your ports have MOVED! Read More »
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
The NEW! FreshPorts Read More »
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 same thing doesn’t affect
A ShmooCon I will go Read More »