Red Hibiscus
The flower for Ganesha and Kali. Offered singly and by name during archana; wilts within hours of picking.
Where to buy
Every shop that carries it, cheapest in-stock first.
Price, stock and lead time are properties of the AVAILABLE_AT relationship — the same product costs different amounts at different shops, and that fact belongs to the pairing.Product → AVAILABLE_AT → Florist → LOCATED_IN → Location
| Shop | Area | Rating | Price | Availability |
|---|---|---|---|---|
| Sri Kamakshi Flower Stall | T. Nagar | 4.7(412) | ₹7 | In stock · Next day |
| Kapali Flower Mart | Mylapore | 4.3(201) | ₹8 | In stock · Next day |
| Dadar Phool Galli | Dadar | 4.7(891) | ₹8 | In stock · Next day |
| Mylapore Mala Stores | Mylapore | 4.8(638) | ₹8 | In stock · Next day |
| Matunga Pooja Bhandar | Matunga | 4.6(402) | ₹8 | In stock · Next day |
| Indiranagar Blooms | Indiranagar | 4.2(143) | ₹8 | In stock · Next day |
| Kovai Poo Nilayam | R. S. Puram | 4.6(324) | ₹9 | In stock · 2 days |
| Kothrud Phool Ghar | Kothrud | 4.4(176) | ₹9 | In stock · 2 days |
| Meenakshi Flower House | Meenakshi Nagar | 4.9(754) | ₹7 | Out of stock |
8 of 9 shops have it in stock right now.
If you can't get it
Alternatives found by walking the substitution chain up to three hops.
Closeness is multiplied along the chain, so a substitute reached in two hops automatically scores lower than a direct one — no rule had to say so.Product → SUBSTITUTE_FOR*1..3 → Product
There is no accepted substitute for Red Hibiscus.
For items like tulsi, durva grass and bilva leaves this is a real answer, not a gap in the data — the ritual does not permit a stand-in. The graph represents that by the honest means of having no relationship.
Needed for
Every occasion that calls for this, and how much each one needs.
Exactly the same relationship as the checklist, traversed in the other direction and at the same cost. A relational schema would need a second index for this.Occasion → NEEDS → Product (read backwards)
- Ganesh ChaturthiEssential21 pieces
Red hibiscus is Ganesha’s flower. Buy on the morning — they wilt within hours.
- Daily PoojaRecommended5 pieces
Offered fresh each morning; they will not keep to the next day.
How Red Hibiscus connects to Ganesh Chaturthi
The route the graph took, not just the fact that a route exists.
This is the query with no relational equivalent. A join returns rows; the joins that connected them are gone by the time the result exists. Only a graph can hand back the path itself.shortestPath, up to 6 hops
- Red Hibiscus is needed by
- Ganesh Chaturthi
1 hop through the graph