Back to projects
Own product·Solo Developer·2026

Arkireitti

A family task board — for kids without accounts

3
days from idea to working app
16
Postgres functions
6
tables, RLS on all

Problem

A child can’t own an email address or a password — yet a shared family task board still needs authentication and security. How do you give a kid access to their own board without weakening the database’s protection?

Solution

01

Auth for users who can’t have accounts

Kids sign in with a 5-character code drawn from an alphabet with confusable characters removed (no 0/O/1/I). RLS stays strict: child paths go through security definer RPCs that validate ownership server-side on every call.

02

A realtime board

A kid ticks a task on the tablet — the parent’s phone updates instantly via Supabase Realtime. Optimistic mutations with rollback keep the UI immediate.

03

Zero-config onboarding

Database triggers do the provisioning: signup creates the family, codes generate automatically, and a new child gets 10 age-appropriate default routines in one transaction. A second parent joins with a 6-character family code.

Gallery

Arkireitti — two-tier sign-in: kids use a code, parents an account
Arkireitti — two-tier sign-in: kids use a code, parents an account

Highlights

Two-tier auth: child code + parent email
Clock-following routine view (morning / after school / evening)
One codebase: iOS, Android and web — tablet and phone layouts
Timezone-correct "today" (Europe/Helsinki, no UTC-midnight bug)
Orphaned-family cleanup when a parent joins another household

Stack

App
ExpoReact NativeNativeWindTanStack Query
Backend
SupabasePostgres RLSRealtime

Want one like this?

Tell me about your project — I usually reply the same day.