CampusCard - School ID Card System
← All projectsAn ID card system for schools and universities that works without a server or an internet connection.
What it does
- Student roster with photos, import from spreadsheets
- Card designer with templates, QR codes and barcodes
- Print queue at true card size, bulk issue and reissue
- Public verification page: scan or type a number to check a card
- Roles, sign-in and a full activity log
- Backup and restore as a single database file
Stack
- React, TypeScript, Vite
- Tailwind CSS and Radix UI
- SQLite compiled to WebAssembly, stored in IndexedDB
- Installable PWA
- Netlify
Overview
CampusCard is an ID card system for schools and universities that works without a server or an internet connection.
The problem
Many schools print IDs in a room with poor internet and no IT staff. They still need a proper roster, consistent card designs, a print queue and a way to check if a card is real.
What I built
- Student roster with photos, import from spreadsheets
- Card designer with templates, QR codes and barcodes
- Print queue at true card size, bulk issue and reissue
- Public verification page: scan or type a number to check a card
- Roles, sign-in and a full activity log
- Backup and restore as a single database file
Architecture
The whole system runs in the browser. A real SQLite database, compiled to WebAssembly, is stored in IndexedDB, and the app installs as a PWA, so it works fully offline. Backups are a single file.
A high-level view. Endpoints, hosts and security details are left out on purpose.
Key decisions
- 01
No server at all
Why: Schools with weak internet and no IT team can still run it, and student data never leaves the device.
Trade-off: Sharing between computers is done by moving the backup file.
- 02
Real SQL in the browser
Why: SQLite compiled to WebAssembly gives proper queries and transactions instead of a pile of browser storage keys.
Trade-off: A larger first download for the database engine.
- 03
Print at true card size
Why: Cards come out right on the first try, without wasting PVC blanks.
Trade-off: Printer settings have to be set once per machine.
Links
The source code is private. I'm happy to walk you through the code and design in a call.