Multi-user SQL Beta

Linas Vepstas linas@linas.org
Mon, 11 Jun 2001 12:31:13 -0500 (CDT)


Included as part of the gnucash-1.6 release is a working
implementation of the multi-user postgres backend.  Multiple
users can simultaneously access and edit data (even transactions--
conflicts are resolved with version numbers).  If one user makes a
change, other users see the change happen, live (in about 10 seconds,
the polling interval).  An audit trail of added/modified/deleted
data is written to the database, but there is no GUI to view the audit
trail, or to rollback to some point in time.

There are still some blips (main window balances don't auto-update,
prices don't auto-update, there are a few performance problems
(that I know how to fix); no gui dialog for username/passwd;
ungraceful behaviour if the network goes down). 
But it should work fairly well.  However, its had only the most 
rudimentary testing: so this is a call for testers and bug reports.

Two more serious blips: it may not work with postgress 6.5.x;
I don't know. If you have this version of postgres, let me know
if it worked, or what the error messages are.

The other is data file import: you will have to import file data
in single-user mode, and then switch to multi-user.  I'll try to fix
this soon.

Read the README in src/engine/postgres for instructions on setup
and use.

--linas