[maemo-developers] SQLite3

[From: Dr. Nicholas Shaw]

Oops, I forgot two steps...

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.

Nick.


-----Original Message-----
From: maemo-developers-bounces at maemo.org
[mailto:maemo-developers-bounces at maemo.org] On Behalf Of Dr. Nicholas Shaw
Sent: Saturday, January 17, 2009 11:45 AM
To: 'maemo-developers'
Subject: SQLite3

Ok, I have sqlite3.6.8 up-and-running on my 810.  Here's what I did:

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). :-)

Nick.


_______________________________________________
maemo-developers mailing list
maemo-developers at maemo.org
https://lists.maemo.org/mailman/listinfo/maemo-developers