RELIABILITY
How Comblia prevents double booking
We would rather show what is verified, and what is not yet.
The guarantees
- One operation decides. Checking that the slot is free and saving the booking happen in a single operation in the database. Two people cannot both get through.
- Partial overlaps included. An appointment from 1:15 p.m. to 2:15 p.m. is refused if 1 p.m. to 2 p.m. already exists, for the provider as well as for the room, buffer included.
- A refused move loses nothing. If the new slot is taken, the appointment stays exactly where it was.
- A retry does not create a duplicate. Each request carries a key: if the network drops and the request is sent again, only one appointment exists.
- Everything stays consistent. Appointments, waitlist and log are updated together. If one part fails, nothing is saved halfway.
- Separate businesses. Each business sees only its own data, and each employee has individual access that can be revoked immediately.
- Clock changes. The repeated hour in the fall is offered twice, with its offset, and the skipped hour in the spring is never offered.
What has been tested
- 20 simultaneous bookings of the same slot on a real D1 test database: only one succeeds, and the other 19 are refused.
- Partial overlaps in parallel, the same room for two practitioners, two moves to the same slot: no overlaps.
- Backup, wipe, then restore of a fictional business: identical appointments, with the rules still enforced.
- Roles, immediate revocation of a single access, separation of two businesses, removal of the bootstrap key.
- The 2027 clock changes (fall and spring) on the test site.
All of these checks use fictional data.
What works today
- Comblia subscription. Payment is made through a secure Square link: $69 CAD a month or $690 CAD a year. The links work. After payment, use the same email address as your account: your subscription is activated by the Comblia team once the payment is confirmed.
- Client payments for appointments. Online payment (full payment or deposit, through Square) is connected and works: your clients can pay when they book. Comblia never sees or stores any payment information.
- Email reminders. Email reminders are sent the day before the appointment, only if the client has consented. Sign-up codes are also sent by email.
- Text reminders. Text reminders are sent the day before the appointment, if the business has switched text reminders on and the client has given a phone number and consent.
- Calendar. The read-only feed per provider works: your personal calendar shows the appointments without changing them. The secret link can be revoked at any time.
- Backup and restore. A full export and a restore into an empty business work and are checked by tests.
What is still to be proven
- Tests from several regions and during an outage (in progress).
- Legal review (Law 25, health) by an advisor.