RxSpot

We're RxSpot, and we're here to stop that time violence. We're building the first real-time, community-sourced medication locator – powered by Bolt.new.

Comment

RxSpot: Your Real-Time Medication Locator

Inspiration

Our inspiration stems directly from the agonizing reality faced by millions of families: the "10-hour pharmacy hunt." We learned about a mother who spent ten precious hours circling dead-end pharmacies, desperately seeking essential medication for her children. This isn't just an inconvenience; it's systematic 'time violence' that steals 7.4 million parent-hours every single year. We believe this profound human suffering, coupled with a startling lack of existing solutions, makes it the perfect problem for us to tackle head-on with Bolt.new, turning a real pain point into critical infrastructure.

What it does

RxSpot is a revolutionary, real-time, community-sourced mobile-first web application designed to end the frustrating medication search. Our MVP empowers users to:

  • Locate Pharmacies: Find nearby pharmacies based on their current location.
  • Search for Medications: Quickly search for specific medication names across these pharmacies.
  • View Real-Time Stock Status: See the most recently reported availability status ('In Stock', 'Limited Stock', 'Out of Stock') for medications at each pharmacy. This data updates instantly as new reports come in.
  • One-Tap Reporting: Logged-in users can effortlessly report the stock status of a medication at a specific pharmacy with a single tap, contributing to the community's live data.
  • User Authentication: Securely sign up and log in to contribute and benefit from the community data.

How we built it

We leveraged the incredible power and speed of Bolt.new as our primary development platform. Our process involved:

  1. AI-Powered Scaffolding: We initiated our project with a comprehensive prompt on Bolt.new, which rapidly generated the foundational UI, user authentication flows, and initial data models. This allowed us to build out core features in hours, not days.
  2. Supabase Integration: We seamlessly integrated Supabase (leveraging the Startup Challenge opportunity) as our robust backend database. This was crucial for managing pharmacies, medication_status_reports, and users, providing the real-time capabilities essential for live stock updates.
  3. Real-time Data Streams: Utilizing Supabase's real-time subscriptions, we ensured that medication availability data updates instantly across all users, making RxSpot truly dynamic.
  4. Mobile-First Design: From the outset, Bolt.new's responsive capabilities allowed us to build an app optimized for mobile use, ensuring a smooth experience for users on the go.
  5. Rapid Deployment: We continuously deployed our application using Netlify (fulfilling the Deploy Challenge), taking advantage of Bolt.new's integration capabilities to quickly push updates and ensure our app was always live and accessible.

Challenges we ran into

  • Prompt Engineering for Specificity: While Bolt.new is powerful, crafting the perfect initial prompt to get the exact desired UI and Supabase schema required iteration. We learned to be incredibly precise in our instructions to the AI.
  • Real-time Data Consistency: Ensuring that confidence scores and the "most recent" status were always accurately displayed across all users in a real-time environment, while managing potential stale data, required careful thought and and testing of our Supabase queries.
  • Geolocation Accuracy: Integrating user location for "nearby" pharmacies presented minor hurdles in terms of obtaining precise coordinates and efficiently querying by distance within Supabase.
  • UI Simplicity Under Pressure: Designing a clean, intuitive, and calming user interface for a sensitive topic (like finding medication) required constant focus on minimalism and user flow, even within Bolt.new's rapid environment.

Accomplishments that we're proud of

  • A Functional MVP in Record Time: We are incredibly proud to have built a fully working MVP that tackles a critical, unsolved real-world problem within the hackathon's timeframe, demonstrating Bolt.new's true potential.
  • Directly Addressing "Time Violence": We've created a tool that can genuinely save families hours of stress and futile searching, directly addressing the core inspiration behind our project.
  • Seamless Integrations: Successfully implementing core features with Supabase for data management and authentication, and deploying via Netlify, showcases our ability to leverage powerful external tools with Bolt.new.
  • Community-Driven Solution: Building a platform reliant on user contributions for real-time data is a powerful concept, and we're proud of laying the groundwork for this trust-based network.

What we learned

  • The Power of AI-Accelerated Development: Bolt.new truly revolutionized our development speed. We learned how to "speak" to the AI effectively to scaffold complex applications in unprecedented time.
  • Importance of Problem Framing: Starting with a deeply personal and impactful problem (like the 10-hour pharmacy hunt) not only motivated our team but also provided a clear compass for every design and technical decision.
  • Iteration is Key: Even with rapid tools, iterative refinement of prompts, UI, and data models is crucial for building a polished product.
  • Leveraging Partner Ecosystems: The hackathon's focus on integrations pushed us to quickly learn and implement powerful services like Supabase, broadening our development skill set.

What's next for RxSpot

This hackathon MVP is just the beginning for RxSpot. Our vision extends to:

  • Enhanced Confidence Scoring: Implementing a more sophisticated trust algorithm based on user reporting accuracy and frequency.
  • Pharmacy Partnerships: Exploring direct data feeds from pharmacies for verified inventory, moving beyond purely crowd-sourced data.
  • Predictive Availability: Using historical data and AI to predict future medication availability patterns.
  • Insurance Formulary & Pricing Integration: Helping users find pharmacies that accept their insurance and offer the best prices.
  • Telehealth Integration: Connecting users directly with telehealth providers for prescription refills if needed.
  • Alerts & Notifications: Allowing users to set alerts for specific medications becoming available within a certain radius.
  • Scaling & Monetization (Phase 2 & 3): Transitioning to a sustainable model through anonymous aggregated data for manufacturers, and exploring telehealth/insurance platform opportunities, all while maintaining the core free utility.

Our goal is for RxSpot to become the essential infrastructure that ends the 10-hour pharmacy hunt once and for all, giving back millions of hours to families.

Built With

Share this project:

Updates