Single source of truth for your business
A price typed into the site, the app and the reports drifts three ways. A single source of truth keeps every fact in one database that all three read.
The same fact typed three times
A new price goes into the site, then the app, then the spreadsheet behind the reports. Miss one and they disagree.
Customers see one number, the team quotes another, and the monthly report shows a third. Someone spends the afternoon working out which is right.
What we built: one database behind everything
We built one database behind the site, the app and the reports for a national services business. Each fact lives in one place, and everything that shows it reads from there.
When a fact changes, the pages and reports that depend on it rebuild on their own. A large edit writes back in one batch and lands everywhere at once.
Every change to how the database is laid out is a small, recorded step, the approach behind evolutionary database design (Martin Fowler, 2016). The business shipped every change with 0 data lost.
How a single source of truth runs day to day
Your team changes a fact once. Everything that shows it follows.
Three edits it carries everywhere
-
A price edited once
The site, the app and the quotes show the new price after one edit.
-
A profile kept in one place
Update a person or a customer once, and every page and list that mentions them follows.
-
Reports that match
Reports read the same records as the site. The figures agree.
Want every fact typed once? Book a 30 minute call and we look at where your facts live today.
What changed for the business
The site, the app and the reports now show the same figures.
The team edits a fact in one place and stops hunting for copies.
Do it yourself or have it built
Start by listing every place a price, a profile or a status gets typed. Pick the one that should hold the truth and make the others read from it.
To have it built, see our single source of truth database system. We quote one price after a 30 minute call about your setup.
Operations
Type every fact once, and let everything else follow.
One 30 minute call on your current setup. We tell you what the build takes and quote one price.
- What you get
- A written plan of what this build takes on your setup.
- How it is priced
- The call is free. We quote one price for the build after it.
- What you bring
- A short list of the tools this job runs through today.
Prefer to write? Send us a message.
Questions about a single source of truth
Do we need a single source of truth if we are small?
Once the same fact lives in more than one tool, yes. The sooner the facts live in one place, the less there is to clean up later.
Can our existing tools keep working?
Most can read from one database. The ones that cannot get updated from it on a schedule.
What happens to the copies we have now?
They get compared and merged into one record before the switch. You decide which version is right where they disagree.
Is one database a single point of failure?
It is the one place to protect, with backups and checks on every change. Three copies fail in three different ways.