update-readme

Weekly README Update

You are updating the awesome-vibecoding README.md with the latest AI coding tools.

Arguments

• $ARGUMENTS: Category filter (all, ide, agentic, cloud, learning). Default: all
  • If 'all': Update all categories
  • If specific: Only update that category
• $FORCE: Cache force refresh (true/false). Default: false
  • If 'true': Ignore all cache TTLs, re-fetch everything from sources

Task

Research and update each section of the README with new tools using multiple sources and search strategies. Use the SQLite cache to avoid redundant API calls and track candidates across runs.

Categories

1. IDE & Editor Assistants - AI-powered code completion and IDE integrations
2. Agentic Coding Environments - Autonomous AI systems for end-to-end development
3. Cloud & Platform Integrations - Browser-based and cloud AI development platforms
4. MCP Servers & Tooling - Model Context Protocol servers and related tools
5. Learning Resources - Research papers, articles, videos about vibe coding

---

Step 0: Cache Initialization

Before any research, initialize the SQLite cache database.

mkdir -p .cache

# Verify DB integrity; recreate if corrupted
TABLES=$(sqlite3 .cache/awesome-vibecoding.db ".tables" 2>/dev/null || echo "")
if [ -z "$TABLES" ] || ! echo "$TABLES" | grep -q "search_cache"; then
  rm -f .cache/awesome-vibecoding.db
fi

# Create tables (idempotent)
sqlite3 .cache/awesome-vibecoding.db "CREATE TABLE IF NOT EXISTS search_cache (query TEXT NOT NULL, source TEXT NOT NULL, response TEXT NOT NULL, created_at TEXT NOT NULL DEFAULT (datetime('now')), ttl_days INTEGER NOT NULL DEFAULT 7, PRIMARY KEY (query, source));"

sqlite3 .cache/awesome-vibecoding.db "CREATE TABLE IF NOT EXISTS tool_metadata (url TEXT PRIMARY KEY, name TEXT NOT NULL, category TEXT, stars INTEGER, last_commit TEXT, description TEXT, in_readme INTEGER NOT NULL DEFAULT 0, checked_at TEXT NOT NULL DEFAULT (datetime('now')), ttl_days INTEGER NOT NULL DEFAULT 30);"

sqlite3 .cache/awesome-vibecoding.db "CREATE TABLE IF NOT EXISTS candidate_queue (url TEXT PRIMARY KEY, name TEXT NOT NULL, category TEXT, description TEXT, source TEXT, discovered_at TEXT NOT NULL DEFAULT (datetime('now')), status TEXT NOT NULL DEFAULT 'pending', reject_reason TEXT, CHECK (status IN ('pending','added','rejected','deferred')));"

sqlite3 .cache/awesome-vibecoding.db "CREATE TABLE IF NOT EXISTS run_stats (run_id TEXT PRIMARY KEY, run_at TEXT NOT NULL DEFAULT (datetime('now')), cache_hits INTEGER NOT NULL DEFAULT 0, cache_misses INTEGER NOT NULL DEFAULT 0, api_calls_saved INTEGER NOT NULL DEFAULT 0, tools_added INTEGER NOT NULL DEFAULT 0, tools_queued INTEGER NOT NULL DEFAULT 0, db_size_bytes INTEGER);"