V4MD: Multiple opened Projector edit the same local db -> is that safe?

[Marc Schmitt]

:D

Thanks for your info, I really appreciate that. 
So Vserver is needed/recommended for that task.

But, please let me ask three further questions:

First one:
Let's say that I ensure that only one projector is able to write into the db and the others are read only.
Would that be OK? What could happen beside that bad mojo ? ;)

Second:
Would it be ok when all projectors are read-only?

Third:
When I switch to Vserver. Is there much I have to code in another way? Or do I just open the db from another path and the rest is the same..?


Best regards
Marc


-------- Original-Nachricht --------
> Datum: Mon, 09 Jun 2008 18:34:32 +0300
> Von: Ruslan Zasukhin <sunshine at public.kherson.ua>
> An: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
> Betreff: Re: V4MD: Multiple opened Projector edit the same local db -> is that safe?

> On 6/9/08 6:22 PM, "Bart Pietercil" <bart.pietercil at cognosis.be> wrote:
> 
> > Hi Marc,
> > 
> > you should NOT be doing this ( opening a local db by multiple users).
> > BAD Mojo will come to you and your family( for at least 3
> > generations) ;-)
> > 
> > no, serious
> > 
> > If you need acces by multiple users VServer is the way to go.
> > Of course you could make a middleware projector and talk through this
> > projector to the db, and talk over sockets from the 'worker'
> > projectors to the middleware projector.
> > Intensif job and still difficult to implement, so best advice is to go
> > server or to lockout multiple instances from connecting to a local db
> 
> Right, you need Valentina Server as the best choice.
> 
> -- 
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
> 
> [I feel the need: the need for speed]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>Hello List,
>
>I am using V4MD on Windows and quite a noob - so please don't laugh ;)
>I am manipulating a local db from a director projector and everything is fine (sql-way).
>
>I hope my explanation is understandable:
> 
>When somebody opens the same director-projector again (maybe on the same pc or maybe over the >intranet) and also wants to edit the same db simultaneously, can this be a problem?
>
>I tested it a little bit with a few opened exes on the same pc and there was no crash or error message >so far.
>
>But: I realised that when you edit the db, the other running projectors ignore the changes (the result >of queries look like there was no change at all ). I have to close the projectors and start them again to >see the changes that were made. Every projector only 'sees' its own manipulations.
>
>I tried the db.flush() but that didn't change anything.
>
>My question is:
>Is that what I'm trying to do safe (and just need a hint how the other projectors get the changes)  or is >this a complete no-go?
>
>
>
>Thanks and best regards,
>