SQL - simultaneous GC access ?

[Sébastien de Menten]

There is the  "revert" function in the file menu that read again the
database into memory (at least, I think it is what he does). If the user is
in read only rights, GnuCash could may be "revert" every X minutes to
update again the in memory data. Even better if there was some
notifications than the data has changed before/after the revert.

On Saturday, February 27, 2016, Geert Janssens <geert.gnucash at kobaltwit.be>
wrote:

> On Saturday 27 February 2016 14:02:11 Plutocrat wrote:
> > Robert Kesterson wrote on Friday, 26 February, 2016 11:13 PM:
> > >> Databases allowing multiple simultaneous users (how that works).
> >
> > Just a random thought ... it would be possible to set different
> > permissions for different users, so that one person had read/write
> > access to gnucash data, while another might only have read access. In
> > that case there would only be one person updating the data, but it
> > would be possible to  have other users looking at it, running reports
> > etc, without affecting the integrity of the data.
> >
> > P.
>
> That would be possible with this caveat: if the user with update rights is
> making changes in the
> gnucash data while the user with read-only rights is looking at the data,
> the read-only user will
> not see any of these changes until he restarts gnucash.
>
> As things are coded now, gnucash will only *read* the entire database in
> memory when
> opening it and never again afterwards until a reload (which means
> re-opening the database or
> restarting gnucash).
>
> It will *write* any change immediately though.
>
> Regards,
>
> Geert
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org <javascript:;>
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>