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-boun...@maemo.org [mailto:maemo-users-boun...@maemo.org]
On Behalf Of Demetris
Sent: Thursday, February 25, 2010 10:26 PM
Cc: maemo-users@maemo.org
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@maemo.org
https://lists.maemo.org/mailman/listinfo/maemo-users
_______________________________________________
maemo-users mailing list
maemo-users@maemo.org
https://lists.maemo.org/mailman/listinfo/maemo-users
