Fjord Edu

Overview

I built the booking, payment, and operations platform for a college-admissions consulting academy solo from May through the end of 2025. It combines consultation booking, payment, pre-surveys, document uploads, and administrator assignment, with a FOR UPDATE SKIP LOCKED + Optimistic Locking booking engine and Toss PG handling 300M+ KRW daily revenue without downtime.

My Work

• ▸Carried out planning · UX · design · full-stack development · deployment · operations solo
• ▸Serialized ~2,000 concurrent bookings with FOR UPDATE SKIP LOCKED + Optimistic Locking + RPC
• ▸Integrated Toss PG confirm, recovery, whitelist revocation, and 10-minute hold expiry
• ▸Built one Google · Kakao OAuth callback for identity linking and inactive-account blocking
• ▸Applied Supabase RLS, security definer hardening, and 100+ SQL migrations
• ▸Built admin-editable cms_pages, block visibility, SEO meta, banners, menus, and popups

Features

• First-come slot lookup/booking/payment flow (handling ~2,000 concurrent users)
• Toss Payments approval/refund + payment recovery / automatic whitelist revocation
• Google · Kakao · Email login + account linking on My Page
• Pre-survey questionnaire + administrator CSV export
• Document submission upload (PDF/JPG/PNG/HWP/ZIP · 100MB)
• Page-builder CMS for home, booking, notices, and regular-admission pages

Highlights

• Built solo May–Dec 2025 · light maintenance since
• First-come booking engine (FOR UPDATE SKIP LOCKED + Optimistic Locking + RPC)
• Handled all traffic right after opening · 300M KRW+ daily revenue with zero incidents
• Toss Payments PG approval · refund · pg_cron 10-minute hold auto-expiry
• CMS — page builder · block visibility · banners · menus · popups · per-page SEO meta

Timeline

Tech Stack

</>Next.js · Supabase RLS · Toss PG · first-come booking engine

Links