Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Amazon Kindle > Kindle Developer's Corner

Notices

Reply
 
Thread Tools Search this Thread
Old 01-01-2013, 06:13 AM   #1
Meeky
Junior Member
Meeky began at the beginning.
 
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...
Meeky is offline   Reply With Quote
Old 01-01-2013, 07:49 AM   #2
twobob
( ͡° ͜ʖ ͡°){ʇlnɐɟ ƃǝs}Týr
twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.
 
twobob's Avatar
 
Posts: 6,586
Karma: 6299991
Join Date: Jun 2012
Location: uti gratia usura (Yao ying da ying; Mo ying da yieng)
Device: PW-WIFI|K5-3G+WIFI| K4|K3-3G|DXG|K2| Rooted Nook Touch
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.

Last edited by twobob; 01-01-2013 at 08:07 AM.
twobob is offline   Reply With Quote
Advert
Old 01-01-2013, 11:02 AM   #3
ixtab
(offline)
ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.
 
ixtab's Avatar
 
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.
ixtab is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 07:58 AM.


MobileRead.com is a privately owned, operated and funded community.