I would like to use the extension-functions.c from Liam Healy (http://sqlite.org/contrib/download//download/extension-functions.c?get=25) with SQLite. I am working on Windows XP and I have no clue how to compile the file into a library. And after that there is the issue that loading extensions is by default prohibited as a security measure.
From the intro text of the extension-fuctions.c file: ---------- Note: Loading extensions is by default prohibited as a security measure; see "Security Considerations" in http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions. If the sqlite3 program and library are built this way, you cannot use these functions from the program, you must write your own program using the sqlite3 API, and call sqlite3_enable_load_extension as described above. If the program is built so that loading extensions is permitted, the following will work: sqlite> SELECT load_extension('./libsqlitefunctions.so'); sqlite> select cos(radians(45)); 0.707106781186548 ----------- Therefore, I would like to asks; 1) did anybody compile and would like to share the extension-function.c into a library so it can be loaded as an extension 2) how can I get a sqlite program version that does allow loading extensions. Many thanks Paulo _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
