Real-Time Hashtag Rotator for Civic Dashboards
Preset hashtags are static noise. I needed a rotator that actually listens — one that fetches live trending hashtags from Trends24 and rotates them dynamically across regions and time windows. So I built it.
This isn’t just rotation — it’s amplification of civic signals.
“Static hashtags are dead weight. Civic dashboards deserve better.”
🧠 Architecture Overview
- Scraper: Node.js + Cheerio
- Rotator: Cron job or Vercel Edge Function
- Cache: Supabase or Vercel KV
- Frontend: HTML/JS module with region toggles
🧩 Scraping Trends24
I use Cheerio to extract hashtags from Trends24’s HTML:
$('.trend-card li a').each((i, el) => { const tag = $(el).text().trim(); if (tag.startsWith('#')) hashtags.push(tag); });🔁 Daily Refresh Logic
Each region gets refreshed every 6–12 hours:
const regions = ['kenya', 'usa', 'uk']; for (const region of regions) { const tags = await fetchHashtags(region); await supabase.from('hashtag_cache').upsert([{ region, tags }]); }📊 Frontend Rotation
Hashtags rotate every 5 seconds on the dashboard:
setInterval(() => { document.getElementById('hashtag-rotator').textContent = tags[i % tags.length]; i++; }, 5000);🧠 Bonus Features
- 🕵️ Flag ghost hashtags with audit notes
- 📈 Track hashtag velocity (mentions/hour)
- 🌍 Region toggles for localized dashboards
- 🧩 Remixable modules for Blogger, Supabase, Vercel
Want this wired into your civic dashboard with webhook listeners and hashtag diagnostics? Let’s deploy it.
“You’re not just rotating — you’re amplifying civic signals in real time.”
🧾 Footnotes & Glossary of Terms
| Term | Definition |
|---|---|
| Hashtag Rotator | A system that loops trending hashtags, updating them regularly to reflect current topics. |
| Trends24 | A website that tracks real-time trending hashtags across regions and countries. |
| Civic Dashboard | A public-facing interface that visualizes government or community data for transparency. |
| Node.js | A JavaScript runtime used to build backend services and automation scripts. |
| Cheerio | A lightweight library for parsing and manipulating HTML — often used in web scraping. |
| Cron Job | A scheduled task that runs automatically at set intervals (e.g., every 6 hours). |
| Vercel Edge Function | A serverless function hosted close to users for fast performance — ideal for APIs. |
| Supabase | An open-source backend platform offering database, auth, and real-time APIs. |
| KV (Key-Value Store) | A simple database storing data as key-value pairs — useful for caching. |
| HTML/JS Module | A frontend component built with HTML and JavaScript for data display and interaction. |
| Region Toggles | UI controls that let users filter data by geographic region (e.g., Kenya, USA). |
| Ghost Hashtags | Artificially trending hashtags often tied to bots, scams, or manipulation. |
| Audit Notes | Metadata attached to entries explaining origin, reliability, or anomalies. |
| Hashtag Velocity | The rate at which a hashtag is mentioned — often measured per hour. |
| Webhook Listener | A backend service that waits for incoming data and reacts to it in real time. |
| Upsert | A database operation that updates a record if it exists, or inserts it if not. |
| Cache | Temporary storage used to speed up access to frequently used data. |
| Frontend Rotation | Visual cycling of data on a webpage using JavaScript timers. |
| Scrollability | Ability to drag or scroll horizontally to view long lines of content. |
| white-space: pre | CSS rule that preserves spacing and line breaks in code blocks. |
| overflow-x: auto | CSS rule that enables horizontal scrolling when content overflows. |
No comments:
Post a Comment