Creator Monetization PlatformLive

PixEarn

A production-grade platform serving 45,000+ Monthly Views & 19,000+ Monthly Active Users with real-time analytics, revenue distribution and more.

[01]Overview

Designed and deployed a creator platform handling 1.2M+ queries monthly with <100–150ms average response time.

Challenge

Built and scaled real-time impression and engagement analytics, handling high-concurrency database traffic while enforcing row-level security with PostgreSQL RLS.

Solution

Implemented edge-optimized SSR, custom database indexing, and a Sharp-driven image processing pipeline reducing storage costs by 40%.

[02]Architecture

pixearn — architecture.mmd

Click to zoom · drag to pan

[03]Decisions

PostgreSQL row-level security for tenant isolation

WhyHigh-concurrency creator/viewer traffic needed per-creator data isolation enforced consistently.

ApproachPostgreSQL RLS policies enforce row-level access control alongside custom indexing for the analytics query paths.

Outcome1.2M+ monthly queries at <150ms avg response.

Sharp-driven image pipeline for storage cost

WhyStorage costs scaled directly with creator uploads.

ApproachA Sharp-based image processing pipeline handles uploads before they hit storage.

Outcome40% reduction in storage costs.

[04]Impact

→45,000+ Monthly Views
→19,000+ Monthly Active Users
→1.2M+ Monthly Queries
→98+ Lighthouse Performance Score
→1,200+ Creators Joined

[05]Writing

I Had the Index. My Query Was Still Timing Out.

A Postgres RPC with the exact right index still threw 57014 statement timeouts at 1.4M calls a day. The index was fine — the predicate wrapped the column in arithmetic and made it unusable.

Back to work Next — CreatorJot