If 3.4.1 is part of the Maemo distribution, I’m unaware of it.  I’ve 
downloaded/installed the debs @ 
repository.maemo.org/pool/Diablo/free/s/sqlite3/ and sqlite3 does not run.  Nor 
can you run sqlite3 and have it run.  This does work and so far I haven’t had 
any problems.

 

My next step is to create a deb package (need to learn how first…).

 

Nick.

 

From: Kamen Bundev [mailto:bun...@gmail.com] 
Sent: Saturday, January 17, 2009 11:56 AM
To: Dr. Nicholas Shaw
Cc: maemo-developers
Subject: Re: SQLite3

 

Hi,

You can also get a source package from Debian and create a deb directly from it 
in scratchbox. The real problem is that Sqlite3 3.4.1 is part of the Maemo 
distribution and if you replace is for the user you may break something else (i 
think the db format is slightly different) and break it more if the user 
uninstalls your version. So, why don't you use 3.4.1?

Regards:
Bundyo

On Sat, Jan 17, 2009 at 8:44 PM, Dr. Nicholas Shaw <d...@docharley.com> wrote:

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@maemo.org
https://lists.maemo.org/mailman/listinfo/maemo-developers

 

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

Reply via email to