Production-Grade Architecture.
PostgreSQL RLS & Edge Functions.
SkillVault is a backend engineering portfolio project demonstrating multi-tier Row Level Security, Supabase Edge Functions, Razorpay billing integration, and telemetry analytics.
Core Backend Implementation
Demonstrating system design & database security
Supabase Authentication
Secure Auth flow using Email Magic Links, Passwords, and custom JWT claim injection for role-based system access.
PostgreSQL & Row Level Security
Zero-trust RLS policies isolating data at the database level according to user subscription tiers and roles.
Razorpay Subscription System
Integrated order creation, webhook verification, signature validation, and automated plan upgrades and cancellations.
Supabase Edge Functions
Lightweight Deno serverless endpoints executing core business operations (`create-order`, `verify-payment`, `upgrade-plan`).
Tier-Based Course Access
Dynamic course catalog filtered by user tier (Free, Basic, Premium) with server-side validation and access restrictions.
Telemetry Events & Admin Panel
Event recording for user actions, ad-frequency calculations, and administrative data inspection via custom database RPCs.