Re: [sqlite] Mac file locking

2008-09-23 Thread Dennis Cote
P Kishor wrote: > > Still, you have a point, and maybe DRH will expound and enlighten us > on his reticence to enable locking style equal to one. > It seems he isn't so reticent after all. See checkin [5737] from this morning at http://www.sqlite.org/cvstrac/chngview?cn=5737. Dennis Cote

Re: [sqlite] Mac file locking

2008-09-22 Thread BareFeet
> My sense is that most users don't want network share support, hence it > is not default. For the relatively few that do want, it exists as an > option. I find that statement a bit ambiguous, so allow me to clarify my own interpretation: 1. Few or probably no users want to NOT have network

Re: [sqlite] Mac file locking

2008-09-22 Thread P Kishor
On 9/22/08, BareFeet <[EMAIL PROTECTED]> wrote: > > Right, does sound easy. But what if I am on a Mac (which I am), but > > don't want network shares support (which I don't, well, not because I > > have anything against it, but I just don't need it) in case it comes > > with some side-effects?

Re: [sqlite] Mac file locking

2008-09-22 Thread BareFeet
> Right, does sound easy. But what if I am on a Mac (which I am), but > don't want network shares support (which I don't, well, not because I > have anything against it, but I just don't need it) in case it comes > with some side-effects? Well, when you're using the SQLite that shipped on your

Re: [sqlite] Mac file locking

2008-09-22 Thread P Kishor
On 9/22/08, BareFeet <[EMAIL PROTECTED]> wrote: > > h... I understood DRH's statement as "no, it can't be enabled by > > default in the source because that flag works only for Macs and it > > causes breakage on other platforms." Unless, he started providing > > platform specific code

Re: [sqlite] Mac file locking

2008-09-22 Thread BareFeet
> h... I understood DRH's statement as "no, it can't be enabled by > default in the source because that flag works only for Macs and it > causes breakage on other platforms." Unless, he started providing > platform specific code tarballs I wouldn't expect it to require multiple code versions,

Re: [sqlite] Mac file locking

2008-09-22 Thread P Kishor
On 9/22/08, BareFeet <[EMAIL PROTECTED]> wrote: > >> It only works on a Mac. The build fails on other posix platforms. > > > > Then of course, it should only be enabled on Macs. > > > Yes, I humbly agree. Can it please be enabled by default in the source > so that when compiled on a Mac,

Re: [sqlite] Mac file locking

2008-09-22 Thread BareFeet
>> It only works on a Mac. The build fails on other posix platforms. > > Then of course, it should only be enabled on Macs. Yes, I humbly agree. Can it please be enabled by default in the source so that when compiled on a Mac, it will enable opening of files on a network volume, in the same

Re: [sqlite] Mac file locking

2008-09-22 Thread Dave Dyer
> >It only works on a Mac. The build fails on other posix platforms. Then of course, it should only be enabled on Macs. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Mac file locking

2008-09-22 Thread P Kishor
On 9/22/08, Dave Dyer <[EMAIL PROTECTED]> wrote: > > > > >Probably this: > > > > http://www.sqlite.org/compile.html#enable_locking_style > > > >Compilation option "SQLITE_ENABLE_LOCKING_STYLE". > > > Compiling the mac version with this flad defined seems to have > fixed my problem. Is

Re: [sqlite] Mac file locking

2008-09-22 Thread D. Richard Hipp
On Sep 22, 2008, at 3:02 PM, Dave Dyer wrote: > >> >> Probably this: >> >> http://www.sqlite.org/compile.html#enable_locking_style >> >> Compilation option "SQLITE_ENABLE_LOCKING_STYLE". > > Compiling the mac version with this flad defined seems to have > fixed my problem. Is there any reason

Re: [sqlite] Mac file locking

2008-09-22 Thread Dan
On Sep 22, 2008, at 12:37 PM, Dave Dyer wrote: > >> >> Yes, I've noticed and reported this same problem. It appears that the >> SQLite bundled in Mac OS X has a special flag set to allow opening >> database files on networked volume, and that works great. > > > So what's the name of this special

Re: [sqlite] Mac file locking

2008-09-21 Thread Dave Dyer
> >Yes, I've noticed and reported this same problem. It appears that the >SQLite bundled in Mac OS X has a special flag set to allow opening >database files on networked volume, and that works great. So what's the name of this special flag? ___

Re: [sqlite] Mac file locking

2008-09-21 Thread BareFeet
Hi Dave, > I'm experimenting with using networked files as sqlite databases > (yes, I'm aware this is a questionable practice) It seems quite valid for remote access to make ad hoc small changes to large hosted database files, or to provide shared access to small user databases files via

[sqlite] mac file locking

2008-09-19 Thread Dave Dyer
I'm experimenting with using networked files as sqlite databases (yes, I'm aware this is a questionable practice) If the client is running on a mac, and the database file is not a local disk, "database locked" error is returned immediately. I assume this means that the file lock mechanism