Appendix B: References
B.1 Normative References
| Reference | Title | URI |
|---|---|---|
| RFC 2119 | Key words for use in RFCs to Indicate Requirement Levels | https://datatracker.ietf.org/doc/html/rfc2119 |
| RFC 8174 | Ambiguity of Uppercase vs Lowercase in RFC 2119 Key Words | https://datatracker.ietf.org/doc/html/rfc8174 |
| BCP 14 | Best Current Practice 14 (RFC 2119 + RFC 8174) | https://www.rfc-editor.org/info/bcp14 |
| RFC Authoring Standards | RFC Authoring Standards (v2) | docs/standards/authoring/ |
| RFC-RFCSTD-0002 | Architecture Kind Standard | docs/standards/rfc-kinds/architecture/RFC-RFCSTD-0002/ |
| RFC-DBOPS-0001 | PostgreSQL 18 Baseline Upgrade for Containerized Stack | docs/product/db-ops/RFC-DBOPS-0001/ |
B.2 Technology References
| Reference | Title | URI |
|---|---|---|
| Kysely Documentation | Kysely — Type-safe TypeScript SQL query builder | https://kysely.dev/docs/intro |
Kysely withSchema | Kysely schema-scoped queries | https://kysely-org.github.io/kysely-apidoc/classes/Kysely.html |
| Prisma Client Documentation | Prisma Client API Reference | https://www.prisma.io/docs/orm/prisma-client |
| Prisma Migrate Documentation | Prisma Migrate Workflows | https://www.prisma.io/docs/orm/prisma-migrate |
| node-postgres (pg) | PostgreSQL client for Node.js | https://node-postgres.com/ |
| pg.Pool Documentation | Connection pooling for node-postgres | https://node-postgres.com/apis/pool |
| Drizzle ORM | Drizzle ORM Documentation | https://orm.drizzle.team/docs/overview |
| TypeORM | TypeORM Documentation | https://typeorm.io/ |
| Atlas | Atlas Schema Management | https://atlasgo.io/ |
B.3 Informative References
| Reference | Title | URI |
|---|---|---|
| PostgreSQL Schema Documentation | PostgreSQL Schemas | https://www.postgresql.org/docs/current/ddl-schemas.html |
| PostgreSQL search_path | Schema Search Path | https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-PATH |
| PgBouncer Documentation | PgBouncer — Lightweight connection pooler for PostgreSQL | https://www.pgbouncer.org/ |
| NestJS Custom Providers | NestJS Custom Providers Documentation | https://docs.nestjs.com/fundamentals/custom-providers |
B.4 Internal References
| Reference | Title | Relationship |
|---|---|---|
shared/schema-manager/src/ | Schema Manager package source | Contains PrismaManager, PrismaService, PrismaModule |
shared/schema-manager/prisma/tenants/ | Tenant SQL Prisma schema (multi-file) | Authoritative schema definition for tenant database tables |
apps/backend/backend-main/src/tenant/ | Backend-main tenant modules | All 20 tenant-scoped modules that consume PrismaService |
apps/backend/backend-main/src/tenant/company/ | Company module with Kysely prototype | Contains the benchmark implementation and Kysely replica utilities |
B.5 Version History
| Version | Date | Author | Changes |
|---|---|---|---|
| 1.0.0 | 2026-03-26 | Prathik Shetty | Initial draft |