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
, 2009 1:26:28 PM Subject: MySQL sync 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 not a

MySQL sync

2009-08-12 Thread Vladimir Bashkirtsev
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 not a problem to read and show account recor