Alternatives
http://code.google.com/p/sqlite4java...oOtherWrappers <-- decent list.
This also popped up... I'm no "java dude" so I don't know if this helps...
http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC
Running sqlite3 (I don't have a PW)
Typing
sqllite3 at the command line (If you are root) should get you going.
(yep natively on the touch. have to imagine the PW is the same)
Lives here --^
C compilation
if you want the lib (libsqlite3.so) to build against,
look here
(ON KINDLE TOUCH)
Quote:
/usr/lib/libsqlite3.so.0.8.6
/usr/lib/libsqlite3.so
/usr/lib/libsqlite3.so.0
|
(you can extract all the libs to be local to your PC)
I personally build (gtk) stuff like this.
(including sqlite3 support)
(gtk stuff mainly elided)
Quote:
CFLAGS="-mfloat-abi=soft -O2 -ffast-math \
\
-march=armv7 -mtune=cortex-a8 -mfpu=vfpv3 -pipe -fomit-frame-pointer" \
\
arm-linux-gnueabi-gcc-4.7 test.c -o test-kindle-5 \
\
`~/GIT/buildroot-2012.03/output/host/usr/bin/pkg-config gtk+-2.0 --cflags` \
\
-L/usr/arm-linux-gnueabi/lib/ \
\
-L~/GIT/buildroot-2012.03/output/host/usr/arm-unknown-linux-gnueabi/sysroot/lib/ \
\
-L./libk5/ \
\
-I/~/GIT/buildroot-2012.03/output/host/usr/arm-buildroot-linux-gnueabi/sysroot/usr/include\
-lsqlite3
|
using buildroot and the actual libraries copied from the device to compile against.
I happily compile -lsqlite3 in this way...
Hope that helps
(linaro 2012.03 Toolchain) EDIT arm-linux-gnueabi-gcc-4.7 is also an option.