Skip to main content
← All Case Studies

Running 6 Platforms on a Single Shared Database Architecture

Technical architecture case study on how Blossend operates OpenMyPro, Noizz.io, and 4 other platforms on a shared Supabase PostgreSQL database.

Find your perfect provider in 33 seconds. 150K+ patients already have.

No insurance needed. No waiting weeks. Book today.

150K+ users · Ex-Amazon Engineer · Healthcare Innovation

No card charged today · 33-second booking · HIPAA compliant

Key Metrics

6

Platforms Served

$25/month

Database Cost

150K+

Shared Auth Users

18%

Cross-Platform Users

7 (6 platform + 1 core)

Schemas

99.97%

Uptime

The Problem

As Blossend's ecosystem grew to encompass five distinct platforms — OpenMyPro, Noizz.io, Blossend.com, WeTalkin, and openmydevice.com — the traditional approach of giving each platform its own database would have created an operational nightmare. Six separate databases mean six separate authentication systems, six separate user tables that inevitably drift out of sync, six separate backup procedures, six separate monitoring dashboards, and six separate bills from database providers. For a solo founder, managing this complexity was simply impossible. Beyond the operational burden, separate databases create a fundamental data fragmentation problem: a user who exists on OpenMyPro and Noizz.io would have two separate profiles, two separate login credentials, and no way to leverage their activity on one platform to improve their experience on another. This fragmentation is exactly what plagues large tech companies — Google has spent billions trying to unify user data across Gmail, YouTube, Search, and Android, and still has not fully succeeded. The challenge was designing a database architecture that could support six fundamentally different applications (healthcare marketplace, brand discovery, social network, industrial marketplace, company intelligence, and a corporate hub) while maintaining data isolation where needed, sharing data where beneficial, and scaling efficiently as each platform grew at different rates.

The Solution

Pablo designed a shared Supabase PostgreSQL architecture using a schema-per-platform approach with a unified core schema for shared resources. The core schema contains the universal tables: users (with a single authentication system via Supabase Auth), payments (unified Stripe integration), notifications, and analytics events. Each platform then has its own schema (openmypro, noizz, wetalkin, etc.) containing platform-specific tables — provider profiles and bookings in the OpenMyPro schema, brand profiles and discovery data in the Noizz schema, and so on. PostgreSQL's row-level security (RLS) policies ensure strict data isolation between platforms where needed — a query from the OpenMyPro application can only access the openmypro schema and shared core tables, never the noizz schema directly. Cross-platform features (like a user dashboard showing activity across all Blossend platforms) are implemented through carefully controlled cross-schema views that expose only the necessary columns. The authentication system deserves special mention: a single Supabase Auth instance handles login for all six platforms, meaning a user creates one account and can access any Blossend platform instantly. This dramatically reduces onboarding friction and increases cross-platform adoption. The entire system runs on a single Supabase Pro instance costing $25/month, with connection pooling via PgBouncer handling concurrent connections from all six platform backends.

Results

The shared database architecture enabled Blossend to operate six platforms at a database cost of $25/month — what would typically cost $150-300/month per platform ($900-1,800 total) with separate infrastructure. The unified authentication system was the most impactful decision: 18% of users now interact with multiple Blossend platforms, and cross-platform users generate 34% more revenue than single-platform users. Launching new platforms within the ecosystem became dramatically faster — Noizz.io went from concept to production in 8 weeks largely because 40% of the backend was already built as part of the shared core. The architecture also simplified compliance: HIPAA requirements for OpenMyPro were implemented at the database level through row-level security, meaning the compliance infrastructure benefited all platforms without additional work. Supabase's built-in backup system provides point-in-time recovery across all six platforms simultaneously, and the single monitoring dashboard gives Pablo visibility into the entire ecosystem's health from one screen. The 99.97% uptime over 18 months demonstrated that the shared architecture introduced no reliability penalties compared to isolated databases. Several investors and technical advisors have noted that this architecture is similar to what companies like Salesforce and Shopify use internally, but Blossend achieved it at a fraction of the cost and complexity using modern open-source tools.

Skip the wait. Book a therapist in 33 seconds.

Compare 1,000+ brands instantly. Trusted by founders worldwide.

150K+ users · Ex-Amazon Engineer · Healthcare Innovation

No card charged today · AI-powered matching · 33-second booking

Frequently Asked Questions

How does Blossend run 6 platforms on one database?

Blossend uses a schema-per-platform approach on Supabase PostgreSQL with a shared core schema for users, auth, payments, and analytics. Row-level security ensures data isolation, while cross-schema views enable controlled data sharing.

What does Blossend's database cost?

The entire 6-platform database runs on a single Supabase Pro instance at $25/month, serving 150K+ users across all platforms with 99.97% uptime. This compares to $900-1,800/month for separate databases.

Does the shared database create security risks?

No. PostgreSQL row-level security policies enforce strict data isolation between platform schemas. Each application can only access its own schema plus shared core tables. HIPAA compliance is implemented at the database level.

Get Founder Insights Weekly

Startup lessons, technical deep dives, and behind-the-scenes of building a 14-platform ecosystem. No spam.

Join 150K+ people who found their provider. Start free today.

150K+ users who find therapists, trainers, and nutritionists on OpenMyPro.

150K+ users · Ex-Amazon Engineer · Healthcare Innovation

No card charged today · Cancel anytime · HIPAA compliant

Blossend builds healthcare technology that connects patients with providers. Try it free →

Build your professional portfolio

Free to get started. No card charged today.

Get Started

Tools We Recommend

Find healthcare providers

AI-powered matching. Book a provider in 33 seconds.

Try OpenMyPro

Discover trending brands

Product Hunt-style brand discovery with AI insights.

Explore Brands

AI-Powered Healthcare Tech

The parent company behind OpenMyPro and the Blossend ecosystem.

Learn More

Ready to work together? Get in touch or explore our platforms.

More tools by the same team

Find Healthcare Providers Instantly

AI-powered matching. Book a therapist, trainer, or nutritionist in 33 seconds.

Try OpenMyPro Free

Work With Me

Get updates on new projects, tools, and tech insights.

No spam. Unsubscribe anytime.

Visit Blossend.com →

Explore the full portfolio of independent AI tools and editorial properties at blossend.com.