Re: [sqlite] LAN and exclusive lock

2009-10-21 Thread Simon Slavin
On 21 Oct 2009, at 5:58pm, Jan wrote: > thx bruce, but I am addicted to open-source. If you want an open source server/client SQL engine, designed from the ground up to work correctly when accessed from many computers at once, I recommend MySQL. It is easier, faster and more efficient to

Re: [sqlite] LAN and exclusive lock

2009-10-21 Thread Bruce Robertson
I'm addicted to amazingly powerful solutions done in minutes; using the one-stop-shopping Lowe's Hardware of data solutions has its own addictive powers. Depends on how you value your time. On Oct 21, 2009, at 9:58 AM, Jan wrote: > thx bruce, but I am addicted to open-source. > > Bruce

Re: [sqlite] LAN and exclusive lock

2009-10-21 Thread Jan
thx bruce, but I am addicted to open-source. Bruce Robertson schrieb: > You might try Filemaker. That's what is was designed for. Make > everything so easy. > > On Oct 21, 2009, at 8:10 AM, Jan wrote: > >> Thank you John. Seems postgres might be a better choice. Although it >> is >> so nice

Re: [sqlite] LAN and exclusive lock

2009-10-21 Thread Jan
Thank you John. Seems postgres might be a better choice. Although it is so nice to work with sqlite cause non of this user/administration "crap" is necessary. John Elrick schrieb: > Jan wrote: >> Hi, >> >> Although I read in a recent post by drh that it is not recommended to >> use sqlite in a

Re: [sqlite] LAN and exclusive lock

2009-10-21 Thread John Elrick
Jan wrote: > Hi, > > Although I read in a recent post by drh that it is not recommended to > use sqlite in a local network I would like to ask if the following > approach would work: > > A database in the local network needs to be accessed by about 20 people. > I suppose the max. number at the

Re: [sqlite] LAN and exclusive lock

2009-10-21 Thread Jan
Pavel Ivanov schrieb: I'm not sure you want to do that. No, actually not. Thanks for clarification. jan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] LAN and exclusive lock

2009-10-21 Thread Pavel Ivanov
Disregarding network drive issue "PRAGMA locking_mode=EXCLUSIVE" means that once your writer requires PENDING or EXCLUSIVE lock nobody else will be able to read the database anymore until writer closes connection to it. In other words without this pragma with relatively small transactions in

[sqlite] LAN and exclusive lock

2009-10-21 Thread Jan
Hi, Although I read in a recent post by drh that it is not recommended to use sqlite in a local network I would like to ask if the following approach would work: A database in the local network needs to be accessed by about 20 people. I suppose the max. number at the same time will be 4-5.