Click to Zoom
Real-Time Price Intelligence at Scale
Grocery Price Tracker is a full-stack database management and price monitoring application designed to track grocery prices across different supermarkets in real-time.
Database & Performance Optimization
- PostgreSQL Database: Designed the relational schema and normalized tables for prices, items, and retail stores. Optimized database performance to process over 10,000+ daily price updates.
- Sub-200ms Queries: Delivered basket price comparisons in under 200ms by implementing smart caching, indexed aggregations, and query optimization techniques.
- Indexed Aggregations: Applied composite and partial indexes on frequently queried fields like store items and prices, allowing lightning-fast data retrieval over large datasets.
Scraping & Alerting Infrastructure
- Robust Scraping Engine: Engineered an automated scraping pipeline to scrape and ingest product prices across 50+ stores concurrently on a scheduled cron sequence.
- Smart Caching: Built a custom Redis/in-memory caching layer to store transient store prices and reduce database workload during peak search hours.
- Real-Time Alerts: Integrated an asynchronous alerting pipeline that monitors price changes and instantly notifies users of drops in their watched grocery baskets.