TypeORM + PostgreSQL: Patterns for Real Apps

Migrations, soft deletes, optimistic locking, and the entity patterns we use across production codebases.

TypeORM is great until you need to do something non-trivial. This post documents the patterns our team standardized on for production apps - repositories, custom data sources, soft deletes, and migration workflows.

We use these patterns across production engagements for clients in fintech, healthcare, and SaaS - and we're happy to walk you through the trade-offs in a working session if it helps your team.