[GNC-dev] [GNC] mysql backend, second user (lock, for example)

[Craig Arno]

I like John's idea,

Here is potentially another big group of GnuCash customers/users,
Microsoft product users (also supported by ODB)

Microsoft SQL Server (MSDN Trigger documentation)
https://msdn.microsoft.com/en-us/library/sdk3bcyw.aspx?f=255&MSPPError=-2147217396

Craig

On 11/5/2018 2:08 PM, John Ralls wrote:
>
>
>> On Nov 6, 2018, at 6:18 AM, craigarno <craig at arno.com
>> <mailto:craig at arno.com>> wrote:
>>
>> Isn't SQLite for "single" application use?  Or are you thinking
>> GnuCash will
>> be operating "peer-to-peer" (even more interesting thought for tiny
>> organizations)?
>>
>> Maybe conditional code with SQLite being a third database type.
>
> To answer Phil’s original question, no, libdbi doesn’t support triggers. 
>
> I’m not at all fond of libdbi and I’d like to switch to a better
> abstraction library. The last time I looked ODB
> (https://www.codesynthesis.com/products/odb/) appeared to be the most
> capable and I think that it does support triggers.
>
> Regards,
> John Ralls
>