I've been playing with libsqlite3 and pysqlite2. I've tried two approaches:
1) Use existing IPK for libsqlite3
2) Build my own
First, let me describe my endeavours with option 1. I used the IPK from here
. This IPK (and the others I have seen around) don't seem to include pysqlite2, so I decided to cross-compile it myself. When I was done, and moved everything across to the Zaurus, I wasn't able to run the tests from pysqlite2. I got this error:
ImportError: /opt/QtPalmtop/lib/python2.4/site-packages/pysqlite2/_sqlite.so: undefined symbol: sqlite3_enable_shared_cache
I decided to have a peek at the libsqlite3.so and see what symbols are there:
misha@poseidon:~/Desktop/package$ nm opt/QtPalmtop/lib/libsqlite3.so | grep enable_shared_code
The symbol isn't there. It's not part of the .so that was in the IPK that freizugheit attached to this post, either. Can someone explain why this symbol missing? Is it something that's really needed -- I can't seem to run the tests without it.
At this stage, I decided to try option 2. I built libsqlite3 with:
./configure --disable-tcl --disable-readline --host=arm
It wasn't able to pick up my cross-compiler by default, but I was able to modify the output Makefile to point it to the right location. After moving libsqlite3 libs and includes to the proper location, it all built. The one thing I found curious is that it built libsqlite3.a and libsqlite3.la files instead of an .so -- this means it's building as a static library, as opposed to dynamically loaded, right? I'm not 100% clear on what needs to happen here -- could someone clear it up?
I was able to build pysqlite2 against the libsqlite3.a and deploy it all to the Zaurus. The tests work partially, hanging after a little while:
from Python 2.4 (#1, Jan 5 2005, 19:21:20)
[GCC 2.95.1 19990816 (release)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> from pysqlite2 import test
At this stage it hangs indefinitely.
Can someone suggest what the problem may be here? Thanks in advance.
Cheers and regards,
PS. wheaties.box, did you end up getting this to work?