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

The tk category now has a member!
This category was added to www/en/ports/categories about six months ago.
It was this commit that did it.
The previously reported problem with virtual categories repeated in production. That is to be expected. The proposed solution exists only on my private dev server at home. Regretably, the solution has […]

MASTERPORT is a tool Mark Linimon and I have used for a while. It seems to have entered into common usage now.

freshports.org=# select master_port, category, name from ports_active
where master_port like ‘/%’ order by category, name;
[…]

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

Late last night, I wrote about a problem with virtual categories. I’ve been unable to reproduce the problem in test. But I did find the problem in production.

[dan@supernews:/usr/websites/freshports.org/scripts] $ touch ../dynamic/www.en.ports.categories
[dan@supernews:/usr/websites/freshports.org/scripts] $ sh process_www_en_ports_categories.sh
about to fetch: fetch -q -o /usr/websites/freshports.org/dynamic/caching/tmp/categories http://www.freebsd.org/cgi/cvsweb.cgi/~checkout~/www/en/ports/categories?rev=HEAD&content-type=text/plain
Can’t locate Text/CSV_XS.pm in @INC (@INC contains: /usr/local/lib/perl5/5.8.8/BSDPAN /usr/local/lib/perl5/site_perl/5.8.8/mach /usr/local/lib/perl5/site_perl/5.8.8 /usr/local/lib/perl5/site_perl /usr/local/lib/perl5/5.8.8/mach /usr/local/lib/perl5/5.8.8 […]

After all I’ve written about virtual categories, it seems I still don’t have them right.
The code is there:

$ grep -l www/en/ports/categories *
process_www_en_ports_categories.sh
special_processing_files.pm

but things are still not being updated. If you look at the list of categories, sort by Description, you will find several with a description of “This is a virtual category. No description […]

Some people like to break into systems. Some like to find vulnerabilities. The good ones will tell you about the vulnerability so you can fix. Many won’t.
Then there are the script kiddies. They don’t know much. They know how to run scripts.
Lately, I’ve been seeing these requests to the FreshPorts […]