Deterministic database generation

Build and validate

Headers, row structure, numeric values and canonical identifiers are checked against fifatables before raw tables, canonical indexes and FTS5 are generated. Published range and relationship anomalies remain visible as advisory warnings for modified databases. Integrity, foreign-key, ANALYZE and VACUUM checks finish the build.

yarn db:build
yarn db:validate

Read-only runtime

Electron opens the generated SQLite artifact read-only. Search values are parameterized, and the renderer reaches data only through the typed, sandboxed preload API.

Custom database library

The desktop Databases page imports one FIFA 11–23 edition at a time. Select the folder that directly contains players.txt, teams.txt, nations.txt and the other exported tables, then provide a unique name. QDB Finder checks the headers and automatically selects a uniquely detected FIFA edition. Validate source performs a cancellable read-only scan before import and reports corrupted rows by file, field and line; advisory metadata warnings do not block modified databases.

Every import becomes an isolated SQLite file in the application-data directory. The bundled database stays immutable, compatible databases are searched together by default, cancellation removes temporary output, and deleting an import never changes the original text files.