Case study

SJ Visitor

Visitor and student-pickup system for a school

A gate tablet app and admin console for S.J. Public School, Jaipur, that records every visitor, verifies student pickups and issues gate passes.

ExpoReact NativeReactViteTypeScriptSupabasePostgreSQLTailwind CSS
Company projectTrue Value Infosoft
SJ Visitor product preview
Scroll to explore

A considered experience.
Built for real people.

Everyone who enters S.J. Public School is now on record. Security staff check visitors in on a tablet: phone OTP, identity, a live photo and the reason for the visit, whether that is a half-day pickup, a meeting with a teacher or the principal, an admission enquiry or a fee payment. The app issues a gate pass that can be printed or shared. Student pickups are verified by OTP or a parent pickup card, so a child only leaves with an authorised adult. The admin console shows live counters and an activity feed, and manages students, parents, cards, staff and devices, while teachers see only their own class.

Built at True Value Infosoft.

Tablet check-in with OTP, identity, photo and visit reason

Printable and shareable gate passes

Student pickup verified by OTP or parent pickup card

Admin console with live counters, activity feed, reports and CSV export

Separate admin, security and teacher roles

ExpoReact NativeReactViteTypeScriptSupabasePostgreSQLTailwind CSS

The technology behind the experience.

  • Expo tablet app and React admin on one Supabase backend
  • Row-level security on every table and an activity log written by triggers
  • Private storage with signed URLs; photos compressed before upload
  • Scheduled job that deletes old visitor photos automatically
ExpoReact NativeReactVite
SJ Visitor
TypeScriptSupabasePostgreSQLTailwind CSS
Back to all projects

Let?s work together

Interested in working
together?

I?m open to new projects and collaborations.
Let?s build something great.