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"><<a href="mailto:sandra.whitman@oracle.com">sandra.whitman@oracle.com</a>></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's right. There's an option (just like with Firefox) to use the system version of SQLite which after a little of of fiddling works as you'd expect.<br>
<br>
Liam<br>
<br></div><div><div></div><div class="h5">
On 2 March 2010 20:54, Greg Burd <<a href="mailto:GREG.BURD@oracle.com" target="_blank">GREG.BURD@oracle.com</a> <mailto:<a href="mailto:GREG.BURD@oracle.com" target="_blank">GREG.BURD@oracle.com</a>>> wrote:<br>
<br>
Sandra,<br>
<br>
Chromium OS is a Linux variant built by Google (sometimes called<br>
the "Google OS") which boots up and then uses the Google browser,<br>
Chromium (aka Chrome), for everything. Essentially, this is<br>
almost identical to what we've done with Firefox porting. Liam is<br>
replacing the Chromium web browser'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'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>
> -----Original Message-----<br>
> From: Sandra Whitman<br>
> Sent: Tuesday, March 02, 2010 3:04 PM<br>
> To: Hexxeh<br>
> 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">
<mailto:<a href="mailto:bdb-beta-feedback@oss.oracle.com" target="_blank">bdb-beta-feedback@oss.oracle.com</a>><br>
> Subject: Re: [BDB 11gR2 Beta] Using FTS2 with the BDB SQLite<br>
> compatibility library code<br>
><br>
> Hi Liam,<br>
><br>
> I am not familiar with the Chromium OS, but if it is UNIX-like<br>
then any<br>
> arguments which can be passed to a standard SQLite configure<br>
script can<br>
> also be passed to the Berkeley DB configure script. For example, I<br>
> typically build:<br>
><br>
> ../dist/configure CPPFLAGS="-DSQLITE_ENABLE_FTS3" --enable-sql<br>
> or<br>
> ../dist/configure CPPFLAGS="-DSQLITE_ENABLE_FTS3"<br>
--enable-sql_compat<br>
><br>
> As Dave mentioned, let me know the problem you are having and I can<br>
> check further.<br>
><br>
> Thanks,<br>
> Sandra<br>
><br>
> Hexxeh wrote:<br>
> > Hi all,<br>
> ><br>
> > I'm trying to integrate the new BDB SQLite compatible library into<br>
> > Chromium/ChromiumOS, and I'm encountering a few issues that I hope<br>
> one<br>
> > of you may have the answer to.<br>
> ><br>
> > One requirement of Chromium is the FTS2 extension, has anyone<br>
managed<br>
> > to successfully use this with the library? If so, how did you<br>
> > accomplish this?<br>
> ><br>
> > Thanks,<br>
> > Liam McLoughlin<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></div></div>
<mailto:<a href="mailto:BDB-BETA-FEEDBACK@oss.oracle.com" target="_blank">BDB-BETA-FEEDBACK@oss.oracle.com</a>><div class="im"><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>
><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></div>
<mailto:<a href="mailto:BDB-BETA-FEEDBACK@oss.oracle.com" target="_blank">BDB-BETA-FEEDBACK@oss.oracle.com</a>><div class="im"><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>
<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>