RSS Fetcher - 统一RSS采集系统 | Unified RSS Feed Fetcher

核心特性 | Core Features

• 增量抓取 / Incremental Fetching - 只抓取新文章，基于URL哈希自动去重 | Only fetch new articles, auto-deduplicate based on URL hash
• 自动标签 / Auto-tagging - 优先使用RSS自带category，无则自动提取标题关键词 | Prioritize RSS category, auto-extract keywords from title if absent
• HTML报告 / HTML Reports - 生成可筛选的静态HTML页面，支持日期/分类/标签多维度筛选 | Generate filterable static HTML pages with date/category/tag filters
• 源健康监控 / Source Health Monitoring - 检测RSS源可用性，支持批量检查 | Monitor RSS source availability with batch checking
• 分类管理 / Category Management - 文章自动继承源的分类，支持多维度筛选 | Articles inherit source categories, multi-dimensional filtering
• 超时设置 / Timeout Setting - 单源30秒超时，避免长时间阻塞 | 30-second timeout per source to avoid blocking

数据库设计 | Database Design

表结构 | Table Structure

说明 / Note: RSS源通过 config/sources.json 文件管理，不存入数据库 | RSS sources are managed via config/sources.json file, not in database

关键设计 | Key Design

• 时间戳使用 INTEGER (Unix时间戳) - 查询更快、比较更简单 | INTEGER Unix timestamps for faster queries
• published_at NOT NULL - 必填，缺失时标记为 UNRELIABLE_TIME (1970-01-01) | Required, marked as UNRELIABLE_TIME if missing
• URL唯一索引 / URL Unique Index - 确保去重 | Ensure deduplication
• 多标签支持 / Multi-tag Support - 一篇文章可拥有多个标签 | Multiple tags per article
• category字段 / Category Field - 继承自sources.json的分类配置 | Inherited from sources.json configuration

快速开始 | Quick Start

1. 初始化数据库 | Initialize Database

cd skills/rss_fetcher
python3 scripts/init_db.py

2. 配置RSS源 | Configure RSS Sources

编辑 config/sources.json，添加你的RSS源： Edit config/sources.json to add your RSS sources:

{
  "sources": [
    {
      "id": "openai",
      "name": "OpenAI Blog",
      "url": "https://openai.com/blog/rss.xml",
      "category": "tech",
      "enabled": true
    }
  ]
}

3. 执行抓取 | Execute Fetch

# 抓取所有源（最近24小时）/ Fetch all sources (last 24 hours)
python3 scripts/fetch.py

# 抓取指定源 / Fetch specific sources
python3 scripts/fetch.py --sources openai huggingface

# 抓取最近48小时 / Fetch last 48 hours
python3 scripts/fetch.py --hours 48

# 使用更多线程（默认20，最大50）/ Use more workers (default 20, max 50)
python3 scripts/fetch.py --workers 50

⚠️ 抓取后记得更新HTML报告 - 新抓取的文章需要重新生成页面才能在浏览器中查看 ⚠️ Remember to update HTML report after fetching - New articles require regeneration to view in browser

python3 scripts/fetch.py && python3 scripts/generate_html.py

4. 生成HTML报告 | Generate HTML Report

注意：每次抓取新文章后，必须重新生成HTML页面才能看到最新内容。 Note: Must regenerate HTML after fetching new articles to see latest content.

# 抓取并立即更新HTML（推荐工作流）/ Fetch and update HTML (recommended workflow)
python3 scripts/fetch.py && python3 scripts/generate_html.py

# 单独生成HTML（已有新数据时）/ Generate HTML only (when new data exists)
python3 scripts/generate_html.py

# 打开查看 / Open to view
open data/index.html  # Mac
# 或浏览器访问 / Or browser: file:///.../rss_fetcher/data/index.html

HTML报告功能 / HTML Report Features:

• 📅 日期筛选 / Date Filter - 起止日期选择 | Start/end date selection
• 🏷️ 分类筛选 / Category Filter - 按文章分类筛选 | Filter by article category
• 🔍 关键词搜索 / Keyword Search - 实时搜索标题 | Real-time title search
• ☑️ 标签多选 / Multi-tag Selection - 多标签组合筛选（AND逻辑）| Multi-tag combo filter (AND logic)
• 📊 实时统计 / Real-time Stats - 显示筛选结果数量 | Show filtered results count

5. 源管理 | Source Management

# 检查所有源的健康状态 / Check all source health
python3 scripts/source.py check

# 查看源统计 / View source statistics
python3 scripts/source.py stats

# 添加新源 / Add new source
python3 scripts/source.py add myblog "My Blog" "https://example.com/feed.xml" tech

