Re: [GENERAL] Re: MySQL / PostgreSQL (was: Postgres object orientation)

Alain TESIO wrote:
> > Subsidiary question : why is mySQL excluded from RDBMS
> > comparison on postgress www site ?

I believe it's fairly stated: mySQL is not an RDBMS, so it
is not listed. A similar question: Why is Filemaker excluded?
FoxPro?

They all have a speedy, flat file, structure, glued together
in such a way that relational-like interactions are available.

> Maybe because it's much faster ;)

The speed of not having some relational feature that you
desparately need, but is not availabe, is approximately
zero. :-)

I like it for simple structures, simple db's, but as soon as
you're trying to manage 30-40 tables, mySQL starts to get
in its own way. For running SQL to a flat db? It's much
better than PostgreSQL. 200 Tables? Don't even think about
it, get an RDBMS.

> Sure, MySQL doesn't support transactions, rollbacks, ...

Foreign keys...

> I've compared both engines and MySQL is much faster.

Yup. Different design goals.

> However I'll need transaction to ensure reliability
> for the database updates. I've thought at using PostgreSQL
> for updates, and MySQL for select, the database being
> dumped from PostgreSQL and reloaded into MySQL every
> night. Probably with specific queries and scripts rather
> than a dump to get a MySQL-compliant dump file.
> Has anyone an experience about a similar solution ?

We are in the midst of nightly dumps of mySQL -> PostgreSQL,
in order to gradually migrate to a more robust solution...
however, it seems like your proposed idea _could_ work, with
some decent scripting. Fast for simple scans, too...
basically, you'd need text dumps, which are then re-wrapped
to mySQL-friendly insert (or whatever) statements.

HTH,
-Bop