Technical DevLog & Blog
Diving deep into mobile development architectures, database security, and engineering details
Demystifying Supabase RLS Policies in Real-time Social Applications
When designing the real-time group decision app "Foodie Choice", database isolation and data privacy were core priorities. This article explores how to craft secure PostgreSQL Row-Level Security (RLS) policies, avoid infinite loops using Security Definer helper functions, and ensure secure real-time stream subscription patterns.
Read ArticleBuilding Seamless State Synchronization: Combining Pending Sync Indicators & Optimistic Updates
How do we prevent UI lag or flickering under high-concurrency real-time voting? This post dives into implementing Optimistic UI updates with Riverpod alongside background pending counters to deliver butter-smooth checkbox response times.
Read ArticleCross-platform Calendar Sync: Deep Dive into Google Calendar Templates & Apple Calendar APIs
To let users schedule group gatherings instantly, we need to adapt to iOS default systems and Google Calendar. Learn how we assembled template URLs with UTC timestamp conversions to pop the native system drawers reliably on both ecosystems.
Read Article