Maha Shivaratri
A night-long vigil with abhishekam every three hours. Bilva leaves and vibuthi in quantity, and nothing that flowers loudly.
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
Offered in threes, unbroken. The single most important item of the night.
₹108for 5 bunches- ₹23for 1 packet
- ₹26for 1 packet
- ₹62for 2 packets
- ₹85for 2 pieces
- ₹115for 2 packets
- Malleshwaram Pooja Samagri· Malleshwaram · ₹101 / packet · Next day₹202for 2 packets
- ₹210for 1 bottle
Abhishekam is repeated every three hours through the night.
₹612for 2 sets- ₹90for 20 pieces
- ₹106for 20 pieces
- ₹63for 1 dozen
- ₹306for 1 piece
- ₹370for 1 set
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: Arali (Oleander), Camphor, Bananas, Brass Bell
Still needed elsewhere: Nandiyavattai, Arali (Oleander), Bilva Leaves, Camphor
Still needed elsewhere: Nandiyavattai, Arali (Oleander), Camphor, Vibuthi +4 more
Still needed elsewhere: Nandiyavattai, Arali (Oleander), Agarbathi, Vibuthi +4 more
Still needed elsewhere: Agarbathi, Camphor, Vibuthi, Coconut +7 more
Still needed elsewhere: Agarbathi, Camphor, Vibuthi, Coconut +7 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
Offerings & Prasad(4)
Oil Lamps(2)
- Sesame OilEssential1 bottle₹210est.
- Cotton WicksEssential1 packet₹25est.
Sacred Leaves(1)
- Bilva LeavesEssential5 bunches
Offered in threes, unbroken. The single most important item of the night.
₹125est.
Sacred Powders(1)
- VibuthiEssential2 packets₹70est.
Archana Flowers(2)
- NandiyavattaiRecommended20 pieces₹100est.
- Arali (Oleander)Recommended20 pieces₹120est.
Ritual Vessels(2)
- Brass BellRecommended1 piece₹340est.
- Panchapatra & SpoonRecommended1 set₹420est.
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 Nandiyavattai and Arali (Oleander)
Jaggery
Bought by 21 people who also picked up Nandiyavattai and Arali (Oleander)
Banana Leaves
Bought by 19 people who also picked up Nandiyavattai and Arali (Oleander)
Betel Leaves & Nuts
Bought by 19 people who also picked up Nandiyavattai and Arali (Oleander)
Rangoli Powder
Bought by 19 people who also picked up Nandiyavattai and Arali (Oleander)
Turmeric Powder
Bought by 19 people who also picked up Nandiyavattai and Arali (Oleander)
Mango Leaves
Bought by 18 people who also picked up Nandiyavattai and Arali (Oleander)
Marigold (Loose)
Bought by 17 people who also picked up Nandiyavattai and Arali (Oleander)
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