Pernotto is a vertical SaaS Property Management System built for small Swiss hospitality businesses.
The challenge
Small hotels under 30 rooms lose hours per week stitching together a booking system, an invoicing tool, and a spreadsheet for guest IDs.
Approach
- Multi-tenant isolation via Postgres RLS,
SET LOCAL app.current_tenant_idper request. - Transaction-pooler safe with
postgres-js(prepare: false). - Clerk for Swiss-compliant SSO.
- Drizzle ORM for typed queries plus migrations.
Outcome
A real mini-PMS that quotes Swiss prices, prints Swiss QR invoices, respects Swiss data law, onboards a host in a single guided session.
