Hello

(Overview)
TheregistrationandeventoperationssystemfortheMountainofSolutionYouthFellowshipConvention2026,heldinOctober2026.AdminsgenerateregistrationlinksandQRcodes,membersregisterandreceiveanIDandaprintabletagbyemail,andstaffruncheck-in,mealandsouvenirclaimsandactivitiesfromthesamesystem.
(Architecture)
AReact19andTypeScriptapponVercel.Supabasehandlesauthentication,Postgreswithrow-levelsecurity,realtimeupdates,edgefunctionsandphotostorage,andResendsendseachmemberaconfirmationemailwiththeirtagandaprivatelinktoastatuspage.Membersneverneedanaccount.Staffsigninwithrole-basedaccessforsuperadmins,adminsandexecutives.
(Engineering)
Membersareplacedintobalancedgroupsautomaticallybyband,withaseparategroupformemberswithoutone.Check-inandclaimsrunthroughidempotentdatabasefunctionskeyedbyaclienteventID,soaqueueofactionsrecordedofflinecanbereplayedwithoutcountingamealorsouvenirtwice.Bands,departments,groupsandchurchlocationsareliststhatadminsmanage,andafirst-runsetupwizardreplaceshardcodedseeddata.
DesignedtheSupabaseschema,row-levelsecuritypoliciesanddatabasefunctions.
Builttheregistrationflow,memberandexecutiveIDs,printabletagsandconfirmationemails.
Builtcheck-inandclaimtrackingwithduplicatepreventionthatissafetoreplayoffline.
Ledtheinterfaceredesignandtheadminsetupwizard.
Gallery


Built with
Explore this project
Inspect the live deployment or browse the repository code.
Haveaprojectinmind?
freddykojuru@gmail.com