[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: [RFC] Require SQLite >= 3.6.18

From: Hyrum K Wright <hyrum_at_hyrumwright.org>
Date: Tue, 11 Jan 2011 06:59:16 -0600

On Tue, Jan 11, 2011 at 6:01 AM, Julian Foad <julian.foad_at_wandisco.com> wrote:
> Any objection to requiring SQLite >= 3.6.18 as in the attached patch?

Patch looks good.

> WHY?
>
> In order to use SQLite triggers to automatically update the pristine
> text reference counts (see the thread "Ref-counting for pristine texts":
> <http://svn.haxx.se/dev/archive-2011-01/0104.shtml>), we have to either
>
>  * enable recursive triggers, which requires SQLite >= 3.6.18
>
> or
>
>  * split each of our current "INSERT OR REPLACE" statements into a
> DELETE statement followed by an INSERT statement.
>
> The former solution is simpler, which is enough of an advantage for me.
> I haven't yet found other significant pros or cons.
>
>
> AVAILABILITY
>
> Subversion can easily be compiled with a sepcific version of SQLite, by
> including the SQLite source amalgamation file in the Subversion source
> directory.
>
> Some Linux distros include a recent enough version of SQLite already.
> Here are some Linux distros with the versions of SQLite they ship.  (I
> found these on the distributions' web sites; I couldn't find version
> information for RedHat/Fedora.)
>
> Suse SLED/SLES-10 - 3.2.8
> Suse SLED/SLES-11 - 3.6.4
> Debian lenny (stable) - 3.5.9
> Debian lenny-backports - 3.7.3
> Debian squeeze (testing) - 3.7.3
> Ubuntu dapper - 3.2.8
> Ubuntu hardy - 3.4.2
> Ubuntu karmic - 3.6.16
> Ubuntu lucid - 3.6.22
> Ubuntu maverick - 3.7.2

Most distros won't be shipping an updated Subversion in an existing
release, and would likely pick up the latest SQLite when they pick up
the latest Subversion. The people we're really concerned about are
those building from scratch, and the amalgamation file makes including
a later SQLite dirt-simple for them. If it makes your life easier,
let's go ahead with the bump.

-Hyrum
Received on 2011-01-11 14:00:12 CET

This is an archived mail posted to the Subversion Dev mailing list.