Grocery Price Comparison App

• Tech Stack: FastAPI, Python, TyepScript, Postgres, API, Selenium, Web Scraping

Automated Price Aggregation: Built a system with a scheduler to fetch daily prices for staple grocery products from 5 different stores(Walmart, Target, Aldi, HEB, Whole Foods) using external APIs, ensuring the app always shows up-to-date price comparisons.

Fallback & Web Scraping Logic: If a product isn’t available via API or the API fails, the app automatically falls back to web scraping with Selenium to retrieve accurate product prices, ensuring comprehensive coverage.

Database Management & Scheduled Updates: Stores all fetched data in a PostgreSQL database, with a scheduled refresh every morning to maintain the latest pricing information and historical price tracking.

Tech Stack & Scalable Architecture: Implemented using FastAPI for a robust backend, PostgreSQL for data storage, and Selenium for web scraping, providing a scalable solution for real-time price comparison and analytics.

Future Enhancements: Planning to add personalized recommendations for users based on their shopping patterns, along with analytics dashboards to extract insights from the gathered pricing data.