sqlite file format, anyone?

[Linas Vepstas]

On Sun, Jun 22, 2003 at 10:21:11PM -0400, Derek Atkins was heard to remark:
> Matthew Vanecek <mevanecek at yahoo.com> writes:
> 
> > > Except it's not very real-time (the client has to emit a query
> > > to notice the event), and it's not very portable (it requires
> > > pg).

There is no requirement for 'real time'.  If you are casually using
gnucash, sooner or later you'll hit the sql db and get the event.
If you want to watch exactly what the other person is typing, then you
should use VNC not gnucash.

> > The SQL back end should be inherently multi-user.  There's a certain
> > amount of checking that can theoretically be safely skipped in a single
> > user environment, 

There's a *lot* of checking that can be skipped.  something like 2/3'rds
or 3/4ths of the current pg code could be scrapped for single-user.

> Ok, this implies we cannot do multi-user on MySQL 

You can't do multi-user with MySQL because of the problems with locking,
and because I'm pretty sure that 'real' multi-user installations will
need the balance checkpointing which needs stored proceedures.  You can
probably work around the events issue by sticking them in a table, and
polling that table.

I think its more important to get a small, fast, simple embedded-MySQL 
backend at this point than it is to tackle, again, the multi-user issues. 

--linas

-- 
pub  1024D/01045933 2001-02-01 Linas Vepstas (Labas!) <linas at linas.org>
PGP Key fingerprint = 8305 2521 6000 0B5E 8984  3F54 64A9 9A82 0104 5933