I am running sqlite 3.4.2 and I am trying to get the extension_functions.c
extenstion to work. I have followed the directions:
How To Build a Loadable Extension Shared Library on Linux
0. untar latest sqlite3 source code in a new directory
1. cd to the newly untarred sqlite directory
2. Comment out the line in Makefile.in to enable loadable extensions:
# TCC += -DSQLITE_OMIT_LOAD_EXTENSION=1
3. ./configure LIBS=-ldl && make sqlite3
4. export LD_LIBRARY_PATH="`pwd`:$LD_LIBRARY_PATH"
5. gcc -I`pwd` -fPIC -shared src/extension_functions.c -o libsqlitefunctions.so
6. ./sqlite3
and when I do ".load libsqlitefunctions.so sqlite3RegisterExtraFunctions" I
get "unable to open shared library". I tried putting
libsqlitefunctions.sointo the current directory but to no avail. I
even tried to do ".load
./libsqlitefunctions.so sqlite3RegisterExtraFunctions"
Any help??? Or a quick work around to get STDEV and AVG functions that are
relatively fast.
