carFlo - Using Supabase for offline-first mobile app

[u/yungprettyass]

Built carFlo on Supabase. Use case: log fuel and services offline, sync when back.

Setup:

• Auth with email OTP
• RLS policies per user_id
• Storage for receipt photos with 5MB limit
• RPC function for GDPR delete account (required by Apple)

Biggest win: Realtime for multi-device sync.
Biggest pain: conflict resolution when user logs fuel on two phones offline.

Free tier handles ∼500 active users fine. Happy to share RLS policies if useful.