Your data is isolated by the database itself
Most business software keeps one customer’s records away from another’s by adding a filter to every query. That works right up until a developer forgets one, and then one customer sees another customer’s data. Coastline does not rely on anyone remembering.
- Every table in our database enforces row-level security, so a query can only ever return rows belonging to your workspace. This is enforced by the database engine, underneath our application code.
- The rule is applied even to the database owner account, not just to ordinary connections.
- A safeguard automatically locks down any new table the moment it is created. If an engineer adds a table and forgets to write an access rule, that table returns nothing to everyone rather than everything to anyone. Locked by default, opened deliberately.
- The practical effect: a forgotten filter in our code is a bug that shows you too little of your own data. It cannot show you somebody else’s.