Re: MySQL sync

2009-08-21 Thread Marcus Wolschon
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Derek Atkins schrieb: > Marcus, > > Marcus Wolschon writes: > >> There must be a way without violating 1st normal form and storing >> everything twice. >> Maybe an "updated"-timstamp or something may help. > > Maybe... I was thinking about ways to

Re: MySQL sync

2009-08-18 Thread marcus.wolschon
On Mon, 17 Aug 2009 10:05:52 -0400, Derek Atkins wrote: > Marcus, > > Marcus Wolschon writes: > >> There must be a way without violating 1st normal form and storing >> everything twice. >> Maybe an "updated"-timstamp or something may help. > > Maybe... I was thinking about ways to avoid using

Re: MySQL sync

2009-08-17 Thread Vladimir Bashkirtsev
Derek Atkins wrote: Vladimir Bashkirtsev writes: Derek Atkins wrote: Vladimir Bashkirtsev writes: However, changing the architecture of GnuCash to be a pure DB app would entail rewriting MOST of the engine. I wouldn't recommend going that route in the short term.

Re: MySQL sync

2009-08-17 Thread Derek Atkins
Vladimir Bashkirtsev writes: > Derek Atkins wrote: >> Vladimir Bashkirtsev writes: >> >> However, changing the architecture of GnuCash to be a pure DB app would entail rewriting MOST of the engine. I wouldn't recommend going that route in the short term. >>> Well

Re: MySQL sync

2009-08-17 Thread Derek Atkins
Marcus, Marcus Wolschon writes: > There must be a way without violating 1st normal form and storing > everything twice. > Maybe an "updated"-timstamp or something may help. Maybe... I was thinking about ways to avoid using timestamps per se, because the current time can vary machine-to-machine

Re: MySQL sync

2009-08-17 Thread Vladimir Bashkirtsev
Derek Atkins wrote: Vladimir Bashkirtsev writes: However, changing the architecture of GnuCash to be a pure DB app would entail rewriting MOST of the engine. I wouldn't recommend going that route in the short term. Well... Rewriting most of engine is definitely not something I p

Re: MySQL sync

2009-08-17 Thread Derek Atkins
Vladimir Bashkirtsev writes: >> However, changing the architecture of GnuCash to be a pure DB app would >> entail rewriting MOST of the engine. I wouldn't recommend going that >> route in the short term. >> > Well... Rewriting most of engine is definitely not something I plan. :) > > So I sho

Re: MySQL sync

2009-08-15 Thread Vladimir Bashkirtsev
r which would copy the changes to the audit log. Phil From: Vladimir Bashkirtsev To: Derek Atkins Cc: gnucash-devel@gnucash.org Sent: Friday, August 14, 2009 2:43:24 PM Subject: Re: MySQL sync Derek Atkins wrote: Hi, Please remember to CC gnuc

Re: MySQL sync

2009-08-15 Thread Marcus Wolschon
le would have a trigger which would copy the changes to the audit log. > > Phil > > > > > > From: Vladimir Bashkirtsev > To: Derek Atkins > Cc: gnucash-devel@gnucash.org > Sent: Friday, August 14, 2009 2:43:24 PM > Subject: Re

Re: MySQL sync

2009-08-14 Thread Phil Longstaff
o the accounts table would have a trigger which would copy the changes to the audit log. Phil From: Vladimir Bashkirtsev To: Derek Atkins Cc: gnucash-devel@gnucash.org Sent: Friday, August 14, 2009 2:43:24 PM Subject: Re: MySQL sync Derek Atkins wrote:

Re: MySQL sync

2009-08-14 Thread Vladimir Bashkirtsev
Derek Atkins wrote: Hi, Please remember to CC gnucash-devel on all replies using your mailer's Reply-To-List or Reply-All functionality. Missed that. Now I have pressed correct button. :) Vladimir Bashkirtsev writes: Derek, Perhaps I need to check ascertain amount of work involved. T

Re: MySQL sync

2009-08-14 Thread Derek Atkins
Hi, Please remember to CC gnucash-devel on all replies using your mailer's Reply-To-List or Reply-All functionality. Vladimir Bashkirtsev writes: > Derek, > > Perhaps I need to check ascertain amount of work involved. There's two > approaches we can take: first one is using timestamps and re-re

Re: MySQL sync

2009-08-13 Thread Derek Atkins
Hi, Vladimir Bashkirtsev writes: > Hello, > > I was testing latest development version with MySQL backend and in > general I was satisfied with the results. Great piece of software! > > Now here the scenario I want to happen: I have PHP scripts which deal > with GnuCash data in MySQL DB. It is n

Re: MySQL sync

2009-08-12 Thread Phil Longstaff
There is currently no support for simultaneous access to the db by more than just gnucash. There are no plans to add it unless someone wants to step up and work on it. Phil From: Vladimir Bashkirtsev To: gnucash-devel@gnucash.org Sent: Wednesday, August 12,