ReliefTrace — Aid You Can Actually Verify | DEV Weekend Challenge

This is a submission for Weekend Challenge: Generosity Edition What I Built ReliefTrace is a disaster relief coordination dashboard built for DEV Community's Weekend Challenge: Generosity Edition. Anyone can log a relief contribution — no account, no payment. It's instantly written to Snowflake and anchored on a public Solana blockchain transaction, so every delivery has a permanent, verifiable record. An AI (Google Gemini) reads live district-level need data and generates a prioritized situation briefing, and you can ask it questions in plain English. Demo https://www.youtube.com/watch?v=z_tq2JHoxLI Project url: https://relief-trace-mono-repo.vercel.app/ Code https://github.com/Gauravkumar6617/ReliefTrace-mono-repo How I Built It The problem: during disaster relief, two things are hard to trust: where need is actually unmet (not pledges, but requested minus delivered), and whether a donation really happened. Snowflake — Need estimates aren't arbitrary: they're built from real affected-population data (2024 Assam floods, 2025 Punjab floods) run through Sphere Handbook humanitarian standards (15L water/person/day, ~2.1kg food/person/day, etc.). Every dashboard panel is a real SQL query, cached in Redis for speed. Solana (devnet) — Every contribution fires a Memo-program transaction encoding district, resource, quantity, and donor. The signature is stored back in Snowflake and linked as "Verify on-chain" — a public, tamper-proof record instead of an editable spreadsheet number. Google AI (Gemini) — Two core integrations, both grounded in live data: (1) an AI Situation Briefing that ranks districts by urgency with confidence scores and specific actions, and (2) "Ask ReliefTrace" — Gemini uses function-calling to decide which live Snowflake query answers your question, then responds with real numbers, not guesses. Stack: FastAPI + Snowflake pooling, React + Vite with live SSE updates, PDF export, email confirmation. Deliberately no logins, payments, or admin panels — this tracks physical aid, not money, and that scope kept the build honest and shippable in a weekend. Prize Categories Submitting to: Best Use of Snowflake Best Use of Solana Best Use of Google AI