<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
-----BEGIN PGP SIGNED MESSAGE-----<br>
Hash: SHA1<br>
<br>
Derek Atkins wrote:<br>
<br>
<span style="white-space: pre;">>Neil Williams
<a class="moz-txt-link-rfc2396E" href="mailto:linux@codehelp.co.uk"><linux@codehelp.co.uk></a> writes:<br>
><br>
>>I'd also like to extend the libgda role in QOF to provide
more choice of <br>
>>backends - I see no reason why QOF cannot use SQLite and
Postgres +/- MySQL <br>
>>directly in the same generic manner as QSF.<br>
><br>
><br>
>Adding a database backend adds overhead in terms of cache
coherency.<br>
>You need to make sure that multiple QOF applications running
against<br>
>the same SQL database maintain the same cache of QOF objects in
core.<br>
>That way when one application makes a change to the database the
other<br>
>application sees the change. This would be _expected_ in a sql
backend.<br>
>It's not expected in a file backend.<br>
><br>
>Just keep this in mind.<br>
><br>
>If you DO solve this in the QOF arena, well, it would be nice :)<br>
>I _think_ it might mean that we don't need to solve it in
gnucash..<br>
>maybe...<br>
><br>
>-derek</span><br>
<br>
Well the current ( => old ) Pg-backend for gnc has the so called<br>
"single-user-mode". In this mode no changes on the db are propagated<br>
to other instances accessing the database. Of course this is not what<br>
one would ideally expect, but if you know what you are doing.... The<br>
prospect to have a working sql-backend for gnucash sound very<br>
interesting to me, and I guess to some other people as well, even if<br>
it doesn't support multi-user access.<br>
<br>
Regards<br>
<br>
Andreas Fromm<br>
-----BEGIN PGP SIGNATURE-----<br>
Version: GnuPG v1.4.1 (GNU/Linux)<br>
Comment: Using GnuPG with Thunderbird - <a class="moz-txt-link-freetext" href="http://enigmail.mozdev.org">http://enigmail.mozdev.org</a><br>
<br>
iD8DBQFDKmm9UmBtSMq5cGURAi8gAJ9lJViZ6RjUHyLVee26GKpKDxO1CQCfciKN<br>
/LrmOhinE2wBKZl4EkqmuU0=<br>
=UMxT<br>
-----END PGP SIGNATURE-----<br>
<br>
</body>
</html>