Error: undefined symbol: sqlite3_sqliteulid_init

[Kingsley-Eghianruwa]

i compiled sqlite_ulid using cargo build -r --target aarch64-linux-android . i get the libsqlite_ulid.so file.i assume this file is a loadable sqlite extension but when i try to load the extension via .load ./libsqlite_ulid , i get the error Error: undefined symbol: sqlite3_sqliteulid_init. please how do i resolve this or how do i build a loadable extension for android

[asg017]

Try renaming the libsqlite_ulid.so file to ulid.so and try again, with .load ./ulid.

Alternatively, try .load ./libsqlite_ulid sqlite3_ulid_init

This is happening because the entrypoint is named sqlite3_ulid_init, and sqlite tries to guess the entrypoint based on the name of the extension file. So it either needs to be called ulid.so (or ulid0.so), or you can instead pass in the entrypoint name manually.

[Kingsley-Eghianruwa]

Thank you. both suggestions worked.