Main Church Website (wohcaloocan.org)
WORD OF HOPE CALOOCAN · SOLO PRODUCTION APP

WOH Attendance & Management System

Sole developer, from real-time camera & handheld QR check-in kiosk to 1–4 week absentee follow-up dashboard.

Sole Developer  ·  Laravel 12, PHP, MySQL, Tailwind CSS, QR API

Open live kiosk ↗
  • Camera & Handheld QR Check-In Kiosk
  • Live Service Attendance Dashboard
  • 1–4 Week Absentee Follow-Up Queue
  • Printable Member QR ID Generator

All Screens

Technical Architecture & System Flow

Interactive Multi-Tier Flow Visualizer

Click any system stage below to inspect the data contracts, protocols, and architectural rationale.

4 Architecture Nodes
source Layer · Detailed Inspection

Church Website & Member DB

Source of Truth

WordPress / CMSMember DBHTTPS

Word of Hope Caloocan maintains its primary member registration on wohcaloocan.org. Instead of duplicate data entry, our attendance system queries this source directly.

Integration ProtocolREST API via HTTPS
AuthenticationBearer Token / HMAC Signature
Data ExchangedMember UUID, Full Name, Ministry, Status
Sync StrategyIncremental Delta Polling & Webhooks
Technical Problem Solving

Key Engineering Decisions & Trade-offs

How architectural trade-offs, database schemas, and edge cases were tackled in production.

Senior Interview Case Studies
API Integration & Security

Secure REST API Decoupling vs Direct Database Sharing

The Challenge

Word of Hope Caloocan already had active member registrations on wohcaloocan.org. Connecting the on-site attendance kiosk directly to the main website database would have created tight architectural coupling, exposed database credentials, and created single-point-of-failure risks.

Architectural Decision

Architected a dedicated, token-authenticated REST API endpoint on the church website. The Laravel attendance system fetches member data via HTTPS JSON requests and maintains its own optimized local replica with incremental delta syncing.

Production Result

Total isolation between the public church website and the attendance application. Zero risk of production database lockups during on-site peak hours.

Security:Decoupled DB
Sync Format:HTTPS JSON

Other Systems