Hot Air Ballooning

**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.

The Alliance is part of the Greater Central Ohio Chapter of the Barbershop Harmony Society. We are an all-voices chorus dedicated to providing an inclusive environment for all those who love to sing, regardless of their race, gender identity, sexual orientation or musical background. The Alliance is the first and only all-voices barbershop chorus in Central Ohio. **Who:** Anyone with a passion for singing at a high level. Previous barbershop chorus/quartet experience not required. **When:** The Alliance rehearses weekly on Thursdays from 7pm-10pm. **Where:** Lord Of Life Lutheran Church: 2480 W Dublin Granville Rd, Columbus, OH 43235 To become a full member of The Alliance, we welcome you to start by visiting us for a few rehearsals to experience the group and sing with us! Then, you may begin the 2-part audition process for membership: the assessement, and audition. We strive to make our auditions as stress-free as possible to help you let your best singing self shine.

Who’s up for a fun night out? Get your boots on, grab your cowboy hat, and let’s have some fun! Thinking about checking out PBR Cowboy Bar & Smokehouse for a lively evening to unwind, connect, and enjoy the night together. • Lively atmosphere with country vibes • Delicious food + drinks • Music, dancing, and lots of laughs • Great conversation and new connections