Sample SQLite database file (users)

Handle it in code

Each snippet below was run against this exact file with Python 3.14.4 and Node 24.15.0 when this page was built, and the output shown is what it printed.

Python

A truncated database usually opens and queries without any error: SQLite reads the missing bytes as zeros, so this file returns ten rows of (0, None, None, None). Run the integrity check before importing anything from an uploaded database.

import sqlite3

con = sqlite3.connect("file:users.sqlite?mode=ro", uri=True)
try:
    result = con.execute("PRAGMA integrity_check").fetchone()[0]
    print("integrity: ok" if result == "ok" else "rejected: " + " / ".join(result.splitlines()[:2]))
except sqlite3.DatabaseError as e:
    print("rejected:", e)
finally:
    con.close()

Run against this file, it prints: integrity: ok