Skip to main content

API-First Data Access

One owner per dataset · everyone else on a contract · roadmap item 30

Applications reach directly into databases they do not own. An application that needs an order opens a connection to the orders database and runs SQL against its tables. It works, and it is why nothing about those tables can change.

The replacement is not "add APIs". It is a rule about who may write what, with an API as the consequence: each dataset has exactly one owning service, and every other application goes through that service's contract. The migration is finished for a dataset when the direct grant is revoked — not when the API is published.

Todayapp Aapp Bapp CDBshared databasedirect SQLevery app reaches every tableTargetapp Aapp Bapp Csvcowning serviceDBcontractits own tablesone writer, everyone else on the contract applicationowning servicedatabasedirect access — removedthrough the contract

What this costs today​

Each of these is worked through with a scenario on the next page.

CostThe short version
01The schema is the public APIA column cannot be renamed without finding every reader first, so it is not renamed.
02Authorization is table-shapedA credential grants a table, not an operation, and the audit trail names a connection, not a caller.
03The coupling is invisibleNothing can answer "what breaks if this table breaks".
04Connections scale with instancesEvery replica opens its own pool straight to the database — and item 26 is about to make replica count elastic.
05It blocks the platform underneathItem 06 cannot change replication and item 27 cannot make a site independent while the reader set is unknown.

What is defined here​

PageQuestion
02 · Why not directWhat does direct access actually cost?
03 · OwnershipWhat does owner mean, and who decides?
04 · The contractWhat is a contract, and what counts as a breaking change?
05 · MigrationHow does a dataset move across, and when is it done?

The direction behind this is roadmap item 30 on the Platform Roadmap; the dated work is in the application modernization milestones.