I use a statically linked library for Sqlite in an iPhone Xcode project. I am now trying to include a .C extension to Sqlite in this project. However, I am having trouble making the Sqlite in the build SEE the extension.

The statically linked Sqlite library works fine. Also the .C extension works on my desktop, and builds fine as a statically linked library in Xcode. However, the custom functions it defines are missing when called.

For example, I load the extension as so with no errors.

SELECT load_extension('extension_name.so');

But when I try to call a function defined in the extension, I get this message

DB Error: 1 "no such function: custom_function"

Does anyone know much about linking a Sqlite extension into an Xcode project?