CRM & SaaSshipped
Lulur
Multi-tenant booking platform for spas and aesthetic clinics: a slot is offered only when a qualified therapist and a suitable room are both free, and double booking is prevented by the database itself.
- Timeline
- Completed
- Role
- Full Stack Developer
- Team
- 1 person
- Double booking Blocked by PostgreSQL
- Tenants Own brand each
- Demo 0:50

Overview
Lulur is a portfolio booking platform for wellness businesses such as day spas, massage studios and aesthetic clinics. A time slot is offered only when a therapist with the right skill and a suitable room are both free at the same time, including couples bookings that need two therapists and a suite. Each business is a tenant with its own brand, currency and timezone. Everything is a demo with fictional data: payments run against Midtrans' sandbox or a built-in sandbox gateway, and WhatsApp and email are written to a log, not sent.
The Challenge
- Two resources have to be free together, holds have to expire, and no two bookings may ever overlap, even under concurrent requests.
- Each business also needs its own deposit and cancellation rules without those rules changing bookings that already exist.
The Solution
- Every therapist and room of a booking is a row, and PostgreSQL exclusion constraints make overlapping rows impossible.
- Choosing a slot creates a 10-minute hold that a scheduled job releases, and a successful deposit confirms it.
- Policies are snapshotted onto each booking, payment webhooks are idempotent, and tenants are isolated with a global scope plus row-level security as a second layer.
