NFL Football

**What You'll Build** A fully working Employee Management REST API with: * **CRUD endpoints** (POST, GET, PATCH, DELETE /employees) * **Pagination**, sorting, and filtering on the list endpoint * **Strong runtime validation** via *zod* * A typed, schema-first database layer via *Drizzle ORM* * **Environment-aware configuration** (development / production) * A multi-database PostgreSQL setup orchestrated via *Docker Compose* * A seed script to populate sample data * A **REST Client** app.http file to exercise every endpoint **What You'll Learn** By the end of this workshop you'll be able to: * Scaffold a NestJS application from scratch with `@nestjs/cli`. * Containerize a Node.js API using a multi-stage Dockerfile and *Docker Compose*. * Run PostgreSQL in Docker with auto-created databases via init scripts. * Load environment variables dynamically from `.env.${NODE_ENV}` files. * Wire up *Drizzle ORM* as a global NestJS module with proper lifecycle hooks. * Define a database schema in TypeScript and generate SQL migrations. * Validate request bodies and query params with *zod* using custom decorators (no class-validator). * Implement pagination, sorting, and filtering the right way. * Translate database errors (e.g. unique_violation) into proper HTTP responses (**409 Conflict**). * Write a seed script that works across environments. * Test the API end-to-end using the **VS Code REST Client**. **Prerequisites** Please install before the event: * Node.js : ≥ 22 [Download here](https://nodejs.org) * pnpm: ≥ 9 * `corepack enable && corepack prepare pnpm@latest --activate` * Docker Engine: ≥ 20.10 (With the Compose v2 plugin, `docker compose`, not `docker-compose`) * Git: latest [Download here](https://git-scm.com) * VS Code: latest [Download here](https://code.visualstudio.com) * VS Code extensions: * REST Client, ESLint, Prettier A working internet connection is required to download Docker images and npm packages.

**Important time note:** Please plan on arriving between 5:30 and 6:00 as the elevators lock after 6 and you'll need to message us and we'll need to come get you. The building address is 4450 Bridge Park The entrance is 6620 Mooney St, Suite 400 You will need to scan your ID at the door to get a visitor badge. **Abstract** TBD **YouTube Link** TBD

FREE event [https://www.ccad.edu/chroma](https://www.ccad.edu/chroma) Friday, May 15, 3–7 p.m. CCAD campus, 60 Cleveland Ave, Columbus, OH Join Columbus College of Art & Design for *2025* *Chroma: Best of CCAD*, our annual campuswide exhibition showcasing outstanding student work from across the college’s academic programs. This faculty-juried show features select work from CCAD students of all class years, and is a can’t-miss end-of-year campus celebration recognizing their tremendous achievements. It’ll be a night of fun and entertainment, with interactive games, animation and film screenings, art symposiums, poetry and prose readings, and more (along with some of the best local food trucks). *Chroma* is free and open to all. Many exhibitions including... **Game Art & Design:** **DSB, first floor, Welcome Center lobby and Room 115**