14

stage · curriculum

Applications

Five product shapes — text-to-SQL, code, browser agents, financial reasoning, multi-turn assistants. Whichever you ship looks a lot like at least three of these case studies. Lift patterns; don't reinvent.

5 articles
25 min to read
2 demos
4 books
if you only do one thing

Text-to-SQL is the canonical 'LLM + structured world' pattern. Edit the SQL; watch the schema validator catch hallucinated columns the way production does.

Articles in this stage

  1. 01 Browser Agents
  2. 02 Case Studies
  3. 03 Financial Reasoning
  4. 04 Text-to-Code
  5. 05 Text-to-SQL

Stage 14 — Applications

Five application areas where the patterns from Stages 1–13 land in real products. Each is its own ecosystem; each illustrates patterns transferable to your domain.

Prerequisites

  • Stages 08–13 (you can build, ship, and operate AI features)

Articles

  1. Text-to-SQL — natural language to database queries
  2. Text-to-code — code generation, IDE agents, Claude Code patterns
  3. Browser agents — automating the web
  4. Financial reasoning — agents over financial data
  5. Case studies — real-world AI products and their lessons

MVU

You can:

  • Recognize architectural patterns reused across application domains
  • Lift a pattern from one domain (e.g. text-to-SQL retrieval) and apply it to your own
  • Skim a “we built X” blog post and pull out the durable engineering lessons

Exercise

Pick one application area. Build a working v0 in a weekend. Identify three patterns from the article that you used; identify two patterns you’d add for production.

Hands-on companions

This stage maps directly to the /case-studies section — each case study is a real product on top of the /ship stack:

Watch it interactively — applications-flavored demos:

  • Text-to-SQL Playground — editable SQL with schema validator that catches hallucinated columns.
  • Browser Agent — three traces (happy path / modal interrupt / layout shift) showing real failure modes.
  • Tool Use Builder — the schema → call → result protocol every application uses.

See also

Further reading

Books move slower than papers in this field — treat these as foundations, not replacements for the latest research. Real authors, real publishers, real editions. Free badges mark books with author-authorized full text online.

  1. AI Engineering: Building Applications with Foundation Models cover

    AI Engineering: Building Applications with Foundation Models

    Chip Huyen

    O'Reilly, 2024

    The most current production-AI book. The LLM-era successor to Designing ML Systems.

  2. Designing Machine Learning Systems cover

    Designing Machine Learning Systems

    Chip Huyen

    O'Reilly, 2022

    The canonical pre-LLM ML systems book. Chapters 3, 4, 5, 8, 10 are still core.

  3. Building LLM-Powered Applications cover

    Building LLM-Powered Applications

    Valentina Alto

    Packt, 2024

    Application-level patterns with framework comparisons (LangChain, LlamaIndex, Haystack).