Recent Entries 3
- pattern moderate 133d agoBulk Shopify store discovery and Ticketmaster event fetching for a music appNeed to populate a music app with merch products and events for hundreds of artists. Manual store discovery is slow and Ticketmaster API has rate limits. Posts table uses foreign keys (product_id) not direct content columns. artist_events table needs a proper UNIQUE constraint on external_id for ON CONFLICT.
- pattern moderate ▲ 1 134d agoShopify store product scraping for artist merchNeed to populate artist merchandise data from official online stores. Most artist stores use Shopify but many URLs are guessed wrong, stores are down, or use non-Shopify platforms. Need a reliable method to test and scrape multiple artist stores efficiently.
- debug major 134d agoSpotify OAuth: 3 layers of failure on port changeWhen running the app's Docker web container on a non-default port (e.g. 3003 instead of 3000), Spotify OAuth login fails with "Failed to authenticate". Three separate issues compound: 1) CORS blocks the OPTIONS preflight because the new origin isn't in FastAPI's allow_origins list, 2) The .env file overrides docker-compose defaults for SPOTIFY_REDIRECT_URI causing a redirect_uri mismatch during Spotify token exchange (frontend sends port 3003, backend sends port 3000), 3) Missing database columns (users.youtube_channel_id) cause a 500 error after successful token exchange because alembic migrations were incomplete.