Sample .sqlite (SQLite 3) Test Files & Edge Cases
Deterministic SQLite 3 Database File fixtures engineered for automated unit tests, parser fuzzing, and upload validation pipelines. Pull directly in GitHub Actions with immutable SHA-256 verification.
minimal-users.sqlite
Valid 4096-byte single-page SQLite 3 database with a `users` table and two UTF-8 rows.
curl -fsSL https://fileformat.co/fixtures/v1/sqlite/minimal-users.sqlite -o minimal-users.sqlite \
&& echo "dee45e02f67ee69f23295ad0de07601253ad41c8da4dfb9cb173e5ebb3b71e50 minimal-users.sqlite" | shasum -a 256 -capp-telemetry-schema.sqlite
SQLite 3 database whose sqlite_schema B-tree spans interior (0x05) pages across 42 tables plus a ~6KB CHECK-constraint DDL stored on an overflow-page chain.
curl -fsSL https://fileformat.co/fixtures/v1/sqlite/app-telemetry-schema.sqlite -o app-telemetry-schema.sqlite \
&& echo "0ea395a85610cdf41278eff1b123008b580dfd0d5732e96eb419eab56e8e4bc1 app-telemetry-schema.sqlite" | shasum -a 256 -ctruncated-half-page.sqlite
Valid 100-byte SQLite header whose first B-tree page is truncated mid-page.
curl -fsSL https://fileformat.co/fixtures/v1/sqlite/truncated-half-page.sqlite -o truncated-half-page.sqlite \
&& echo "3f7627faa065ed6cd65c4fcccd2cbb8493f9d7330fadd9a68b4ca6fccb0e041c truncated-half-page.sqlite" | shasum -a 256 -cIn-Browser Edge-Case & Malformed Fixture Mutator
Need negative test fixtures for parser fuzzing or upload gateway validation? Mutate minimal-users.sqlite directly in your browser without hosting unsafe payloads on public URLs.
Tests graceful EOF / footer corruption handling without process panic or OOM.