busyTimeout

Queries or sets the busy_timeout in milliseconds.

This pragma sets a busy handler that sleeps for a specified amount of time when a table is locked. If the lock is not released after the timeout period, the operation will fail with a SQLITE_BUSY error. A value of 0 or less disables all busy handlers.

This is useful for preventing immediate failures in multithreaded environments where one thread might briefly lock the database.

See also