trustedSchema

Queries or sets the trusted_schema flag.

When this flag is disabled (false, the default), SQLite performs extra checks on the database schema (sqlite_schema table) before using it. This is a security measure to protect against malicious or corrupt schema definitions that could otherwise exploit the query planner.

When this flag is enabled (true), these extra checks are skipped. This can result in a minor performance improvement, especially when opening a database or preparing many new statements. However, it should only be enabled if the application trusts that the database schema is well-formed and not malicious.

In most cases, it is safest to leave this pragma disabled.

See also