Project Overview
The traditional travel and event insurance model is heavily burdened by claims paperwork, manual verification, and delayed payouts, creating a frustrating experience for both merchants and consumers. Our client wanted to revolutionize this space by creating a B2B parametric "rain protection" platform. The platform needed to integrate into third-party booking flows (via APIs and plugins), ingest massive streams of real-time weather data from official meteorological sources, and automatically trigger instant cash payouts to end-consumers when specific rain thresholds were met—all without a single claims form.
PostgreSQL & PostGIS Foundation
We built the core infrastructure on Supabase's managed PostgreSQL. To handle the complex location matching between customer bookings and official Bureau of Meteorology weather stations, we heavily utilized the PostGIS extension, allowing for incredibly fast, accurate spatial queries.
Edge Functions for Real-Time Processing
To ensure the system could automatically evaluate parametric payout conditions, we deployed Supabase Edge Functions. These functions securely process incoming real-time webhooks from global weather APIs and instantly calculate if a policy's rain threshold has been breached, initiating a payout via Stripe Connect immediately.
Have a similar challenge?
Our experts can help you build custom integrations and plugins tailored to your business workflows.
Strict Multi-Tenant Isolation via RLS
Because this is a B2B platform servicing multiple distinct merchants, data privacy is paramount. We implemented strict Row Level Security (RLS) policies directly at the Postgres database layer. This guaranteed that even if an API endpoint was compromised, merchants could mathematically only access their own specific policy ledgers.
Supabase Realtime Subscriptions
We utilized Supabase Realtime to power the merchant dashboard. Instead of aggressive client-side polling, the React frontend subscribes to Postgres row changes via WebSockets, instantly reflecting newly purchased policies and triggering live payout notifications.
Key Challenges
Challenge 1
Ingesting and processing extremely high-volume, real-time meteorological data streams without bottlenecking the primary transactional database.
Challenge 2
Matching customer booking locations to hyper-local weather station data requiring complex geo-spatial querying.
Challenge 3
Ensuring strict multi-tenant data isolation so integrated B2B merchants could securely manage their own customers' policies without data leakage.
Challenge 4
Building a highly responsive merchant dashboard that instantly reflects policy statuses and automated payouts.
Results & Outcomes
By leveraging Supabase as a comprehensive Backend-as-a-Service, MetaDesign Solutions delivered a highly scalable MVP in under 8 weeks. The platform achieved its goal of a 100% automated, zero-claims payout process. The combination of PostGIS and Edge Functions allowed the system to smoothly process thousands of concurrent geo-spatial weather data points daily, all while maintaining enterprise-grade security and isolation through Postgres RLS.
