Case Study · PIXL VISN

A complete backend - database, API, auth, and all - built inside Ubex in one hour.

PIXL VISN needed a full attendance system for their media arts academy. Using Ubex, the entire backend was built in one sitting - 8 database tables, 11 API endpoints, JWT authentication, Excel imports - all wired together visually, in just one hour.

Built with Ubex · delivered in one hour
1 hrBuild time
8Database tables
11API endpoints
90Visual nodes used

Everything PIXL VISN needed - built visually inside Ubex.

The database, the API, the logic - it all lives inside Ubex workflows. Build visually, extend with code when you need to.

Attendance tracking

Instructors mark who showed up. Admins pull records by date, session, or instructor. Data stored in Ubex tables, queried through workflow nodes.

Student management

Add, remove, search students. Import entire class lists from Excel. All data flows through Ubex's built-in database — ready to use out of the box.

Session scheduling

Create sessions, assign instructors, manage schedules. Full CRUD with session-option mappings and student-schedule linking — ready to go.

Auth with OTP

JWT-based authentication with email OTP via SendGrid. Separate admin and instructor roles. Rate-limited token signing — production-ready from day one.

Excel import engine

Upload a spreadsheet, map columns, bulk-import students, schedules, and session mappings. Validation, upserts, and error handling — built into the workflow.

Granular data cleanup

Admins choose exactly what to wipe — attendance, schedules, session mappings, settings — with conditional checks and hard-delete safeguards at every step.

Not a mockup. A real backend - running entirely inside Ubex.

Database tables, API endpoints, auth logic, email delivery, data validation - built and hosted inside Ubex workflows.

Everything lives inside Ubex

The full system was designed and connected visually inside Ubex - 8 database tables, 11 REST endpoints, JWT token signing, SendGrid email integration, conditional logic, data validators, and Excel parsing. Everything runs on Ubex - and it was built in one hour.

Database Tables8 built-in
Studentsenrolled student records
Sessionsclass sessions & schedules
Attendanceper-session check-in records
Settingstracker configuration
Student schedulesstudent-to-session links
Session mappingssession-option relations
OTP codesone-time login codes
Usersstaff accounts & roles
API Endpoints11 live
Fetch attendancefilter by date, session, instructor
Save attendanceupsert check-in records
Get sessionslist all class sessions
Save sessionscreate or update sessions
Get settingsread tracker configuration
Save settingsupdate tracker configuration
Authenticationlogin, OTP verify, JWT issue
Studentsadd or remove students
Excel importbulk data upload & mapping
Data cleanupgranular selective deletion
User managementadmin & instructor CRUD

Two ways to build the same thing.

Here's what this project includes - and how the investment compares between approaches.

Traditional approach
Auth + OTP + JWT + roles€1,500 – €3,000
8 DB tables + schema€800 – €1,500
11 endpoints + CRUD€2,500 – €5,000
Excel import engine€1,000 – €2,000
Server + deployment€500 – €1,000
Testing + revisions€1,000 – €2,000
Estimated total€7,300 – €14,500
vs
Built on Ubex
All 8 featuresIncluded
8 database tablesIncluded
11 API endpointsIncluded
Hosting built inIncluded
No deployment setupIncluded
Built in one hourIncluded
Ubex planSee pricing

Need changes down the road? We've got you.

New features, schema updates, logic tweaks - the Ubex team handles it alongside you. Whether you're a developer looking to move faster or a team without technical resources, just reach out and we'll scope it together - fast, flexible, and always straightforward.

* Estimates based on average European freelance rates (€50–€100/hr). Both approaches are valid - Ubex just offers a different path to the same result.

" We needed a full backend for our academy - attendance, sessions, student management, authentication, Excel imports. With Ubex, everything was up and running in about an hour - database, endpoints, the whole thing. Straightforward and done. "
PIXL VISN | media arts academyCologne, Germany

PIXL VISN's backend runs entirely on Ubex.
Yours can too.

Database. API. Auth. Logic. Visual-first, with room to grow.