[BDB 11gR2 Beta] Using FTS2 with the BDB SQLite compatibility library code
Sandra Whitman
sandra.whitman at oracle.com
Tue Mar 2 14:53:07 PST 2010
Thanks,
I will take a look.
Sandra
Hexxeh wrote:
> Hi,
>
> The patches that are applied to SQLite are as follows:
>
> http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/sqlite-poison.patch;h=38f81a0c52fa2ff59b0e536f2418b4e003f97644;hb=HEAD
> http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/preload-cache.patch;h=8dc5778a03a29aa14d3416c83da61db3ccfdfa7c;hb=HEAD
> http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/fts2.patch;h=1f02161ee29aba22edad93ad7bba7c244e2dc2a1;hb=HEAD
> http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/icu-regexp.patch;h=cb758ce062a3dc6a0112ace3cdd136c18c7f8274;hb=HEAD
> http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/misc.patch;h=e2f0c5525053a958bdd59019ab89d028ec201a97;hb=HEAD
> http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/safe-tolower.patch;h=c42bb065b7302ad1897be7c50dab59a3eb10c54e;hb=HEAD
>
> You can see notes on what they changed and from which version these
> patches are made
> here: http://src.chromium.org/cgi-bin/gitweb.cgi?p=chromium.git;a=blob;f=third_party/sqlite/README.chromium;h=6953e64e7bf0c462c10d0c7b84ff0052638f8e46;hb=HEAD
>
> Thanks,
> Liam
>
> On 2 March 2010 22:44, Sandra Whitman <sandra.whitman at oracle.com
> <mailto:sandra.whitman at oracle.com>> wrote:
>
> Hi Liam,
>
> 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.
>
> Thanks,
> Sandra
>
>
> Hexxeh wrote:
>
> 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.
>
> Liam
>
> On 2 March 2010 20:54, Greg Burd <GREG.BURD at oracle.com
> <mailto:GREG.BURD at oracle.com> <mailto:GREG.BURD at oracle.com
> <mailto:GREG.BURD at oracle.com>>> wrote:
>
> Sandra,
>
> Chromium OS is a Linux variant built by Google (sometimes
> called
> the "Google OS") which boots up and then uses the Google
> browser,
> Chromium (aka Chrome), for everything. Essentially, this is
> almost identical to what we've done with Firefox porting.
> Liam is
> replacing the Chromium web browser's use of SQLite with BDB
> SQL.
> That then runs on this stripped down version of Linux and
> runs on
> a 2GB USB.
>
> When Liam looked into the way that Chromium web browser used
> SQLite he found that it:
> a) modified it, patching bugs, adding external functions
> using the
> SQLite extensions API
> b) used FTS2 (not FTS3) for full-text search
> c) linked this statically against the browser
>
> For us to help Liam we will need to help him:
> a) determine what patches to apply and how to apply them to BDB
> SQL (if necessary)
> b) integrate the Google custom functions
> c) integrate FTS2 for full-text search
>
> I believe he's already found a way to link Chromium against a
> dynamic sqlite3.so library rather than statically
> compile/link the
> amalgamated SQLite source as it does today.
>
> Did I get that right Liam?
>
> -greg
>
> > -----Original Message-----
> > From: Sandra Whitman
> > Sent: Tuesday, March 02, 2010 3:04 PM
> > To: Hexxeh
> > Cc: bdb-beta-feedback at oss.oracle.com
> <mailto:bdb-beta-feedback at oss.oracle.com>
> <mailto:bdb-beta-feedback at oss.oracle.com
> <mailto:bdb-beta-feedback at oss.oracle.com>>
> > Subject: Re: [BDB 11gR2 Beta] Using FTS2 with the BDB SQLite
> > compatibility library code
> >
> > Hi Liam,
> >
> > I am not familiar with the Chromium OS, but if it is
> UNIX-like
> then any
> > arguments which can be passed to a standard SQLite configure
> script can
> > also be passed to the Berkeley DB configure script. For
> example, I
> > typically build:
> >
> > ../dist/configure CPPFLAGS="-DSQLITE_ENABLE_FTS3"
> --enable-sql
> > or
> > ../dist/configure CPPFLAGS="-DSQLITE_ENABLE_FTS3"
> --enable-sql_compat
> >
> > As Dave mentioned, let me know the problem you are having
> and I can
> > check further.
> >
> > Thanks,
> > Sandra
> >
> > Hexxeh wrote:
> > > Hi all,
> > >
> > > I'm trying to integrate the new BDB SQLite compatible
> library into
> > > Chromium/ChromiumOS, and I'm encountering a few issues
> that I hope
> > one
> > > of you may have the answer to.
> > >
> > > One requirement of Chromium is the FTS2 extension, has
> anyone
> managed
> > > to successfully use this with the library? If so, how
> did you
> > > accomplish this?
> > >
> > > Thanks,
> > > Liam McLoughlin
> > >
>
> ---------------------------------------------------------------------
> > ---
> > >
> > > _______________________________________________
> > > BDB-BETA-FEEDBACK mailing list
> > > BDB-BETA-FEEDBACK at oss.oracle.com
> <mailto:BDB-BETA-FEEDBACK at oss.oracle.com>
> <mailto:BDB-BETA-FEEDBACK at oss.oracle.com
> <mailto:BDB-BETA-FEEDBACK at oss.oracle.com>>
>
> > > http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback
> >
> > _______________________________________________
> > BDB-BETA-FEEDBACK mailing list
> > BDB-BETA-FEEDBACK at oss.oracle.com
> <mailto:BDB-BETA-FEEDBACK at oss.oracle.com>
> <mailto:BDB-BETA-FEEDBACK at oss.oracle.com
> <mailto:BDB-BETA-FEEDBACK at oss.oracle.com>>
>
> > http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> BDB-BETA-FEEDBACK mailing list
> BDB-BETA-FEEDBACK at oss.oracle.com
> <mailto:BDB-BETA-FEEDBACK at oss.oracle.com>
> http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> BDB-BETA-FEEDBACK mailing list
> BDB-BETA-FEEDBACK at oss.oracle.com
> http://oss.oracle.com/mailman/listinfo/bdb-beta-feedback
More information about the BDB-BETA-FEEDBACK
mailing list