Can we produce a src only news feed? I think so.
FreshSource, our sister website, runs off the same database instance as FreshPorts. It merely uses a different web interface. It has a new feed, but it covers all commits, not just src and ports.
The SQL used to generate that news feed is:
SELECT id,
message_id,
message_date,
message_subject,
date_added,
to_char(commit_date - SystemTimeAdjust(), 'DD Mon YYYY') AS commit_date,
to_char(commit_date - SystemTimeAdjust(), 'HH24:MI') AS commit_time,
committer,
description,
system_id,
encoding_losses
FROM commit_log
ORDER BY commit_log.commit_date DESC
To pull back src only commits, you’d have to start looking at the commit_log_elements table and screen for pathnames like ‘src/%’.
Doable.
