← All articlesHow it works

One database per customer: how Simson Desk separates tenants

Most software-as-a-service products keep every customer’s data in the same tables, separated by a customer identifier on each row. It is efficient, and it works until a single missing filter in one query shows one customer another’s records. Simson Desk separates customers a level lower.

Two ways to build it

Shared tablesA database per customer
SeparationA column on every rowA separate database
What a query bug can exposeAnother customer’s rowsNothing outside that database
Backup and restoreAll customers togetherOne customer at a time
Deleting a customerRow by row, across every tableRemove the database
Cost to operateLowerHigher

How it works in Simson Desk

Each customer has a workspace at its own address and a database dedicated to it. A request arriving at that address is connected to that database and no other. There is no query that can cross from one customer to another, because the other customer’s data is not in the database being queried.

What it means for you

  • Due diligence: “is our data logically separated from other customers’?” has a short answer.
  • Restore: your data can be restored without touching anyone else’s.
  • Exit: when you leave, your database is removed as a unit.
  • Residency: your data sits in India, in a database you can point to.

Around the database

  • Data in transit is encrypted with TLS 1.2 or later.
  • Sensitive fields, backups and session recordings are encrypted with AES-256.
  • Backups are taken nightly and encrypted.
  • A warm standby runs in a second zone.
  • Security assessments of code and network are carried out regularly, with findings tracked to closure.

What it does not do

Isolation between customers says nothing about access inside your own workspace. That is governed by roles and module access, two-factor sign-in and the audit trail — which are yours to configure.

Does each customer really have a separate database?
Yes. It is a dedicated database, not a shared table with a customer column.
Where is the data hosted?
In India, with a warm standby in a second zone.
Can our data be restored on its own?
Yes. Each customer’s database is backed up and restored separately.

See SimDesk Remote Support in action

Attended & unattended, recorded and ticket-native. Free — no per-operator fees.