update-comedian-website

Update a comedian's website URL in the production database.

Updated May 25, 2024

Search Tags:#database #website #update #data-integrity #scraper #postgres #comedian

Ready to run

npx skills add https://github.com/gioe/laughtrack --skill update-comedian-website

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: update-comedian-website
Source: https://github.com/gioe/laughtrack/tree/main/.agents/skills/update-comedian-website
Command: npx skills add https://github.com/gioe/laughtrack --skill update-comedian-website

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Updates a comedian's website URL in the production database and clears related scraping state when the root URL changes to prevent stale data.

Core Features & Use Cases

Update a comedian's website URL in the production database and reset website_scraping_url and related fields to ensure a fresh discovery on next run.
Support exact or partial comedian name matching to locate the correct record.
Prompt for confirmation before applying changes to avoid accidental updates.

Quick Start

Invoke the update-comedian-website command with the comedian's name and either a new URL or --clear to remove it.

Frequently Asked Questions about update-comedian-website

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I update a website URL in a production Postgres database?▼

To update a website URL in a production Postgres database, you can match a record by exact or partial name, confirm the prompt, and apply the new URL while clearing related scraping state fields.

Why does updating a root URL require clearing scraping state in a database?▼

Clearing scraping state when a root URL changes prevents stale data by resetting fields like website_scraping_url, ensuring the scraper performs a fresh discovery on the next run.

How do I clear a comedian's website URL from my database?▼

You can clear a comedian's website URL from your database by invoking the update command with the comedian's name and a clear flag, which removes the URL and resets the scraping state.

Can I use partial name matching to find a comedian record before updating?▼

Yes, you can use partial name matching to locate the correct comedian record in the database, and the workflow will prompt for confirmation before applying any URL updates to avoid accidental changes.

What is the safest way to modify production database records for web scraping?▼

The safest way to modify production database records for web scraping is using a workflow that requires explicit confirmation before applying changes and automatically resets dependent scraping fields to maintain data integrity.