GK
AboutSkillsProjectsCertificatesContact
00:00:00
AboutSkillsProjectsCertificatesContact
Crafted with pixels & logic© 2026 Gautham Krishna. All rights reserved.
SocialPulse
Back to Projects

SocialPulse

Real-time Analytics Engine

pythonPythonfastapiFastAPIredisRedispostgresqlPostgreSQLSQLAlchemyReal-time

A 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