# 禁用/启用/删除源 / Disable/enable/remove source
python3 scripts/source.py disable myblog
python3 scripts/source.py enable myblog
python3 scripts/source.py remove myblog

6. 查看文章列表 | View Article List

# 终端表格查看最近文章 / View recent articles in terminal table
python3 scripts/list.py

# 查看最近48小时 / View last 48 hours
python3 scripts/list.py --hours 48

# 按分类查看 / View by category
python3 scripts/list.py --category tech

# JSON格式输出 / JSON output
python3 scripts/list.py --json

配置文件 | Configuration Files

sources.json

{
  "_description": "RSS源配置文件 | RSS source config file",
  "_updated": "2026-03-15",
  "_total_sources": 111,
  "sources": [
    {
      "id": "openai",
      "name": "OpenAI Blog",
      "url": "https://openai.com/blog/rss.xml",
      "category": "tech",
      "enabled": true
    }
  ]
}

字段说明 / Field Description：

• id - 源唯一标识 | Source unique identifier
• name - 显示名称 | Display name
• url - RSS订阅地址 | RSS feed URL
• category - 文章分类 | Article category
• enabled - 是否启用 | Whether enabled

分类可自由定义，在 sources.json 中使用任意分类名称即可。 Categories can be freely defined using any category name in sources.json.

自动标签系统 | Auto-tagging System

标签生成逻辑 | Tag Generation Logic

1. 优先使用RSS自带category - 提取 <category> 标签内容 Prioritize RSS category - Extract <category> tag content
2. Fallback关键词提取 - 无category时从标题提取： Fallback keyword extraction - Extract from title if no category:
   • 规则匹配（AI/区块链/股票等预定义规则）| Rule matching (AI/blockchain/stocks etc.)
   • 名词提取（英文大写单词、中文词组）| Noun extraction (English caps, Chinese phrases)

预定义标签规则 | Predefined Tag Rules

规则定义在 fetch.py 的 TAG_RULES 中，可自由扩展。 Rules defined in TAG_RULES in fetch.py, freely extensible.

数据查询示例 | Data Query Examples

获取今天所有文章 | Get Today's Articles

SELECT title, url, source_id
FROM articles
WHERE date(fetched_at, 'unixepoch') = date('now')
ORDER BY published_at DESC;

获取某分类的文章 | Get Articles by Category

SELECT * FROM articles
WHERE category = 'tech'
AND published_at > strftime('%s', 'now', '-24 hours');

获取带标签的文章 | Get Articles with Tags

SELECT a.title, a.url, GROUP_CONCAT(t.name) as tags
FROM articles a
LEFT JOIN article_tags at ON a.id = at.article_id
LEFT JOIN tags t ON at.tag_id = t.id
WHERE a.category = 'tech'
GROUP BY a.id;

获取热门标签 | Get Popular Tags

SELECT t.name, COUNT(*) as count
FROM tags t
JOIN article_tags at ON t.id = at.tag_id
GROUP BY t.id
ORDER BY count DESC;

文件位置 | File Locations

rss_fetcher/
├── SKILL.md                    # 本文档 | This document
├── config/
│   └── sources.json           # RSS源配置 | RSS source config
├── scripts/
│   ├── init_db.py             # 数据库初始化 | DB initialization
│   ├── fetch.py               # 核心抓取脚本（含自动标签）| Core fetch script
│   ├── generate_html.py       # HTML报告生成 | HTML report generation
│   ├── source.py              # 源健康检查与管理 | Source health check
│   ├── list.py                # 终端文章列表 | Terminal article list
│   └── query.py               # 数据查询工具 | Data query tool
├── data/
│   ├── rss_fetcher.db         # SQLite数据库 | SQLite database
│   └── index.html             # 生成的HTML报告 | Generated HTML report
└── references/
    └── schema.sql             # 数据库结构参考 | DB schema reference

数据库位置 | Database Location

rss_fetcher/data/rss_fetcher.db

注意事项 | Notes

1. 首次抓取会比较慢 - 需要抓所有历史文章 First fetch is slow - Need to fetch all historical articles
2. SQLite并发 - 单进程访问，避免并发写入 SQLite concurrency - Single process access, avoid concurrent writes
3. 时间不可靠文章 - published_at = 0 的文章需人工审核 Unreliable time articles - Articles with published_at = 0 need manual review
4. 标签自动累积 - 随着文章增多，标签会自动丰富 Tags auto-accumulate - Tags enrich as more articles are fetched
5. 定期重新生成HTML - 抓取新文章后需重新运行 generate_html.py Regularly regenerate HTML - Must rerun generate_html.py after fetching new articles

Part of OpenClaw Daily Research System