Wanted to share a project I just shipped - a portfolio tracker with real-time price updates.
**Tech stack:**
- Frontend: Next.js + Lovable (AI-assisted dev)
- Backend: Supabase (Postgres + Edge Functions + Realtime)
- Deployment: Vercel
- API: Yahoo Finance for price data
**Architecture highlights:**
**Edge Functions** for price fetching (avoids CORS, caches results)
**Supabase Realtime** for live portfolio updates across tabs
**RLS policies** for secure multi-user data isolation
**price_cache table** to minimize API calls (5-min TTL)
Built in ~7 days. Code is a bit messy but it works.
Link: https://wealthwise.vercel.app
(It's a finance app, not the typical SaaS template 馃槄)
Open to architecture feedback - especially around:
- Handling traffic spikes (currently on Supabase free tier)
- Optimizing Postgres queries for portfolio calculations
- Better caching strategies
Happy to discuss the implementation if anyone's building something similar!
Accomplished-Scar854 shared a project involving a real-time finance dashboard using Supabase Edge Functions and Realtime subscriptions. The project uses Next.js for the frontend and Vercel for deployment. Key features include price fetching with Edge Functions and live updates with Supabase Realtime. The user seeks feedback on handling traffic spikes and optimizing Postgres queries.
Real time is very resource hungry.
Have you experienced that?
Kudos. Interested to understand how you implemented the price fetch using Yahoo Finance and Supabase Edge functions. From what I heard, Yahoo aggressively stops bots from fetching prices and the IP ranges from a lot of serverless cloud compute providers get banned from using Yahoo's APIs