jauntyq Guides › Guides

Guides

Task-focused walkthroughs for specific JauntyQ features. Each guide assumes you have the generator wired into a project (see the repository README.md Quickstart and the first-hour tutorial).

  • DDL as schema source, build the schema from CREATE TABLE files instead of pulling a live snapshot.
  • Sequences, typed accessors for database sequence objects (SQL Server and PostgreSQL).
  • Bulk insert, insert many rows fast via the provider's native bulk-copy path.
  • Tenant scoping, declare tenant-owned tables in jaunty.scope.json: queries that skip the tenant filter fail to build, and auto-CRUD takes the tenant value first.
  • Loading parents with their children, the two-query pattern that fixes JNT8008's N+1 warning, and why there is no eager loading.
  • Migrating from Dapper or EF Core, how an existing data layer maps onto JauntyQ's SQL-first, compile-time model.
  • Database contract testing, assert a live database matches the committed snapshot from your own test suite, gating CI on drift.
  • Runtime startup schema verification, fail fast at boot (or warn, or skip, per policy) when the live database has drifted from the compiled snapshot.
  • Central schema-dependency registry, name schema snapshots in jaunty.registry.json, declare which services depend on which tables, and query the blast radius (jauntyq registry ...).
  • Live EXPLAIN plan analysis, opt-in jauntyq explain runs the query corpus through the database's estimate-only EXPLAIN and flags plan-level problems (large-table scans, missing-index sorts) by severity.