[ale] [Way OT] GnuCash (Was: Re: GnuCash (Was: Re: [OT] Home PBX?))

[mike at trausch.us]

On 08/01/2012 12:06 PM, Derek Atkins wrote:
> Patches are always welcome!  :)

Of course!

That said, given your description, the only reasonable method I could
see would be to support _only_ PostgreSQL, since that has a
notifications mechanism that could support the invalidation of GC's
internal cache.  As far as I'm aware, no other database system provides
such a mechanism (other than perhaps Oracle).  It would also require
that GC's database driver listen for notifies.

The only other fix I could think of based on what you said would be to
ensure that the application never makes the assumption that data resides
in core, and that would likely make it quite a bit slower.  Or it could
be done such that it uses something like memcached and a cache manager
that sits between the database itself and memcached and knows how to
invalidate memcached's cache (assuming, that is, that such a thing is
indeed possible, though I can't see any reason why it wouldn't be).

What I have been doing is, for now, using GC as our authoritative set of
books, entering data based on events that happen.  Where I would like to
wind up is with a single system (or a single integrated system of
systems) that does the same thing, but with the effect of lightening my
administrative overhead and gaining the capability of delegation.  I
could technically delegate to a bookkeeper, but I haven't the budget for
one at the moment.  CPAs, when I need them, tend to break any budget
that might exist for a regular bookkeeper.  :-)

	--- Mike

-- 
A man who reasons deliberately, manages it better after studying Logic
than he could before, if he is sincere about it and has common sense.
                                   --- Carveth Read, “Logic”

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 729 bytes
Desc: OpenPGP digital signature
Url : http://mail.ale.org/pipermail/ale/attachments/20120801/8ad55cd3/attachment-0001.bin