Historical case study

Tech 1 Pro: GraphQL backend

Historical · working prototype · run on local emulators.

Year: 2022 (June to September)
Role: API design, data modelling, serverless backend
Stack: NestJS, GraphQL, Firebase Functions, Prisma, PostgreSQL, Firestore, Jest

What it was

The API behind the Tech 1 Pro back office.

API

A NestJS GraphQL API running on Firebase Functions; authentication background functions; account, customer, job and sales resolvers; transactional email built from templates.

Data model

A relational model in Prisma on PostgreSQL, about 40 models covering accounts, company profiles, customers, job leads, jobs, projects, items, services, estimates and invoices, the whole quote-to-invoice cycle.

Infrastructure

Firestore security rules and indexes, and the Firebase emulator suite for running everything locally.

Status

Historical status

A working prototype run against local emulators. Unit-test scaffolding exists, but there is no record of the tests being executed.