Freelancers in CopthorneFreelancers in Copthorne
I animate interactive, gamified worlds 🚀
$25k+
Earned
11x
Hired
5.0
Rating
216
Followers
I animate interactive, gamified worlds 🚀
Education(2)
Websites that fill your pipeline with ready-to-buy leads
$50k+
Earned
15x
Hired
5.0
Rating
138
Followers
Websites that fill your pipeline with ready-to-buy leads
Education(1)
Cyber expert specialising in Azure Security Services.
$10k+
Earned
4x
Hired
5.0
Rating
19
Followers
Cyber expert specialising in Azure Security Services.
Education(1)
Brand Design✦UI design✦Front-end development.
$25k+
Earned
5x
Hired
5.0
Rating
64
Followers
Brand Design✦UI design✦Front-end development.
Education(2)
Premium Sites • Products • UX/UI • Brands | Design Partner
$10k+
Earned
5x
Hired
5.0
Rating
100
Followers
Premium Sites • Products • UX/UI • Brands | Design Partner
Education(1)
Founder · Full-Stack & AI Engineer · 15+ Projects
$1k+
Earned
1x
Hired
5.0
Rating
46
Followers
Founder · Full-Stack & AI Engineer · 15+ Projects
Cover image for Excited to share some of
Excited to share some of the backend work I've been doing lately with Supabase! 🚀 Here's a look at what went into building a production-ready backend from scratch: 🗄️ Database Schema Design Designed a relational schema with multiple interconnected tables: profiles, notes, reminders, conflicts, and a dedicated user_keys table for encryption key management. Every table has proper foreign key relationships, timestamps, and nullable/non-nullable constraints enforced at the DB level. 🔒 Row Level Security (RLS) Every single table has RLS enabled with two policies: users can only access their own rows, and anonymous access is blocked entirely. No exceptions. Security is enforced at the database layer, not just the application layer. 🔑 Auth & Email Flows Set up Supabase Auth with email + OAuth support, including full PKCE flow for secure token exchange. Configured deep link redirects for email confirmation and password reset flows, all tested end to end. ⚡ Edge Functions Built and deployed multiple Supabase Edge Functions handling AI processing pipelines, including JWT validation at the top of every function before any processing begins. The OpenAI API key lives exclusively in Supabase secrets, never in the app or any config file. 🔄 Merge Pipeline Built a follow-up note merge pipeline as an Edge Function. New facts are appended to existing profiles, duplicates are detected and skipped, conflicts are logged, and resolved reminders are handled gracefully. 📦 Migrations All schema changes go through versioned migration files under source control. No manual dashboard changes. CI/CD triggers migrations automatically on merge to main. 🔐 Encryption Architecture Client-side AES-GCM encryption via CryptoKit. Plaintext never sits in the database. Encryption keys are stored in a dedicated RLS-scoped table, fetched after login, and held in memory only for the session duration. Still a lot more to share about this project. Excited to talk about it publicly when it launches! 👀
5
5
1.3K
Education(2)