X-Recipient: archive-cygwin AT delorie DOT com
X-SWARE-Spam-Status: No, hits=-2.1 required=5.0	tests=AWL,BAYES_00,KHOP_THREADED,RP_MATCHES_RCVD
X-Spam-Check-By: sourceware.org
From: "Brian Wilson" <wilson AT ds DOT net>
To: cygwin AT cygwin DOT com
Subject: Re: Promote sqlite 3.7.13-1 from test status?
Date: Thu, 16 Aug 2012 12:34:44 -0400
Message-Id: <20120816160656.M21257@ds.net>
In-Reply-To: <502D1967.7090705@etr-usa.com>
References: <announce DOT 5029275C DOT 4040009 AT etr-usa DOT com> <502C0B7D DOT 10909 AT etr-usa DOT com> <loom DOT 20120816T092134-266 AT post DOT gmane DOT org> <20120816085016 DOT GB5536 AT calimero DOT vinschen DOT de> <502CCBB1 DOT 2070600 AT etr-usa DOT com> <20120816105507 DOT GD17546 AT calimero DOT vinschen DOT de> <502CE120 DOT 4050900 AT etr-usa DOT com> <20120816122654 DOT GG17546 AT calimero DOT vinschen DOT de> <502D1967 DOT 7090705 AT etr-usa DOT com>
X-OriginatingIP: 158.111.236.102 (wilson)
MIME-Version: 1.0
Content-Type: text/plain;	charset=iso-8859-1
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Precedence: bulk
List-Id: <cygwin.cygwin.com>
List-Unsubscribe: <mailto:cygwin-unsubscribe-archive-cygwin=delorie DOT com AT cygwin DOT com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com


> >> This recent wish for SQLite on Cygwin to act more Unix-like is the
> >> first such request I've received, and I don't remember it being an
> >> issue with the previous maintainer, either.
> >
> > Maybe the reason is because subversion didn't use SQLite before?
> 
> That's mere happenstance.  There's nothing special about Subversion 
> in this regard.  It could have happened with any other pair of 
> SQLite based programs.  The fact that it hasn't until now means the 
> DITCW principle isn't buying us much in this case.
> 
> Understand Corinna, I see your point, and Achim's.  Remember that I 
> accepted Achim's patch and released 3.7.12.1-1 including it.  Making 
> Cygwin SQLite behave in a POSIXy way feels right.  But, given that 
> the new locking behavior causes actual people actual problems, 
> purity alone isn't looking like such a good reason to keep the new 
behavior.
> 
> If we discard purity as a reason to do this, all we're left with is 
> the actual problem brought up by one person (Achim) in N years.  We 
> can't solve that problem without causing problems for many others.
> 
> > This behaviour breaks concurrency with other Cygwin executables
> > using POSIX calls for file locking.
> 
> I agree, in principle, the 3.7.3/13-1 locking behavior is Wrong (tm).
> 
> >> Advisory locking only works when all players cooperate.  We can't
> >> assume that on Windows, unless we set up an insular Cygwin ghetto.
> >
> > So, are you saying that Cygwin should use mandatory file locking?
> 
> In a situation like this, you have three choices:
> 
> 1. Use mandatory locking in the Cygwin program.  Ugly, but useful 
> work gets done.
> 
> 2. Tell all users of the Cygwin program to stop using the native 
> Windows program or switch to a Cygwin alternative.  This is a bad 
> choice as a rule, since it tells the world Cygwin doesn't play well 
> with others. It's worse in this case due to N years of the Cygwin 
> program playing well with the Windows program.  Additionally, there 
> is no GUI Subversion client in the Cygwin package repo.
> 

Corina is correct, Cygwin is supposed to be a Posix compliant environment so 
the SQLite package should follow the Posix standard as the default 
behavior.  If you want to use Windoze tools, why are you using Cygwin?  If 
you really must, why not set up Apache under Cygwin and access the Cygwin 
Subversion repository through the defined http server interface and the 
issue of file locking becomes moot.

Cygwin is not a Windoze/Posix program compatability matching system; it is a 
Posix environment on the Windoze platform.  There is no intention to have 
Windoze only application work directly to Cygwin applications (nor is there 
an intention to prevent this either).

As a worst case scenario, why can't the direct SVN access locking behavior 
be determined by setting an environment variable.  If users want it to work 
with Windoze programs (i.e. in a non-posix way), have them set an 
environment variable for hard locks; other wise, let the rest of us who want 
a Posix experience use the advisory locks.  If this solution isn't 
acceptable, Cygwin Subversion should use a different DB and drop SQLite.

Sincerely,

Brian S. Wilson
============================================================================

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple