SQLite Forum

What does, if many threads and/or processes need to write the database at the same instant, mean?
Login
Create en extension that sets the timeout then register it in the autoexec list.

```
#include "sqlite3ext.h"
SQLITE_EXTENSION_INIT1

static int sqlite_set_autobusy(sqlite3 *db, char** pzErrMsg, void* pApi)
{
   return sqlite3_busy_timeout(db, 60000);
}

#ifdef _WIN32
__declspec(dllexport)
#endif
int sqlite3_autobusy_init(sqlite3 *db, char **pzErrMsg, const sqlite3_api_routines *pApi)
{
    SQLITE_EXTENSION_INIT2(pApi);

    sqlite3_auto_extension((void*)sqlite_set_autobusy);
    sqlite3_busy_timeout(db, 60000);
    return SQLITE_LOADED_PERMANENTLY;
}
```