Postgres as the System of Record for Operations

Published 2025-12-01 by Faraz Rahimi

If Excel is the record, you do not have a record. Postgres with events you can query is the cheapest adult in the room.

Postgres as the System of Record for Operations

Tags: Postgres, SQL, Operations, Architecture, unlisted

I put facts in tables with time. I generate the workbook for people who still need it. The database wins arguments because it has a clock.

Constraints are product: unique receipts, foreign keys to SKUs, checks on qty. A constraint error is a better UI than a silent second row.

Migrations are part of operations

A schema change during a wave is a choice. I migrate in quiet hours and I have a rollback. Internal does not mean casual.

Read replicas later

Start with one database you understand. Fancy topologies after you have a queue and a backup you have actually restored.

Original post: https://farazrahimi.com/posts/postgres-as-the-system-of-record-for-operations

Postgres as the System of Record for Operations

Published 2025-12-01 by Faraz Rahimi

If Excel is the record, you do not have a record. Postgres with events you can query is the cheapest adult in the room.

Postgres as the System of Record for Operations

Tags: Postgres, SQL, Operations, Architecture, unlisted

I put facts in tables with time. I generate the workbook for people who still need it. The database wins arguments because it has a clock.

Constraints are product: unique receipts, foreign keys to SKUs, checks on qty. A constraint error is a better UI than a silent second row.

Migrations are part of operations

A schema change during a wave is a choice. I migrate in quiet hours and I have a rollback. Internal does not mean casual.

Read replicas later

Start with one database you understand. Fancy topologies after you have a queue and a backup you have actually restored.

Original post: https://farazrahimi.com/posts/postgres-as-the-system-of-record-for-operations