Custom Function for SQLite on iPhone

Question

I am working on the nth application installing zip files. Everything works fine in PHP while I was working on a document in OpenGeoDB. Now I am trying to execute the implementation on the iPhone-SDK, but SQLite does not have ACOS, SIN, etc. Funcs. Can someone give me an example of how to extend SQLite with custom functions to use them in select?

Any hints appreciated!

Thanx and happy coding! Marcus

Answer 1

This cleans it well:

http://www.thismuchiknow.co.uk/?p=71

Answer 2

sqlite3_create_function(database, "yourAwesome", 4, SQLITE_UTF8, NULL, &yourAwesomeFunc, NULL, NULL);