SQL - simultaneous GC access ?

[Geert Janssens]

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