Budget: 26460 UAH Deadline: 7 days
Hello!
I have experience with Supabase/PostgreSQL focusing on performance and RLS. I am ready to take on the entire backend of your application: from setting up pooling to transferring logic from AppSheet to the database and writing RPC functions.
What I will do:
1. Enable and configure pgBouncer (pooled connection) --> we will resolve MaxClientsInSessionMode
2. Optimize the schema and indexes (levels, groups, schedule, attendance, grades).
3. Move calculations to SQL views (vw_schedule_today, vw_teacher_schedule, vw_students_in_group) — AppSheet works only as UI
4. Configure RLS for Admin/Teacher roles with full data isolation
5. Write RPC/triggers for bulk operations (cloning/moving schedules, auto-updating colors/statuses)
6. Add seed (~20k rows) and a simple performance test for 20 concurrent connections
7. Provide documentation (connection, RLS, pooling, RPC call)
Estimate: 42 hours, $630
Deadline: up to 7 working days
I work transparently: a separate git repository for migrations/SQL, intermediate demos
1. What is the Supabase plan (Free/Pro) and is the pooled connection string available?
2. Source of the holiday calendar for cloning (holidays table or list? timezone?)
3. Current "heavy" formulas/filters in AppSheet — can I get examples of queries/screenshots?
4. Do you use JWT claims for Admin/Teacher roles, or should I create a mapping in the database?
5. Are there requirements for materialized views/auto-refresh (every N minutes, on trigger)?
6. Migration of IDs: can we make uuid default gen_random_uuid() and gradually transition AppSheet?
7. Peak update times (morning/evening) — we will set up pooling and indexes for this.