Test filesDatabases › users.sqlite

Sample SQLite database file

A genuinely valid SQLite 3 database with one table (users) and 10 rows, written byte-by-byte from source so the file is reproducible.

↓ Download users.sqlite
Filenameusers.sqlite
FormatSQLite
Size8.0 KB (8,192 bytes)
MIME typeapplication/vnd.sqlite3
SHA-256876aa8e4bd7df3ec7f2f9b27d5738b618ed4bda5436cd88f34721edeaa203cf6
What this file catchesDatabase import, upload and inspection paths. Opens in sqlite3, DB Browser, Python and any SQLite driver; PRAGMA integrity_check returns ok and ordinary SELECT/WHERE queries work. Also exercises magic-number detection: the file starts with the ASCII string "SQLite format 3".

Download & verify

curl -fsSL -o "users.sqlite" "https://files.hexaqa.com/db/users.sqlite"
curl -fsSL "https://files.hexaqa.com/db/users.sqlite" | sha256sum # expect: 876aa8e4bd7df3ec7f2f9b27d5738b618ed4bda5436cd88f34721edeaa203cf6

More databases test files

truncated.sqlite

← All Databases files