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
Lulur

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.

Interested in similar work?

Let's discuss how I can help bring your project ideas to life with the same quality and attention to detail.