Here are the steps I used to compile/install SQLite onto my 810: 1. Got scratchbox up-and-running. 2. Under my user directory (logged in to scratchbox), created a directory called tmp. Then got out of scratchbox. 3. Went to sqlite.org ( http://www.sqlite.org/download.html ) and downloaded the tarball of the complete source tree (sqlite-3 6 8-tar.gz) - or whatever version is current. 4. Outside of scratchbox, I copied this file to the tmp directory I created. 5. Back inside scratchbox, I unzipped/untared the file (this creates a new sqlite directory). 6. Changed to the directory and compiled, ran make, and make install according to the README. 7. Located where make install put the files and the permissions then put those files onto my 810, ran chmod +x on all and chown. Here are the locations and ownerships: /usr/local/bin/sqlite executable user:users /usr/lib and /usr/local/lib (same files) libsqlite3.a root:staff libsqlite3.la root:staff libsqlite3.so -> libsqlite3.so.0.8.6 root:staff libsqlite3.so.0 -> libsqlite3.so.0.8.6 root:staff libsqlite3.so.0.8.6 root:staff 8. Tested it on books.db (listing of my library). :-) 8. cd /usr/bin 9. ln -s /usr/local/bin/sqlite3.dat sqlite3 (creates a link) Now you just call sqlite3 from wherever and you're up-and-running. Regards, Nick. -----Original Message----- From: maemo-users-bounces@xxxxxxxxx [mailto:maemo-users-bounces@xxxxxxxxx] On Behalf Of Demetris Sent: Thursday, February 25, 2010 10:26 PM Cc: maemo-users@xxxxxxxxx Subject: SQLite Hi all, I was able to install and run mySQL on both the N800 and N810 fairly easy. I want to also test out the SQLite - I download the binaries for it from the SQLite site (http://www.sqlite.org/sqlite3-3.6.22.bin.gz), chmod on it to x, and launch but it fails - meaning it is not actiing as a binary for Linux. Any ideas or any links to SQLite software for Diablo? Thanks very much _______________________________________________ maemo-users mailing list maemo-users@xxxxxxxxx https://lists.maemo.org/mailman/listinfo/maemo-users _______________________________________________ maemo-users mailing list maemo-users@xxxxxxxxx https://lists.maemo.org/mailman/listinfo/maemo-users
