Development
Deterministic database generation
Release builds generate SQLite from the checked-in UTF-16LE TSV files.
Build and validate
Headers, row structure, numeric values and canonical identifiers are checked against fifatables before raw tables, canonical indexes and the FTS5 player-search index 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.
bun run db:build
bun run db:validateRead-only runtime
Electron opens searchable SQLite files read-only. Search values are parameterized, sort and table choices are constrained in code, and the renderer reaches the main-process query and import services only through the typed, sandboxed preload API.
Desktop imports
The desktop application reuses the same validation and normalized database builder for user-selected text folders and decoded PC t3db sources. Import and validation run outside the renderer and write only to an isolated temporary output before installation.