Hi,<div><br></div><div>The patches that are applied to SQLite are as follows:</div><div><br></div><div><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; "><div>
<a href="http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/sqlite-poison.patch;h=38f81a0c52fa2ff59b0e536f2418b4e003f97644;hb=HEAD" target="_blank" style="color: rgb(42, 93, 176); ">http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/sqlite-poison.patch;h=38f81a0c52fa2ff59b0e536f2418b4e003f97644;hb=HEAD</a></div>
<div><a href="http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/preload-cache.patch;h=8dc5778a03a29aa14d3416c83da61db3ccfdfa7c;hb=HEAD" target="_blank" style="color: rgb(42, 93, 176); ">http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/preload-cache.patch;h=8dc5778a03a29aa14d3416c83da61db3ccfdfa7c;hb=HEAD</a></div>
<div><a href="http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/fts2.patch;h=1f02161ee29aba22edad93ad7bba7c244e2dc2a1;hb=HEAD" target="_blank" style="color: rgb(42, 93, 176); ">http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/fts2.patch;h=1f02161ee29aba22edad93ad7bba7c244e2dc2a1;hb=HEAD</a></div>
<div><a href="http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/fts2.patch;h=1f02161ee29aba22edad93ad7bba7c244e2dc2a1;hb=HEAD" target="_blank" style="color: rgb(42, 93, 176); "></a><a href="http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/icu-regexp.patch;h=cb758ce062a3dc6a0112ace3cdd136c18c7f8274;hb=HEAD" target="_blank" style="color: rgb(42, 93, 176); ">http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/icu-regexp.patch;h=cb758ce062a3dc6a0112ace3cdd136c18c7f8274;hb=HEAD</a></div>
<div><a href="http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/icu-regexp.patch;h=cb758ce062a3dc6a0112ace3cdd136c18c7f8274;hb=HEAD" target="_blank" style="color: rgb(42, 93, 176); "></a><a href="http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/misc.patch;h=e2f0c5525053a958bdd59019ab89d028ec201a97;hb=HEAD" target="_blank" style="color: rgb(42, 93, 176); ">http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/misc.patch;h=e2f0c5525053a958bdd59019ab89d028ec201a97;hb=HEAD</a></div>
<div><a href="http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/preload-cache.patch;h=8dc5778a03a29aa14d3416c83da61db3ccfdfa7c;hb=HEAD" target="_blank" style="color: rgb(42, 93, 176); "></a><a href="http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/safe-tolower.patch;h=c42bb065b7302ad1897be7c50dab59a3eb10c54e;hb=HEAD" target="_blank" style="color: rgb(42, 93, 176); ">http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/safe-tolower.patch;h=c42bb065b7302ad1897be7c50dab59a3eb10c54e;hb=HEAD</a></div>
<div><br></div><div>You can see notes on what they changed and from which version these patches are made here: <a href="http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/README.chromium;h=6953e64e7bf0c462c10d0c7b84ff0052638f8e46;hb=HEAD">http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/README.chromium;h=6953e64e7bf0c462c10d0c7b84ff0052638f8e46;hb=HEAD</a></div>
<div><br></div><div>Thanks,</div><div>Liam</div></span><br><div class="gmail_quote">On 2 March 2010 22:44, Sandra Whitman <span dir="ltr">&lt;<a href="mailto:sandra.whitman@oracle.com">sandra.whitman@oracle.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi Liam,<br>
<br>
Can you send us the patches/source code changes made for the Chromium web browser, along with any particular directions for installing them?  I think we need to apply these as a starting point.<br>
<br>
Thanks,<br>
Sandra<br>
<br>
<br>
Hexxeh wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">
Yep, that&#39;s right. There&#39;s an option (just like with Firefox) to use the system version of SQLite which after a little of of fiddling works as you&#39;d expect.<br>
<br>
Liam<br>
<br></div><div><div></div><div class="h5">
On 2 March 2010 20:54, Greg Burd &lt;<a href="mailto:GREG.BURD@oracle.com" target="_blank">GREG.BURD@oracle.com</a> &lt;mailto:<a href="mailto:GREG.BURD@oracle.com" target="_blank">GREG.BURD@oracle.com</a>&gt;&gt; wrote:<br>

<br>
    Sandra,<br>
<br>
    Chromium OS is a Linux variant built by Google (sometimes called<br>
    the &quot;Google OS&quot;) which boots up and then uses the Google browser,<br>
    Chromium (aka Chrome), for everything.  Essentially, this is<br>
    almost identical to what we&#39;ve done with Firefox porting.  Liam is<br>
    replacing the Chromium web browser&#39;s use of SQLite with BDB SQL.<br>
     That then runs on this stripped down version of Linux and runs on<br>
    a 2GB USB.<br>
<br>
    When Liam looked into the way that Chromium web browser used<br>
    SQLite he found that it:<br>
    a) modified it, patching bugs, adding external functions using the<br>
    SQLite extensions API<br>
    b) used FTS2 (not FTS3) for full-text search<br>
    c) linked this statically against the browser<br>
