RE: [mv] MySQL vs PostgreSQL

["Jeff Carnahan" <jcarnahan@networq.com>]

******    message to minivend-users from "Jeff Carnahan" <jcarnahan@networq.com>     ******

Sure, mixing and matching database types has been possible since the
Minivend early days.. =)

Remember, you can specify a unique DSN for each database Minivend uses. So,
your products database could be:

Database  products  products.asc  dbi:mysql:DATABASE_NAME:DATABASE_HOST:3306

While, you could use another database, say 'orderdb', that's postgres based.

Database  orderdb  orderdb.asc
dbi:Pg:dbname=DATABASE_NAME;host=DATABASE_HOST;port=5432

DATABASE_NAME is the name of the database that holds your products or
orderdb table.
DATABASE_HOST is the hostname of the machine that mysql/postgres runs on,
i.e.: localhost or dbhost.domain.com

Of course, there are other ways to specify a DSN, and the DSN syntax varies
from database to database. Consult the DBD module that corresponds to the
type of database you want to access. Also, the Minivend documentation has
several examples of connecting to various types of databases.

http://theoryx5.uwinnipeg.ca/CPAN/data/#D
http://www.minivend.com/minivend/docindex/08.01.SQL_support_via_DBI.html (MV
4.x)

--
Jeff Carnahan - jcarnahan@networq.com


-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of John Foster
Sent: Wednesday, July 12, 2000 3:24 AM
To: minivend-users@minivend.com
Subject: Re: [mv] MySQL vs PostgreSQL

Do I understand this to mean that it is possible to use tables from both
MySQL and PostgreSQL server at the same time. 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!


-
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