Three years ago, I volunteered at a commercial bakery in the city. At 9:30 PM every Saturday, we packed fresh sourdough loaves, baguettes, and croissants that had been baked that very morning.
Then the manager pointed to three giant black garbage bins behind the kitchen alley. Into the trash went over eighty pounds of golden, aromatic, perfectly nutritious food.
When I asked why we could not just walk it over to the shelter, the manager gave me an answer that kept me awake all night:
"By the time someone coordinates a driver, fills out donation paperwork, and finds out which shelter has empty shelf space, the bread goes stale. We do not have the logistics to coordinate it, so into the dumpster it goes."
Globally, we throw away 1.3 billion tons of edible food every single year. That waste accounts for nearly 10% of all planetary greenhouse gases. Yet, across the very same urban avenues, 828 million people face chronic food insecurity, and community soup kitchens struggle with erratic nutritional shortages.
When the DEV Weekend Challenge announced its Generosity Edition in honor of the UN International Day of Charity, I knew exactly what I had to build.
Generosity is not just writing a check or donating pennies. True generosity is eliminating waste and building systems that deliver life-saving abundance to people who need it most.
I spent this weekend building FoodBridge: a real-time food rescue and hunger relief grid powered by Snowflake.
FoodBridge is an open-source humanitarian logistics engine that connects commercial food donors (supermarkets, wholesale produce terminals, bakeries, dining halls) directly with local crisis shelters and soup kitchens in real-time.
Instead of food sitting on loading docks waiting for slow manual phone calls, FoodBridge turns surplus inventory into an automated, sub-second rescue dispatch pipeline: Commercial Surplus Ingestion: Supermarkets and bakeries log surplus batches in seconds with weight, temperature constraints, and dynamic shelf-life decay countdowns. Deficit-Aware Demand Matching: The system constantly aggregates live headcount and nutritional gaps across citywide shelters (such as protein shortages, fresh produce deficits, or dairy needs). Snowflake Analytical Engine: Matches perishable batches with the nearest shelter facing that specific nutritional deficit, ranking deliveries by urgent expiration windows. EPA WARM Carbon Accounting: Every single pound of rescued food is audited using EPA Waste Reduction Model formulas to calculate real metric tons of greenhouse gas averted from landfills.
The Spoilage Clock: Fresh produce and prepared hot meals decay rapidly. If a batch is not matched and routed within 3 to 6 hours, it becomes unusable. Nutritional Equity Deficit: In high-density cities, famous shelters often receive too much bread while smaller neighborhood shelters suffer severe protein shortages. FoodBridge tracks nutritional categories to ensure equitable food distribution. Environmental Impact: According to the US EPA, 1 pound of food waste diverted from a landfill prevents approximately 2.40 kilograms of CO2-equivalent methane emissions.
Live Web Application: https://EmmaSofiaDev.github.io/foodbridge/ GitHub Repository: https://github.com/EmmaSofiaDev/foodbridge
To let judges explore the system without waiting for a commercial store closing shift, FoodBridge includes a full interactive simulation suite:
Live Surplus Inventory Feed: Browse active batches with live countdown badges (Critical, High, Medium) and direct volunteer courier dispatch. Instant Rescue Simulator: Click "Simulate Rescue" in the top bar to log a new batch (e.g. 150 lbs of fresh heirloom produce from Whole Foods) and watch FoodBridge calculate the nearest shelter with an active produce deficit.
Snowflake SQL Console: Click "SQL Console" to inspect and run real production Snowflake queries with sub-second execution times and partition pruning metrics.
Built with a clean, fast stack: Frontend: React 19, Vite, TailwindCSS, Lucide Icons Data Layer: Snowflake Data Cloud architecture (COMPUTEWH, Database: FOODBRIDGEPROD, Schemas: PUBLIC, ANALYTICS)
Most developers assume that humanitarian apps only need a simple CRUD database. But when you are dealing with hundreds of donors, perishable decay curves, spatial routing, and citywide shelter deficits, a standard transactional database chokes.
You need an analytical data warehouse. Here is how I leveraged Snowflake to power FoodBridge: Dynamic Shelf-Life Decay Ranking with Window Functions