SQLite

Meeky · 01-01-2013, 06:13 AM

I'm thinking of at least partial port of AnkiDroid (a flash card program for memorizing) for personal use and the community as well.
So what level of support is there for sqlite? Is there any sqlite binary for Kindle or do I need to cross-compile it first? Also how one is meant to use in java? Is there a java SQLite library? If there is no library that is already being used by Kindle developers then I know of a Java wrapper for SQLite called sqlite4java, which I might use for the project.
I would be glad to hear any response...

twobob · 01-01-2013, 07:49 AM

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)

Quote:

/usr/bin/sqlite3

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.

ixtab · 01-01-2013, 11:02 AM

The Kindle Touch and PW internally store a lot of data in sqlite databases - so yes, sqlite3 is there on the PW.

01-01-2013, 06:13 AM	#1
Meeky Junior Member Posts: 1 Karma: 10 Join Date: Dec 2012 Device: Kindle PW	SQLite I'm thinking of at least partial port of AnkiDroid (a flash card program for memorizing) for personal use and the community as well. So what level of support is there for sqlite? Is there any sqlite binary for Kindle or do I need to cross-compile it first? Also how one is meant to use in java? Is there a java SQLite library? If there is no library that is already being used by Kindle developers then I know of a Java wrapper for SQLite called sqlite4java, which I might use for the project. I would be glad to hear any response...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Kobo sqlite database	darkadept	Kobo Reader	38	09-08-2013 08:12 PM
Sqlite database clean up	mapline	Kobo Reader	2	08-01-2012 11:12 PM
Koboreader.sqlite gundged	maxwelledison	Kobo Reader	21	01-12-2011 08:24 AM
Kindle SQLite DB	akira.spb	Kindle Developer's Corner	2	10-18-2010 10:20 PM
sqlite samba lock	rootto	Calibre	4	09-27-2009 02:03 PM

01-01-2013, 11:02 AM	#3
ixtab (offline) Posts: 2,907 Karma: 6736092 Join Date: Dec 2011 Device: K3, K4, K5, KPW, KPW2	The Kindle Touch and PW internally store a lot of data in sqlite databases - so yes, sqlite3 is there on the PW.

Advert