IDUG NA 2026

Modern engineering teams move fast, but brittle tests, flaky mocks, and sluggish integration pipelines can slow even the strongest React + Node backends to a crawl. Database testing is often the first casualty—SQL tests get skipped because they require a persistent Db2 instance, complicating CI/CD and slowing development. This session presents a battle‑tested alternative: using SQLite as an ephemeral, SQL‑compatible stand‑in for Db2 to deliver fast, reliable, production‑like backend tests. You’ll learn how to spin up isolated in‑memory databases, seed realistic data, run true end‑to‑end API tests, and automate teardown without touching production infrastructure. We’ll cover schema alignment, SQL‑driven test design, and strategies for keeping tests blazing fast as your backend grows. If you want to test backend logic as it actually runs—not as mocks pretend it runs—this talk will give you the practical patterns and real‑world insights to elevate your testing strategy and ship with confidence.