<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>My next step is to create a deb package (need to learn how first…).<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Nick.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Kamen Bundev
[mailto:bundyo@gmail.com] <br>
<b>Sent:</b> Saturday, January 17, 2009 11:56 AM<br>
<b>To:</b> Dr. Nicholas Shaw<br>
<b>Cc:</b> maemo-developers<br>
<b>Subject:</b> Re: SQLite3<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>Hi,<br>
<br>
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?<br>
<br>
Regards:<br>
Bundyo<o:p></o:p></p>
<div>
<p class=MsoNormal>On Sat, Jan 17, 2009 at 8:44 PM, Dr. Nicholas Shaw <<a
href="mailto:Doc@docharley.com">Doc@docharley.com</a>> wrote:<o:p></o:p></p>
<p class=MsoNormal>Ok, I have sqlite3.6.8 up-and-running on my 810.
Here's what I did:<br>
<br>
1. Got scratchbox up-and-running.<br>
2. Under my user directory (logged in to scratchbox), created a directory<br>
called tmp. Then got out of scratchbox.<br>
3. Went to <a href="http://sqlite.org" target="_blank">sqlite.org</a> ( <a
href="http://www.sqlite.org/download.html" target="_blank">http://www.sqlite.org/download.html</a>
) and<br>
downloaded the tarball of the complete source tree (sqlite-3 6 8-tar.gz) -<br>
or whatever version is current.<br>
4. Outside of scratchbox, I copied this file to the tmp directory I<br>
created.<br>
5. Back inside scratchbox, I unzipped/untared the file (this creates a
new<br>
sqlite directory).<br>
6. Changed to the directory and compiled, ran make, and make install<br>
according to the README.<br>
7. Located where make install put the files and the permissions then put<br>
those files onto my 810, ran chmod +x on all and chown. Here are the<br>
locations and ownerships:<br>
<br>
/usr/local/bin/sqlite executable user:users<br>
/usr/lib and /usr/local/lib (same files)<br>
<br>
libsqlite3.a root:staff<br>
<a href="http://libsqlite3.la" target="_blank">libsqlite3.la</a>
root:staff<br>
libsqlite3.so -> libsqlite3.so.0.8.6
root:staff<br>
libsqlite3.so.0 -> libsqlite3.so.0.8.6
root:staff<br>
libsqlite3.so.0.8.6
root:staff<br>
<br>
8. Tested it on books.db (listing of my library). :-)<br>
<br>
Nick.<br>
<br>
<br>
_______________________________________________<br>
maemo-developers mailing list<br>
<a href="mailto:maemo-developers@maemo.org">maemo-developers@maemo.org</a><br>
<a href="https://lists.maemo.org/mailman/listinfo/maemo-developers"
target="_blank">https://lists.maemo.org/mailman/listinfo/maemo-developers</a><o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>