AI Tech Fulltext Fetch

Core Goal

• Reuse the same SQLite database populated by ai-tech-rss-fetch.
• Fetch article body text from each RSS entry URL.
• Persist extraction status and text in a companion table (entry_content).
• Support incremental runs and safe retries without creating duplicate fulltext rows.

Triggering Conditions

• Receive a request to fetch article body/full text for entries already in ai_rss.db.
• Receive a request to build a second-stage pipeline after RSS metadata sync.
• Need a stable, resumable queue over existing entries rows.
• Need URL-based fulltext persistence before chunking, indexing, or summarization.

Workflow

1. Ensure metadata table exists first.

• Run ai-tech-rss-fetch and populate entries in SQLite before using this skill.
• This skill requires the entries table to exist.
• In multi-agent runtimes, pin DB to the same absolute path used by ai-tech-rss-fetch: