Extension loaded permanently into SQLite

SQLITE_OK_LOAD_PERMANENTLY (256) is returned by an extension's entry point function to signal that the extension should be loaded permanently into the SQLite library rather than just for the current database connection.

1. 1Not an error — returned intentionally by extension entry points that want permanent registration.

sqlite3_load_extension() when the extension entry point returns SQLITE_OK_LOAD_PERMANENTLY.

/* In C extension code:
int sqlite3_myext_init(sqlite3 *db, char **err, const sqlite3_api_routines *api) {
  SQLITE_EXTENSION_INIT2(api);
  // Register functions ...
  return SQLITE_OK_LOAD_PERMANENTLY; // loads into all future connections too
}

Extension registered for all subsequent database connections.

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev