ÂTTN.LIVE
LiveDatabase migration & production rebuild of a creator-first social platform
Overview
ÂTTN.LIVE is a creator-first social platform where artists publish music and stories, collect each other's work as limited editions, and earn through an internal token economy. The platform features AI-powered generation tools for music, stories, and cover art.
I was brought on as the sole developer to migrate the platform off its original SQLite-backed infrastructure and rebuild it as a production-grade Next.js application on Supabase PostgreSQL. The original database had hit usability constraints — SQLite's lack of concurrent writes, limited query capabilities, and no row-level security made it unsuitable for a growing multi-user platform. The migration involved 27 tables of live production data with complex relationships, constraint violations that had accumulated over time, and a complete architectural shift from a client-heavy SPA to a server-first Next.js application.
My Role
Database Migration
Wrote the migration pipeline to move 27 tables from SQLite to Supabase PostgreSQL — handling type conversions, foreign key remapping, and constraint violations in production data. The rebuilt app deployed alongside the original, with a final cutover once validated.
Full-Stack Rebuild
Rebuilt the entire frontend and API layer in Next.js with a server-first architecture — over 100 API endpoints, server-rendered pages, and real-time features.
Technical Decision-Making
Evaluated trade-offs and communicated implications of major architectural decisions to the team before implementation — media storage strategy, payment integration approach, token operation safety, and authentication flow.
Ongoing Development
Continued feature development, bug fixes, and performance work post-launch — AI generation integrations, subscription system, embeddable players, and SEO optimization.
Tech Stack
Frontend
- Next.js 16
- React 19
- TypeScript
- Tailwind CSS 4
Backend
- Supabase PostgreSQL
- Row Level Security
- Supabase Auth
Payments
- Stripe Subscriptions
- Webhook Lifecycle
- Token Economy
Infrastructure
- Vercel
- Cloudflare R2
- Sentry
The Migration
The original platform ran on SQLite — a solid embedded database, but one that doesn't scale for a multi-user social platform. SQLite's single-writer model meant concurrent requests would queue or fail, there was no row-level security for multi-tenant access control, and the lack of native JSON, full-text search, and real-time subscriptions limited what the platform could do. The migration wasn't just moving data — it was rethinking how the data layer should work.
27 Tables, Seamless Cutover
Built a migration pipeline that handled type conversions (SQLite dates to ISO timestamps, integer booleans to native booleans, text PKs vs serial PKs), foreign key remapping across tables, and ID mapping for cross-referenced records. The rebuilt app launched on a new domain, so end users experienced no disruption during the transition.
Production Data Constraints
Real production data had accumulated constraint violations over time — collections that exceeded supply limits, draft posts missing required fields, duplicate edition numbers. Each had to be identified, categorized, and handled without data loss.
Architecture Shift
Moved from a client-heavy React SPA with Cloudflare Workers to a server-first Next.js application — improving SEO, initial load performance, and security by keeping sensitive operations server-side.
Key Features Built
- AI music, story, and cover art generation
- Limited-edition collecting with edition tracking
- Internal token economy with atomic operations
- Stripe subscription tiers with webhook lifecycle
- Private media storage with secure proxy streaming
- Embeddable audio player with oEmbed support
- Weekly prize pool with creator leaderboard
- 100+ API endpoints with per-feature rate limiting
- Google OAuth & email auth with user linking
- SEO with dynamic metadata, JSON-LD, and sitemaps
Links & Resources
Source code is private — this is an active commercial platform