XML size (was: no subject)

Linas Vepstas linas@linas.org
Wed, 3 Apr 2002 10:01:36 -0600


On Wed, Apr 03, 2002 at 04:34:12PM +0200, Thomas Spahni was heard to remark:
> 
> I would like to see the SQL backend opened to allow a users choice for the
> database package. My personal preference is MySQL.

someone needs to write a driver foir mysql and/or odbc
it probably won't be me ...

> I know that there was a discussion about using MySQL a long time ago but
> in the meantime MySQL has got transactions (for certain table types) and
> is extremely stable.

Last I looked, postgres was factors of 2x-4x faster & doesn't have
stability problems ...

A naive port of the postgres backend might run into other troubles with
mysql: the postgres backend uses stored proceedures to compute balance
subtotals & some other miscellany; I don't think mysql supports stored
proceedures (???)  Of course, the mysql backend could handle balances
differently, but that would require actually thinking (as opposed to
a cut-n-paste of postgres->mysql api).

--linas

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