Author name: Dan Langille

I've been playing with Open Source software, starting with FreeBSD, since New Zealand Post installed DSL on my street in 1998. From there, I started writing at The FreeBSD Diary, moving my work here after I discovered WordPress. Along the way, I started the BSDCan and PGCon conferences. I slowly moved from software development into full time systems administration and now work for very-well known company who has been a big force in the security industry.

Doing commits in the correct order

Lately, I’ve been thinking and writing about how to list ports that depend upon this port. Today, another special situation arose: doing commits out of order. Case in question: this commit support for databases/php5-sqlite3 to lang/php5-extensions. The lang/php5-extensions commit was at 15:52:14. However, databases/php5-sqlite3 was not created until 15:54:29. I am not sure how to

Doing commits in the correct order Read More »

Storing dates in date fields

From time to time, ports/security/vuxml/vuln.xml gets a date field containing an invalid date. FreshPorts stores these entries in a table that looks like this: freshports.org=# \d vuxml Table “public.vuxml” Column | Type | Modifiers —————-+————–+—————————————————- id | integer | not null default nextval(‘vuxml_id_seq’::regclass) vid | text | not null topic | text | not null

Storing dates in date fields Read More »

What ports are dependant upon this port?

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 are dependant upon this port? Read More »

Where’s the diff?

A few months ago, Dmitry Marakasov asked for a new feature: a link to diff. The problem I had was figuring out the previous revision. The code always has the current revision. That is stored in the table: freshports.org=# \d commit_log_elements Table “public.commit_log_elements” Column | Type | Modifiers —————+————–+—————————————————————— id | integer | not null

Where’s the diff? Read More »

Scroll to Top