Prosper Enwerem Tochukwu Logo
Back
DemoCode

Healthcare Platform

A healthcare platform designed to help users locate nearby medical facilities and services. Features real-time data integration and user-friendly interface for emergency and routine medical needs.

Brief icon

Brief

Motivation

Many patients struggle to locate prescribed medications quickly. Lack of real-time drug availability information leads to treatment delays and avoidable complications. MedMap bridges patients to accessible, reliable healthcare by surfacing nearby pharmacies that stock requested medications and offering AI guidance. The software was presented in a state hackathon and took 4th place

Challenges

  • •No reliable, real-time visibility into drug availability across pharmacies
  • •Slow manual discovery and navigation to pharmacies that actually stock a drug
  • •Users lack quick, trustworthy guidance on drug usage and side effects
  • •Scaling data ingestion and search while keeping UX simple

Solutions

  • •Implemented medication search with proximity-based sorting and clear availability signals
  • •Integrated map and directions for fast route planning to pharmacies
  • •Added an AI assistant to explain usage, warnings, and side effects for common medications
  • •Structured data model for pharmacies and inventories to support future real-time sync

Impact

MedMap reduces time-to-medication by guiding users to nearby locations that are likely to have their prescriptions in stock, while the AI assistant improves understanding and safe usage. The approach lays a foundation for live inventory syncing and nation-wide scale.

Architecture icon

Architecture

System Overview

MedMap follows a modular web architecture with a React frontend, a Node.js/Express API, and PostgreSQL managed via Drizzle ORM. It integrates Google Maps services for geospatial features and an AI layer for medication guidance.

System Flow

Users search for medications → frontend queries the API → API filters pharmacies by inventory and distance → results are sorted by proximity and availability → users view map pins and directions. The AI assistant answers medication questions using curated data.

Technology Choices

Backend

Express.jsExpress.js

Minimal, flexible HTTP layer for REST

WebSockets

Socket.io, for real time communication with AI chat bot

Deployment

Vercel

Seamless hosting for the frontend with CI/CD

Frontend

ReactReact

Modern, performant UI with React 18

Tailwind CSSTailwind CSS

Rapid, consistent styling system

OpenStreetMapOpenStreetMap

For geospatial features and distance calculations, and map view

Database

PostgreSQLPostgreSQL

Reliable relational store with geospatial extensions

DrizzleDrizzle

Type-safe schema and migrations with great DX

Key Features

  • •Medication search with proximity-based ranking
  • •Map visualization with directions to pharmacies
  • •AI assistant for usage, warnings, and side effects
  • •Scalable data model for pharmacy inventories
Database Design icon

Database Design

Database Overview

Schema centers on pharmacies, medications, and an inventory join to represent stock and pricing. Designed to support future real-time sync and geospatial querying.

MedMap Database Schema

Core tables include pharmacies, medications, and pharmacy_inventories with quantity and price fields; future extensions can add live sync and auditing.

Design Decisions

  • •Normalized tables for clean relationships and predictable queries
  • •Geolocation fields on pharmacies for proximity sorting
  • •Indexes on medication name/code and pharmacy location
  • •Inventory row versioning support for future real-time updates

Database Tables

pharmacies

Registered pharmacies with geolocation and metadata

medications

Catalog of drugs with generic/brand names and tags

pharmacy_inventories

Stock availability, quantity, and pricing per pharmacy

search_logs

Anonymous search analytics for improving results

Challenges & Solutions icon

Challenges & Solutions

Challenge Overview

Delivering trustworthy availability and guidance required careful data modeling, geospatial processing, and an AI layer that remains helpful and safe.

1

Proximity-based Ranking for Medication Search

Users need nearby options surfaced first, while still seeing availability context.

2

Actionable Map and Directions UX

Search results must translate into clear navigation and decision-making on a map.

3

Helpful AI Guidance on Medications

Users want quick, reliable information on usage, side effects, and warnings.

Key Learnings

The solution combines geospatial ranking, clear navigation, and AI assistance to reduce time-to-medication and support safer usage.