Skip to content
CG monogram logo
Case Study / 01 10 / 2024

Sigorini

Transforming a dental studio's paper-based chaos into a high-performance, serverless booking system.

Role Full Stack Developer & Architect
Deliverables Web App · Automation · Compliance
Stack
Angular CF Workers D1 R2

01 / Context

The Paper-Based Bottleneck

Before Sigorini, the dental studio operated on a purely manual workflow. A physical paper diary was the single source of truth for thousands of appointments.

Each morning, staff had to manually cross-reference the paper diary and send individual WhatsApp reminders to every patient scheduled for the next day. This took hours of precious time that could have been spent on patient care.

The Core Challenge

How do you transition a tech-averse team from the tactile reliability of a paper diary to a digital system without disrupting their established mental models?

02 / Architecture

Serverless Infrastructure

                        
flowchart TB
    A[Angular SPA] -->|fetch / REST| B[CF Workers]
    B -->|SQL| C[D1 SQLite EU]
    E[Cron trigger] -->|schedule| B
    B -->|WhatsApp API| G[WhatsApp]
    B -->|Backup| R[Cloudflare R2]

    classDef accent fill:#1A6B1A,stroke:#1E1B1F,color:#FAFAF8;
    classDef meta fill:#FAFAF8,stroke:#8A8481,color:#1E1B1F,stroke-width:1px;

    class B,C,G,R accent;
    class E meta;

                    

Hydrating architecture diagram...

Fig 1.1: Data flow from Edge to Storage

GDPR Compliance

Medical data is high-stakes. By leveraging Cloudflare D1 specifically in the EU region, we ensured strict data sovereignty.

Backups are automatically stored in Cloudflare R2 with a 10-year retention policy, meeting the rigorous legal requirements for healthcare records.

Angular Performance

The "Calendar View" was the technical crux. To replicate the paper diary, the UI renders ~200 components per view (one for each 15-minute slot).

Optimized via OnPush change detection and fine-grained reactivity to ensure sub-100ms interaction latency even on legacy desktop hardware.

03 / UX Strategy

High Tech for High Touch

The goal wasn't just to digitize the data, but to replicate the tactile comfort of the paper diary. We built a calendar view that staff (aged 20–60) could understand instantly.

Interactions were designed to be low-friction and forgiving. Large touch targets, clear color-coding for different doctors, and a persistent "daily view" that matched their physical ritual.

→ Familiarity

Replicated the 15-minute slot logic from the physical diary.

→ Availability

Automated doctor scheduling to prevent double-booking.

04 / Impact

Zero Cost. Total Control.

€0 Monthly Infra Cost
100% GDPR Compliance
4h+ Weekly Time Saved

Sigorini is currently live and used daily. It has completely eliminated the manual burden of WhatsApp reminders and provided the studio with its first searchable, high-integrity database of patient history.

Back to Projects