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 TABLEfiles 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 explainruns the query corpus through the database's estimate-only EXPLAIN and flags plan-level problems (large-table scans, missing-index sorts) by severity.