symphony / api

Commit History

  1. Fix: Add python-multipart for file upload Running

    Vaibhav Pharmacy
    7b0ddb2
  2. Update architecture to run collector in GH Actions and sync DB via API

    Vaibhav Pharmacy
    2a39c74

  1. fix: JSON parsing for Gemini and hide missing API key message in UI

    Vaibhav Pharmacy
    54dedc3

  1. feat: Add A&R Discovery Agent and Deep Comment Themes

    Vaibhav Pharmacy
    e901791
  2. feat: Add LangChain-powered viral prediction engine and UI integration

    Vaibhav Pharmacy
    956699f
  3. fix: Update quota API payload keys to match frontend and trigger DB sync on stats refresh

    Vaibhav Pharmacy
    a61da91
  4. fix: Filter viral alerts leaderboard to only show spikes from the last 30 days

    Vaibhav Pharmacy
    feb644e
  5. feat: Implement Hugging Face Dataset sync for persistent SQLite database storage

    Vaibhav Pharmacy
    775411b
  6. fix: Extrapolate daily and monthly view counts from latest snapshots to resolve zero growth bug

    Vaibhav Pharmacy
    624bdd4

  1. feat: Add Daily and Monthly view tracker and UI toggle

    Vaibhav Pharmacy
    a3ee7b2
  2. feat: Add Song Comparison Dashboard, Sentiment Analysis, and fix GH Actions timeout

    Vaibhav Pharmacy
    b4c99ff

  1. Add simulation endpoint

    Vaibhav Pharmacy
    f7f72d1
  2. Fix database: Auto-seed all 189 artists to fix HF missing database issue

    Vaibhav Pharmacy
    9321b3c

  1. Untrack db files, add auto-seeding logic, add logs endpoint

    Vaibhav Pharmacy
    ea7d5d2

  1. Fix youtube dashboard, quota issues, add leaderboard

    Vaibhav Pharmacy
    14fc427

  1. fix: make YouTube Data API the default and ytmusicapi the fallback⁠

    Vaibhav Pharmacy
    a532903

  1. revert: switch back to Turso from local SQLite

    Vaibhav Pharmacy
    fba9505
  2. fix: use official YouTube Data API channel search as fallback when ytmusic is blocked, centralize collect logic

    Vaibhav Pharmacy
    b45a7fd
  3. fix: add diagnostic logging and fallback logic for youtube collection

    Vaibhav Pharmacy
    9335186
  4. fix: add per-artist collect status tracking and poll-based frontend⁠

    Vaibhav Pharmacy
    14451dd
  5. refactor: remove all Turso/libsql dependencies, switch to pure local SQLite

    Vaibhav Pharmacy
    8210ec1
  6. fix: write collector subprocess output to collector.log so frontend can read progress

    Vaibhav Pharmacy
    794da35
  7. feat: integrated progress bars directly into the stats and discover refresh buttons by parsing the collector log

    Vaibhav Pharmacy
    ed46c5a
  8. fix: revert web scraper fallback and surface real API errors to the user

    Vaibhav Pharmacy
    b91ea26
  9. fix: add missing google-api-python-client to api requirements

    Vaibhav Pharmacy
    f67905a

  1. fix: stage and commit remaining local bug fixes, styles, and cache overrides

    Vaibhav Pharmacy
    dee76eb
  2. chore: switch daily scheduler to Python collector for VM capability support

    Vaibhav Pharmacy
    3568949
  3. Optimize SQL queries for artists endpoints to resolve timeout

    Vaibhav Pharmacy
    f62d852

  1. Optimize frontend speed and add Go backend

    Vaibhav Pharmacy
    5a30a94
  2. Optimize frontend load time: combine 5 API calls into 1 dashboard endpoint and enable GZip compression

    Vaibhav Pharmacy
    978be0e
  3. Harden all edge cases: auto-reconnect with health check, thread-safe connection pool, scoped artist CTEs (137K→30 row scan), ttl_cache on stats/filters, invalidate_cache on mutations, safe is_watched cast, remove test files

    Vaibhav Pharmacy
    96bdeb2

  1. Comprehensive performance overhaul: eliminate ALL correlated subqueries with CTEs, add 6 composite indexes, add TTL cache, fix N+1 patterns in viral/search/artist endpoints, remove duplicate font import, add lazy loading⁠

    Vaibhav Pharmacy
    689e51a

  1. Fix 6s latency on artist page by replacing python N+1 enrichment loop with bulk SQL query

    Vaibhav Pharmacy
    67cbd1b
  2. Optimize get_artists query to eliminate N+1 correlated subqueries using CTEs, fixing 10s load time

    Vaibhav Pharmacy
    6c2619c
  3. add global exception handler

    Vaibhav Pharmacy
    7575ba7
  4. Force HTTPS connection for Turso to prevent WebSocket hangs

    Vaibhav Pharmacy
    bf58a75
  5. update debug endpoint

    Vaibhav Pharmacy
    dc5b1f6
  6. Add debug endpoint to check Turso env vars

    Vaibhav Pharmacy
    2e4cb34
  7. Deploy Symphony without binary files

    Vaibhav Pharmacy
    892cb85