Pongal
The harvest festival. Rice is boiled over in a new clay pot at sunrise, and sugarcane and turmeric plants are set at the door.
Where to buy each item
Every item on the list, resolved to a shop that has it in stock.
A four-hop traversal. The trailing variable-length step is what lets “Chennai” match a florist registered in T. Nagar without you having to know that.Occasion → NEEDS → Product → AVAILABLE_AT → Florist → LOCATED_IN → Location → PART_OF*0..3
- ₹135for 10 pieces
- ₹26for 1 packet
Tied at the door with turmeric plants still rooted.
₹53for 2 bunches- ₹41for 1 packet
- ₹127for 3 pieces
- ₹126for 2 dozen
Sakkarai pongal is jaggery, rice and ghee — buy more than you think.
₹169for 2 kg- Malleshwaram Pooja Samagri· Malleshwaram · ₹101 / packet · Next day₹101for 1 packet
The largest kolam of the year is drawn on Pongal morning.
₹138for 1 set- ₹58for 1 kg
- ₹75for 1 dozen
- ₹106for 1 kg
Fewest stops
Which single shop covers the most of this list — because visiting four shops on a festival morning is not realistic.
Traverse out to every vendor, then aggregate back per vendor while remembering which items were never covered. In SQL this needs a four-table join, a GROUP BY, and a correlated NOT EXISTS per checklist item.aggregate back over the traversal
Still needed elsewhere: Mango Leaves, Camphor, Bananas
Still needed elsewhere: Turmeric Powder, Rangoli Powder, Coconut, Akshata +1 more
Still needed elsewhere: Banana Leaves, Camphor, Turmeric Powder, Coconut +3 more
Still needed elsewhere: Camphor, Turmeric Powder, Rangoli Powder, Coconut +5 more
Still needed elsewhere: Camphor, Turmeric Powder, Rangoli Powder, Coconut +5 more
The full checklist
Grouped by category, essentials first. Quantities and notes come from the relationship between this occasion and each item.
The quantity, the unit, the importance and the note all live on the NEEDS relationship — not on the flower and not on the occasion. That is the clearest single argument for modelling this as a graph.Occasion → NEEDS → Product → BELONGS_TO → Category
Incense & Camphor(1)
- CamphorEssential1 packet₹90est.
Offerings & Prasad(5)
- CoconutEssential3 pieces₹135est.
- BananasEssential2 dozen₹140est.
- ₹180est.
- AkshataEssential1 packet₹30est.
- Puffed Rice (Pori)Recommended1 kg₹60est.
Sacred Leaves(2)
- ₹60est.
- Banana LeavesEssential10 pieces₹150est.
Sacred Powders(2)
- Turmeric PowderEssential1 packet₹45est.
- ₹150est.
Loose Flowers(1)
- Marigold (Loose)Recommended1 kg₹120est.
Oil Lamps(1)
- Clay DiyasRecommended1 dozen₹80est.
Others also bought
Discovered from real purchase history, not from anything an editor curated.
Three hops through the purchase history: what does this occasion need, who bought those things, and what else did those people buy.Occasion → NEEDS → Product ← BOOKS ← Customer → BOOKS → Product
Kumkum
Bought by 23 people who also picked up Marigold (Loose) and Mango Leaves
Agarbathi
Bought by 21 people who also picked up Marigold (Loose) and Mango Leaves
Cotton Wicks
Bought by 21 people who also picked up Marigold (Loose) and Mango Leaves
Betel Leaves & Nuts
Bought by 19 people who also picked up Marigold (Loose) and Mango Leaves
Jasmine (Malli)
Bought by 16 people who also picked up Marigold (Loose) and Mango Leaves
Sesame Oil
Bought by 16 people who also picked up Marigold (Loose) and Mango Leaves
Ghee
Bought by 15 people who also picked up Marigold (Loose) and Mango Leaves
Vibuthi
Bought by 13 people who also picked up Marigold (Loose) and Mango Leaves
Coming up next
What this occasion usually precedes — worth buying for at the same time.
Occasions are sequenced in the graph, so the app can suggest buying once for two events instead of twice.Occasion → PRECEDES → Occasion