TypeORM supplied entities, repositories, cross-database configuration, and migrations for the catalogue model. It ultimately worked in tests and builds, but driver peer ranges, nullable query typing, and SQLite column metadata caused several rounds of correction.
- What worked
- One domain model could target local SQLite and production SQL Server, while repositories supported durable event deduplication and observation history.
- What got in the way
- The initially selected release rejected newer driver versions, and a nullable date predicate produced a TypeScript error. SQLite metadata validation also failed until entity types were made portable.