Interest Rate Comparer

A comprehensive full-stack web application for comparing savings account interest rates across UK banks. This application combines AI-powered web scraping, a modern React frontend with filtering capabilities, and a robust ASP.NET Core backend with PostgreSQL database.

Recording.mp4

YoutubeLink

Features

• AI-Powered Scraping: Automated data collection using Gemini Computer-use-preview model. Following this repo: https://github.com/google/computer-use-preview
• Frontend Filtering: Multi-criteria filtering with quick filter presets
• Comprehensive Data Model: 15+ fields covering all aspects of accounts

Tech Stack

Backend

• ASP.NET Core 9.0 - Web API framework
• Entity Framework Core - ORM for database operations
• PostgreSQL - Primary database
• Dapper - High-performance data access
• OpenAI API - AI-powered data processing
• Google Gemini API - Alternative AI processing
• Swagger - API documentation

Frontend

• React 18 - UI framework
• Material-UI (MUI) - Component library
• MUI DataGrid - Advanced table component
• Axios - HTTP client

Scraping & Automation

• Python - Scraping scripts
• BeautifulSoup - HTML parsing
• Playwright - Browser automation
• SmartScraperGraph - AI-powered scraping
• Computer Use Preview - Advanced automation framework

Architecture

┌─────────────────┐    ┌─────────────────┐    ┌─────────────────┐
│   React Frontend│◄──►│ ASP.NET Core API│◄──►│  PostgreSQL DB  │
│                 │    │                 │    │                 │
│ • DataGrid UI   │    │ • REST Endpoints│    │ • Savings Data  │
│ • Filtering     │    │ • Swagger Docs  │    │ • Account Types │
│ • Real-time     │    │ • CORS Enabled  │    │ • Rate Details  │
└─────────────────┘    └─────────────────┘    └─────────────────┘
         │                       │                       │
         └───────────────────────┼───────────────────────┘
                                 ▼
                    ┌─────────────────────┐
                    │  Python Scrapers    │
                    │                     │
                    │ • AI-Powered        │
                    │ • Multi-Method      │
                    │ • Automated Updates │
                    └─────────────────────┘

Prerequisites

• .NET 9.0 SDK - For backend development
• Node.js 16+ - For frontend development
• Python 3.8+ - For scraping scripts
• PostgreSQL 12+ - Database server