How to create a statically linked extension for sqlite?

Question

sqlite3_auto_extension looks like a good way to register a statically linked extension. But I don't understand the callback declaration:

void (*xEntryPoint)(void);

Shouldn't the callback be like sqlite3_extension_init?

int sqlite3_extension_init(
  sqlite3 *db,
  char **pzErrMsg,
  const sqlite3_api_routines *pApi
)

Answer 1

I'm puzzled too why the callback is declared like that. sqllite calls it like:

xInit(db, &zErrmsg, &sqlite3Apis);

So you should have e.g.

int my_extension(sqlite3 *db, char **pzErrMsg, const sqlite3_api_routines *pApi)
{
  //register stuff
  return 0; //ok
}

...
sqlite3_auto_extension((void*)my_extension);