Activity

Summary

Fixes three bugs in TrendsController that were applied directly to the container, and adds 13 new RSS sources via a database migration.

Controller Fixes

criticalSecurity()

• Changed raw_json->>'severity' IN ('CRITICAL', 'HIGH') → UPPER(raw_json->>'severity') IN ('CRITICAL', 'HIGH') for case-insensitive severity matching
• Changed threshold from > 8 to >= 8.0 to include exactly CVSS 8.0

security()

• Changed ORDER BY CASE to use UPPER(raw_json->>'severity') for case-insensitive severity sorting

launches()

• Added deduplication via DISTINCT ON (url_hash) CTE (same pattern as briefing())
• Prevents duplicate entries from multiple fetches of the same item

New Sources (Migration)

Adds 13 new RSS sources:

YouTube Channels

• Fireship, Theo (t3.gg), ThePrimeagen

Developer Newsletters

• JavaScript Weekly, Node Weekly, React Status, Golang Weekly, TLDR Newsletter, TLDR AI Newsletter

Notable Tech Blogs

• Simon Willison's Weblog, Julia Evans Blog, Martin Fowler, 404 Media

Testing

• Pint linting: ✅ PASS
• Changes match exactly what was applied in the container (reverse-engineered from live)