Python
FastAPI
Redis
PostgreSQLA real-time social media analytics platform that processes engagement data, detects trending hashtags with sliding window counters, and provides viral chain detection through recursive comment analysis. It achieves 70-95% faster query performance through composite database indexing with sub-60ms Redis cache response times.
Unique Features
Trending hashtag detection with sliding window algorithm and Redis caching
Viral comment chain detection using recursive SQL CTEs
Complex SQL aggregations for engagement reports and user analytics
Database indexing achieving 70-95% query performance improvement
Dual interface: REST API + CLI for administration
Deterministic seeding (Faker with fixed seed) for reproducible demos
Tech Stack
BackendFastAPI, Python 3.11+, SQLAlchemy, Alembic, Typer CLI
DatabasePostgreSQL
CachingRedis (with TTL)
Testingpytest