Non-custodial Parents

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

Come assist Van Buren Shelter (https://ymcacolumbus.org/locations/vanburen) staff in serving dinners and cleaning up on the 3rd Tuesday of each month. Dinner for the women is 5-6 pm and for the families is 6:15-7:15 pm. There is ample free parking available in the shelter's lot. The recommended area to park is in green in the image above. There will be a new entrance for the time being. We are asking all volunteers to enter through the Donation Dock door, the orange mark on the image above. This door is located between the Single Adults and Family Shelter. You will see 2 large garage doors with a large green trash compactor in the center. Please head to the closest garage door to the building wall, with a ramp leading up. There, you will see a door with a sign stating instructions on how to enter the building. Please ring the doorbell, and a staff member will come and escort you into the building. If a staff member takes longer than 5 minutes, please call the front desk at 614-689-2020. This is a new process for us, and we do not want to keep you waiting! We appreciate your patience as we navigate this temporary change. The shelter needs a volunteer count the day before the event so sign-up ends Monday at 4:50 PM. Afterwards some of us go to the Omnipresent Atheists Weekly Meetup in progress to have a bit to eat or drink (http://www.meetup.com/omnipresentatheists/). Volunteers must be 14 or older. Since we will be working around families, the YMCA does not permit volunteering by individuals with convictions for violent or sexual crimes. The YMCA reserves the right to run background checks on volunteers. For questions, comment on this page or contact: Andrew, awhit12@yahoo.com, (614)937-5802 (cell). Please let Andrew know if you volunteer anytime other than our COUNT events so that he can count your hours toward our service record.