All articles
EngineeringFebruary 13, 20241 min read

One data core, zero fragile integrations

Most SaaS is a collection of services tied together by integrations. We did the opposite: one core, and everything else wired into it.

Spotrak

Spotrak

Product team

Share

Open the hood of most "all-in-one" SaaS and you find the same thing: a billing service, a CRM service, a messaging service, each with its own database, tied together by integrations. It works in a demo. It cracks in production, because every integration is a place where the data can diverge.

When your CRM and your billing each hold their own copy of the customer, which one is true? The honest answer, in most systems, is "depends on the day."

Our choice: one database, not a federation

At Spotrak, the calendar, the CRM, billing, the marketplace, and the AI agents share a single database. Not one database per module synced overnight. One. The customer, the appointment, the invoice are the same row for everyone, all the time.

That choice has a cost: it takes a well-modeled database, strict rules, a serious migration discipline. We're several hundred versioned migrations in, each one reviewed. That's the price of data that never diverges.

What it unlocks

  • An AI agent doesn't have to go fetch data through an API. It's already there, in the same database. It deploys in hours, not months.
  • A change in the business (a new status, a new service type) propagates everywhere at once, because there's only one place to make it.
  • A dashboard crossing appointments, billing, and reminders doesn't aggregate three sources. It reads one database.

Integration is what you do when you didn't have the option to put everything in one place. When you have that option, you take it. It's less spectacular than an architecture diagram with twenty boxes and arrows. It's mostly a lot harder to break.

Spotrak

Spotrak

Product team

The Spotrak team builds the business platforms we ship to our customers and writes about what we learn running them.

Join the Spotrak newsletter.

Twice a month.