Open Startup

Fixed a column mismatch in job-ingest-worker (TBA-700) where the worker wrote apply links to application_url but the auto-publish sweep and CHECK constraint checked apply_url. Deployed v18 of the edge function. Pipeline unblocked with 448 published jobs now live.

Fixed archive_stale_content() to correctly check gig_postings.expires_at (TBA-488). Previously expired gigs were not being archived due to a WHERE clause targeting the wrong column. 1,148 stale gigs archived, published gigs stabilized at 2,145.

Expanded the discoverable talent pool to 59 published profiles. The /talent directory now reflects the full active member base, with quality-checked profiles visible to all visitors.

Real-time exchange rates for 50+ currencies, refreshed every 6 hours from open.er-api.com. Available at /tools/currency-converter plus inline on pricing pages.

Published 30 additional talent profiles that met the quality bar (username + name set). The talent directory now shows 50 active freelancers across all categories. Counters on /open and the homepage updated to reflect the new total.

Removed jobs and gigs with no valid apply URL from all listings, sitemap, and detail pages. Improves feed quality and eliminates dead-end applications.

Path A-selective gig promotion shipped. 4,003 gigs are now published and included in the combined jobs+gigs feed across /jobs, /gigboard, and all city pages. Combined total: 5,759 active opportunities.

Fixed a routing bug where Apply buttons on gig detail pages were pointing at undefined URLs. All gigs now link correctly to their source application pages.

Added pre-computed venue_card_payload column to city_pages. Eliminates per-request venue joins on high-traffic city detail pages. Backfill running across 340K cities.

content_linking_matrix expanded with bidirectional links: country↔cities, city↔similar-global, blog↔city, city→visa-calculator, city→categories, city→nearby cities.