1:"$Sreact.fragment" 2:I[91389,["/_next/static/chunks/2ed6eae27488c804.js","/_next/static/chunks/ea6bdb0d940bcd8e.js","/_next/static/chunks/1b9de13dee5dc3c5.js"],"default"] 3:I[97367,["/_next/static/chunks/ff1a16fafef87110.js","/_next/static/chunks/d2be314c3ece3fbe.js"],"OutletBoundary"] 4:"$Sreact.suspense" 0:{"buildId":"Df2hj_4RYX21aRrIZjB45","rsc":["$","$1","c",{"children":[["$","main",null,{"className":"min-h-screen bg-[#F8F9FA]","children":["$","$L2",null,{"project":{"id":"borkow","title":"Borkow","description":"A premium, full-stack, location-based social discovery and community networking app built with Flutter and Supabase, featuring swipe-based discovery, real-time chat, and paywalled features.","image":"https://images.unsplash.com/photo-1511632765486-a01980e01a18?w=800&q=80","link":"/portfolio/borkow","category":"Social Networking","year":"2025","duration":"7+ Months","technologies":["Flutter","Supabase","Dart","TypeScript","Stripe API","Riverpod"],"features":["Tinder-style swipe deck with responsive gestures and haptic triggers.","Instant mutual matching using secure PostgreSQL RPC bypass functions.","Smart message requests to prevent chat inbox spam.","Supabase real-time WebSocket sync for messaging, read receipts, and typing states.","Passport location spoofing with global cities database search.","Dual payment gateways with Google Play / Apple App Store billing and Stripe checkouts.","Active sessions portal tracking device info, IPs, and remote logout controls.","Bidirectional user blocking and instant content moderation reporting."],"challenge":"Managing high-concurrency likes and database race conditions when two users like each other simultaneously. Verifying receipt payloads from Google Play, Apple App Store, and Stripe web payments securely server-side was complex.","solution":"Wrote a custom PostgreSQL RPC function running outside default Row-Level Security (RLS) policies to check and record mutual matches atomically. Deployed custom Supabase Edge Functions in TypeScript to securely validate App Store, Google Play, and Stripe checkout receipts before upgrading user tiers.","results":["Atomic mutual-match detection via custom PostgreSQL RPC functions.","Cross-platform billing verification across Google Play, Apple, and Stripe.","Real-time WebSocket messaging with read receipts and typing indicators.","Published on both Google Play Store and Apple App Store."],"playStoreLink":"https://play.google.com/store/apps/details?id=com.borkow.app&pcampaignid=web_share","appStoreLink":"https://apps.apple.com/pk/app/borkow/id6761169964","liveLink":"https://play.google.com/store/apps/details?id=com.borkow.app&pcampaignid=web_share"}}]}],[["$","script","script-0",{"src":"/_next/static/chunks/1b9de13dee5dc3c5.js","async":true}]],["$","$L3",null,{"children":["$","$4",null,{"name":"Next.MetadataOutlet","children":"$@5"}]}]]}],"loading":null,"isPartial":false} 5:null