Testing Node-Boot apps backed by a SQL database

There's no dedicated useSqlServer-style hook (unlike MongoDB) — pick between two approaches, in increasing order of realism/cost. For the app-side SQL starter setup being tested here, see nodeboot-starter-persistence-sql.

Fast path — sqlite in-memory/file

Cheapest, no Docker required. Override persistence/database config to point at sqlite instead of the app's real driver:

const {useRepository} = useNodeBoot(MyApp, ({useConfig}) => {
    useConfig({
        persistence: {type: "sqlite", database: ":memory:"}, // or a temp file path for cross-connection persistence
    });
});