Re: [mv] MySQL vs PostgreSQL

[Mike Heins <mikeh@minivend.com>]

******    message to minivend-users from Mike Heins <mikeh@minivend.com>     ******

Quoting John Foster (jfoster@augustmail.com):
> ******    message to minivend-users from "John Foster" <jfoster@augustmail.com>     ******
> 
> 
> ----- Original Message -----
> From: "Mike Heins" <mikeh@minivend.com>
> ------------------stuff snipped------------------
> > However, I would say that it doesn't *too* much apply to Minivend. The
> > referential integrity for Minivend is supplied by the application.
> > It has a fair record with that within its limitations.
> >
> > I personally like the idea of using Postgres or Oracle for the
> > orderline/transaction/userdb tables, and MySQL for everything else.
> > This gives you the speed for the frequently accessed things, and
> > the referential integrity for the things which can use them.
> ------------------stuff snipped------------------
> Do I understand this to mean that it is possible to use tables from both
> MySQL and PostgreSQL server at the same time.

Absolutely.

> I was curious about that as I
> was thinking of trying it out. I was interested in doing for security and
> speed reasons. If possible, is it implemented when building the catalogs
> (MV4.04)?? Thanks!

The demo installation doesn't support it, but it is merely a question of
removing some files from each of the mysql/ and pgsql directories, editing
the DSNs, and restarting.

Minivend can use any of its database types mixed at any time.

-- 
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.8220 fax 7501 <heins@akopia.com>

Fast, reliable, cheap.  Pick two and we'll talk.  -- unknown
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list