Daily Pooja
The morning lamp. A few flowers, a wick, a pinch of kumkum — the smallest and most repeated ritual there is, and the one most households actually shop for week to week.
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
- ₹23for 1 packet
- ₹31for 1 packet
- ₹35for 1 packet
- ₹58for 1 packet
Two tablets a day for the closing aarti.
Malleshwaram Pooja Samagri· Malleshwaram · ₹101 / packet · Next day₹101for 1 packetOne bottle lasts a household roughly a month of daily lamps.
₹210for 1 bottleLit first and put out last. Bought once, not weekly.
₹1,392for 1 pieceThe everyday archana flower for Shiva.
₹45for 10 piecesOffered fresh each morning; they will not keep to the next day.
₹37for 5 piecesA few leaves a day if the household keeps a Vishnu altar.
₹18for 1 bunch- ₹106for 0.25 kg
For the weekly rather than the daily observance.
₹42for 1 piece- ₹75for 1 dozen
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: Camphor, Kumkum
Still needed elsewhere: Red Hibiscus, Nandiyavattai, Camphor
Still needed elsewhere: Red Hibiscus, Nandiyavattai, Camphor, Vibuthi +2 more
Still needed elsewhere: Red Hibiscus, Nandiyavattai, Agarbathi, Vibuthi +4 more
Still needed elsewhere: Agarbathi, Camphor, Kumkum, Vibuthi +5 more
Still needed elsewhere: Marigold (Loose), Agarbathi, Camphor, Kumkum +6 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(2)
- AgarbathiEssential1 packet₹60est.
- ₹90est.
Oil Lamps(4)
- ₹210est.
- Cotton WicksEssential1 packet₹25est.
- ₹1,450est.
- Clay DiyasOptional1 dozen₹80est.
Archana Flowers(2)
- ₹40est.
- ₹50est.
Loose Flowers(1)
- Marigold (Loose)Recommended0.25 kg₹120est.
Sacred Leaves(1)
- ₹20est.
Offerings & Prasad(1)
- ₹45est.
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
Akshata
Bought by 21 people who also picked up Marigold (Loose) and Red Hibiscus
Jaggery
Bought by 21 people who also picked up Marigold (Loose) and Red Hibiscus
Banana Leaves
Bought by 19 people who also picked up Marigold (Loose) and Red Hibiscus
Betel Leaves & Nuts
Bought by 19 people who also picked up Marigold (Loose) and Red Hibiscus
Rangoli Powder
Bought by 19 people who also picked up Marigold (Loose) and Red Hibiscus
Turmeric Powder
Bought by 19 people who also picked up Marigold (Loose) and Red Hibiscus
Mango Leaves
Bought by 18 people who also picked up Marigold (Loose) and Red Hibiscus
Bananas
Bought by 16 people who also picked up Marigold (Loose) and Red Hibiscus