Thread: iLiad Database on iLiad?
View Single Post
Old 02-16-2009, 06:47 AM   #6
-Thomas-
Addict
-Thomas- once ate a cherry pie in a record 7 seconds.-Thomas- once ate a cherry pie in a record 7 seconds.-Thomas- once ate a cherry pie in a record 7 seconds.-Thomas- once ate a cherry pie in a record 7 seconds.-Thomas- once ate a cherry pie in a record 7 seconds.-Thomas- once ate a cherry pie in a record 7 seconds.-Thomas- once ate a cherry pie in a record 7 seconds.-Thomas- once ate a cherry pie in a record 7 seconds.-Thomas- once ate a cherry pie in a record 7 seconds.-Thomas- once ate a cherry pie in a record 7 seconds.-Thomas- once ate a cherry pie in a record 7 seconds.
 
-Thomas-'s Avatar
 
Posts: 325
Karma: 1725
Join Date: Dec 2007
Location: Münster, Germany
Device: iRex iLiad v2
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:
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.
Attached Files
File Type: ipk sqlite3-3.5.9+iliad.r01.ipk (212.5 KB, 430 views)

Last edited by -Thomas-; 02-16-2009 at 07:14 AM.
-Thomas- is offline   Reply With Quote