X-Recipient: archive-cygwin@delorie.com X-SWARE-Spam-Status: No, hits=-3.4 required=5.0 tests=BAYES_00,KHOP_THREADED,RCVD_IN_DNSWL_NONE,RCVD_IN_HOSTKARMA_NO,RCVD_IN_HOSTKARMA_YE,TW_SV X-Spam-Check-By: sourceware.org Message-ID: <502D2391.2030000@acm.org> Date: Thu, 16 Aug 2012 09:45:05 -0700 From: David Rothenberger User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20120713 Thunderbird/14.0 MIME-Version: 1.0 To: cygwin@cygwin.com Subject: Re: Promote sqlite 3.7.13-1 from test status? References: <502C0B7D.10909@etr-usa.com> <20120816085016.GB5536@calimero.vinschen.de> <502CCBB1.2070600@etr-usa.com> <20120816105507.GD17546@calimero.vinschen.de> <502CE120.4050900@etr-usa.com> <20120816122654.GG17546@calimero.vinschen.de> <502D1967.7090705@etr-usa.com> <20120816160656.M21257@ds.net> In-Reply-To: <20120816160656.M21257@ds.net> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-IsSubscribed: yes Reply-To: cygwin@cygwin.com Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm List-Id: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner@cygwin.com Mail-Followup-To: cygwin@cygwin.com Delivered-To: mailing list cygwin@cygwin.com On 8/16/2012 9:34 AM, Brian Wilson wrote: > 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. The locking issue isn't only related to the repository, it's related to the workspace itself. The problem people have is when they use TortoiseSVN and Cygwin svn with the same workspace. > If this solution isn't acceptable, Cygwin Subversion should use a > different DB and drop SQLite. As the current Subversion svn packager, I can say I'm not going to do that. Subversion upstream only supports SQLite. From a Subversion perspective, I think turning off the TortoiseSVN icon cache is a reasonable work-around for those that must use both tools. But as Warren pointed out, Subversion may not be the only case when a Cygwin tool and a Windows tool want to access the same database at the same time. I can understand the point that Cygwin SQLite should be behave POSIX-ly, but if the locking is handled solely within SQLite itself, does it really matter? Using the same locking that Windows-native SQLite uses does seem to avoid some interaction issues without causing any issues for Cygwin programs, so that's a net plus, right? -- David Rothenberger ---- daveroth@acm.org genius, n.: Person clever enough to be born in the right place at the right time of the right sex and to follow up this advantage by saying all the right things to all the right people. -- 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