iLiad Database on iLiad?

[tikitu]

Has anyone ported any database software (SQLite, MySQL, whatever) to the iLiad? Either my google-fu is weak, or there's no package or installer on mobileread (I think it was Adam B mentioned he'd compiled sqlite? but as part of some other project).

If not, is it just that the super-porters have had other priorities, or is there likely to be a good reason not to try?

I tried just dropping the sqlite linux executable onto my iliad, which unsurprisingly didn't do the trick.

root@ereader:~# ./sqlite3-3.6.10.bin 
./sqlite3-3.6.10.bin: 1: Syntax error: word unexpected (expecting ")")

My next attempt will be to try to set up a cross-compiling environment (following instructions on hansel's site) and compile it myself. If anyone can help shortcut that process I'd surely be thankful.

[tikitu]

Well, I seem to have answered my own question. I've got the sqlite executable running, so I guess the library should be fine too. (I'm working towards a lua app with a database backend.)

Apparently SQLite is a pain to cross-compile because the Makefile you get out of the box tries to execute some of the files it creates halfway through the process, which of course doesn't work. I used a variation on this solution, with the Irex SDK tools installed as hansel described. I'll admit I don't entirely understand what I did, but it seems to have worked.

[hansel]

Originally Posted by tikitu

Apparently SQLite is a pain to cross-compile... [snip] ... but it seems to have worked.

Sometimes building a library is like solving a sudoku , but much more rewarding: you don't have to throw it away when you're done I've sent you some karma for solving this one

This might be a next step: http://www.mroth.net/lua-sqlite3/

[tikitu]

Originally Posted by hansel

I've sent you some karma for solving this one

Cheers -- right back atcha, since it's your instructions I was following.

This might be a next step: http://www.mroth.net/lua-sqlite3/

Yep, that's where I'm looking. I might see how easy it is to make an ipkg (or whatever those are called), since installing your lua port that way was so painless. This porting business could get addicting... I wonder if I'll ever get around to the programming part?

[ericshliao]

I once built sqlite for iLiad because WebKit needed it. IIRC, The process was not so problematic.

[-Thomas-]

I've compiled sqlite3 and built a package. It's only ~400k in size, so it will install directly to /. It includes the library as well as the binary (sqlite3). Some test code:

root@ereader:/var/tmp$ sqlite3  test.db
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> CREATE TABLE test (
   ...> ID Int Primary Key,
   ...> Name Varchar );
sqlite> .schema
CREATE TABLE test (
ID Int Primary Key,
Name Varchar );
sqlite> INSERT INTO test VALUES(1, "abc");
sqlite> SELECT * FROM test;
1|abc
sqlite> .exit
root@ereader:/var/tmp$

EDIT: The Ruby library for SQLite3 is out now too (that's what I needed sqlite3 for ). See this post.

[tikitu]

Thanks Thomas. Now I don't have any excuse for learning how to make ipk files... until the next one pops up.