Store locator for a pharmacy chain
Your task
Design the "find a pharmacy near me" feature for a chain of 900 pharmacies. A user shares their location or types an address or postcode, and sees the 10 nearest stores with distance, today's opening hours and whether each store is open now; they can filter to stores with a drive-through or 24-hour service. Store details change a few times a week, and holiday hours are entered in advance. The feature gets about 500,000 searches a day, more during flu season. Describe the data model, how the nearest stores are found, how typed addresses are handled, and how opening hours are computed.
It covers
- Nearest neighbors
- Geocoding
- Opening hours