Hi,

I am trying to use loadable extensions in Sqlite and I've run into the
following 2 problems:

1) I've downloaded src for 3.3.17 Sqlite and build it, but the '.load'
option does not seem to appear when I run the shell. I've used the default
build mechanism with one minor change. I set the flag to disable tcl
extensions. It is likely that I am missing some ./configure option, but I
can't figure out what I need to do. Any advise would be greatly appreciated.


2) Since I've failed in (1) I've downloaded binaries for Linux and I was
able to run fts1 example. I've done it two ways: a) by using downloaded
shared library for fts1 and b) I've built fts1 shared library from sources
that I got in 1) myself. I then tried to do an example in loadable
extensions (namely a half function). I've built the shared library using:

gcc -fPIC -c -I/path_to_include_files half.cc

gcc -shared -Wl,-soname,libhalf.so -o libhalf.so half.o

However when I tried to load this shared library using:

sqlite> .load ./libhalf.so

I got the following error message:

unable to open shared library [./libhalf.so]

Again any advise on what may be going wrong would be greatly appreciated.
Thanks in advance.

- Alex

Reply via email to