Database and data case study

Database & Data Orchestration
50+ safe changes in 8 weeks

The database and backend behind the whole product: dozens of tested changes, 20+ cloud functions, private storage for children's photos, real-time live sessions, and a daily report that tells the owner how many people actually used the product.

Data & Backend Database DesignData OrchestrationAnalytics
50+
Database changes
tested, in production
20+
Cloud functions
payments, email, teams, live
8
Weeks
from empty to production
100s
Users served
on web and iOS
Published on Web appiOS appDaily report
Industry
Data & Backend
Timeline
Aug to Oct 2026, dozens of migrations in production
Outcome
50+ safe changes in 8 weeks
Result snapshot

50+ safe changes in 8 weeks

The production database went through more than fifty versioned changes in eight weeks, each one tested first, while serving the website and the iPhone app at the same time. The owner now sees real activity: who did real work, who only browsed, and which features paying users rely on.

Dozens of tested production changes in eight weeks
Private data stays private by design, not by luck
Real usage numbers instead of inflated ones
A backend shared safely by web and iOS
/ The challenge

Where the bottleneck actually was

A product with web and iPhone users, team accounts, payments and player photos needs a backend that is safe, fast and honest. Some data is very private: a coach's squad is the names and faces of young players. And the owner needed to know the truth about usage, not just a sign-up count that included copies and empty boards.

Children's names and photos must never leak into a public feed.
The web app and the iPhone app share one live database, so a bad change breaks both at once.
Raw counts were inflated about two times by copied and empty boards.
Tracking must never slow down or break the product.
/ What we built

A system built around the real workflow

We designed the database to protect people by default. Tables that hold people's data have row-level security, so each person can only reach their own. Squad photos live in a private storage bucket, and a photo becomes public only when the coach switches it on for one specific post. Shared links that should not be listed are served one exact address at a time, never by opening up a table. On top of that we built the data side: where each new account came from, fire-and-forget event tracking that never slows the app, user tiers that separate real work from browsing, and a daily report.

Module 01
A Postgres schema with row-level security on personal data
Module 02
Private and public storage buckets, with a per-post switch for sharing a face
Module 03
Cloud functions for payments, email, sharing, teams and live sessions
Module 04
Real-time channels for live present mode and shared editing
Module 05
Account attribution: where every new sign-up came from
Module 06
User tiers and a daily report that count real work, not just sign-ups
/ For your business

How your business could use this

1

Businesses with scattered data

We bring your customers, orders and activity into one database, with clear rules about who can see what.

2

Owners who want honest numbers

We set up tracking and a daily report that show real usage and where customers come from, without slowing your site.

3

Anyone handling sensitive data

Customer records, documents or photos are locked down with row-level security and private storage from day one.

/ Questions

Common questions

What is row-level security? +

A database rule that decides, row by row, who can read or change data. It means a bug in the app cannot show one customer another customer's records.

Why Supabase? +

It gives a real Postgres database, logins, file storage, real-time updates and cloud functions in one place, which keeps a small team fast without giving up control.

Build profile
Stack
SupabasePostgresRow-level securityRealtimeNetlify FunctionsEdge Functions
Proof source
Total Football Studio, built and run by Naurra
The live backend of Total Football Studio
Next step

Want this outcome in your business?

We scope custom AI systems around the workflow that is already costing you time, margin, or speed.

Book a free consultation
/ Part of one product

One of eight systems behind Total Football Studio

We built and run Total Football Studio ourselves: 30M+ views in the last 3 months and 80K+ followers, all from organic content, and hundreds of users in a couple of weeks. This page is one part of it. Here are the others.

See the whole build
/ More case studies