Case Study

JodalN

A production-grade public procurement SaaS that collects Korean G2B bid data, summarizes attached documents with LLMs, and supports high-speed search.

Project Overview

JodalN is a full-stack SaaS for Korean public procurement data. It collects G2B bid notices across multiple categories, normalizes large models with 240+ fields, extracts and summarizes PDF/HWP/Excel/Word attachments through an LLM pipeline, and provides search, filtering, batch tracking, performance logs, cache management, and production deployment workflows.

Key Challenges

Modeling G2B bidding data with 240+ fields per category
Designing a monorepo across web, API, database, shared types, bid summarizer, and public data API modules
Building an LLM document pipeline for PDF, HWP, Excel, and Word files
Optimizing search and aggregation with indexes, materialized views, and cache operations

Key Outcomes

Built a production-grade SaaS with 19 Prisma models and extensive database indexing
Implemented G2B API proxying, caching, rate limiting, and retry handling
Added batch job tracking, performance logs, and Redis cache admin flows
Established Playwright E2E, Storybook, strict TypeScript, and deployment hardening

Technologies

Next.js 15NestJS 11TypeScriptPrismaPostgreSQLLLMDockerGCPPlaywrightStorybook