<br>
    For us to help Liam we will need to help him:<br>
    a) determine what patches to apply and how to apply them to BDB<br>
    SQL (if necessary)<br>
    b) integrate the Google custom functions<br>
    c) integrate FTS2 for full-text search<br>
<br>
    I believe he&#39;s already found a way to link Chromium against a<br>
    dynamic sqlite3.so library rather than statically compile/link the<br>
    amalgamated SQLite source as it does today.<br>
<br>
    Did I get that right Liam?<br>
<br>
    -greg<br>
<br>
    &gt; -----Original Message-----<br>
    &gt; From: Sandra Whitman<br>
    &gt; Sent: Tuesday, March 02, 2010 3:04 PM<br>
    &gt; To: Hexxeh<br>
    &gt; Cc: <a href="mailto:bdb-beta-feedback@oss.oracle.com" target="_blank">bdb-beta-feedback@oss.oracle.com</a><br></div></div><div><div></div><div class="h5">
    &lt;mailto:<a href="mailto:bdb-beta-feedback@oss.oracle.com" target="_blank">bdb-beta-feedback@oss.oracle.com</a>&gt;<br>
    &gt; Subject: Re: [BDB 11gR2 Beta] Using FTS2 with the BDB SQLite<br>
    &gt; compatibility library code<br>
    &gt;<br>
    &gt; Hi Liam,<br>
    &gt;<br>
    &gt; I am not familiar with the Chromium OS, but if it is UNIX-like<br>
    then any<br>
    &gt; arguments which can be passed to a standard SQLite configure<br>
    script can<br>
    &gt; also be passed to the Berkeley DB configure script. For example, I<br>
    &gt; typically build:<br>
    &gt;<br>
    &gt; ../dist/configure CPPFLAGS=&quot;-DSQLITE_ENABLE_FTS3&quot; --enable-sql<br>
    &gt; or<br>
    &gt; ../dist/configure CPPFLAGS=&quot;-DSQLITE_ENABLE_FTS3&quot;<br>
    --enable-sql_compat<br>
    &gt;<br>
    &gt; As Dave mentioned, let me know the problem you are having and I can<br>
    &gt; check further.<br>
    &gt;<br>
    &gt; Thanks,<br>
    &gt; Sandra<br>
    &gt;<br>
    &gt; Hexxeh wrote:<br>
    &gt; &gt; Hi all,<br>
    &gt; &gt;<br>
    &gt; &gt; I&#39;m trying to integrate the new BDB SQLite compatible library into<br>
    &gt; &gt; Chromium/ChromiumOS, and I&#39;m encountering a few issues that I hope<br>
    &gt; one<br>
    &gt; &gt; of you may have the answer to.<br>
    &gt; &gt;<br>
    &gt; &gt; One requirement of Chromium is the FTS2 extension, has anyone<br>
    managed<br>
    &gt; &gt; to successfully use this with the library? If so, how did you<br>
    &gt; &gt; accomplish this?<br>
    &gt; &gt;<br>
    &gt; &gt; Thanks,<br>
    &gt; &gt; Liam McLoughlin<br>
    &gt; &gt;<br>
    ---------------------------------------------------------------------<br>
    &gt; ---<br>
    &gt; &gt;<br>
    &gt; &gt; _______________________________________________<br>
    &gt; &gt; BDB-BETA-FEEDBACK mailing list<br>
    &gt; &gt; <a href="mailto:BDB-BETA-FEEDBACK@oss.oracle.com" target="_blank">BDB-BETA-FEEDBACK@oss.oracle.com</a><br></div></div>
    &lt;mailto:<a href="mailto:BDB-BETA-FEEDBACK@oss.oracle.com" target="_blank">BDB-BETA-FEEDBACK@oss.oracle.com</a>&gt;<div class="im"><br>
    &gt; &gt; <a href="http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback" target="_blank">http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback</a><br>
    &gt;<br>
    &gt; _______________________________________________<br>
    &gt; BDB-BETA-FEEDBACK mailing list<br>
    &gt; <a href="mailto:BDB-BETA-FEEDBACK@oss.oracle.com" target="_blank">BDB-BETA-FEEDBACK@oss.oracle.com</a><br></div>
    &lt;mailto:<a href="mailto:BDB-BETA-FEEDBACK@oss.oracle.com" target="_blank">BDB-BETA-FEEDBACK@oss.oracle.com</a>&gt;<div class="im"><br>
    &gt; <a href="http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback" target="_blank">http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback</a><br>
<br>
<br>
------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
BDB-BETA-FEEDBACK mailing list<br>
<a href="mailto:BDB-BETA-FEEDBACK@oss.oracle.com" target="_blank">BDB-BETA-FEEDBACK@oss.oracle.com</a><br>
<a href="http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback" target="_blank">http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback</a><br>
</div></blockquote>
</blockquote></div><br></div>