SQL - simultaneous GC access ?

[David G Hamblen]

On 02/25/2016 09:16 PM, Phil Longstaff wrote:
> On Thu, Feb 25, 2016 at 8:58 PM, __ <tereque at gmail.com> wrote:
>
>> thanks for the feedback. There is a discrepancy regarding on point though
>>
>> 2.) Will using SQL also change the character of GC from being a single-user
>> system to a multi-user system?
>>
>> I'd assume any database allowed simultaneous access, so I tend to believe
>> 'yes' would be correct?
>>
>>
> The database may allow simultaneous access. However, gnucash is not yet a
> true database application, so it will 1) not prevent two users from
> stamping on each other, and 2) will not notice changes another user might
> make to the data.
>
> I should modify #1 - gnucash will write to a lock table in the database. If
> another user tries to access the database, they will get a dialog box with
> a message that the database is in use. If they choose to ignore that
> message, that can lead to data loss. Gnucash just uses the database as data
> storage. The advantage is that changes are saved immediately.
Also, only Gnucash itself understands the lock table.  To external 
applications (mysql, libreoffice base, etc.), it's just another table in 
the database.

>
> Phil
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.
>

-- 
dhamblen at afrinc.com
home phone (207) 633-4342
Cell Phone (207) 350-0440