[maemo-developers] SQLite3

[From: Kamen Bundev]

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 <Doc at 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 at maemo.org
> https://lists.maemo.org/mailman/listinfo/maemo-developers
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maemo.org/pipermail/maemo-developers/attachments/20090117/3f80b9a3/attachment.htm