Mailing List Archive: Bricolage: users

How do I connect to PostgreSQL from another MySQL database

Index | Next | Previous | View Threaded

acaul at rand

Dec 15, 2008, 8:28 AM

Post #1 of 2 (1157 views)
Permalink

How do I connect to PostgreSQL from another MySQL database

Hi. We have another application that uses a MySQL database. It would
be really handy for that MySQL database to have read-only access to
some of the data in our Bricolage PostgreSQL database.

I am thinking I should generate a view of the PostgreSQL/Bricolage
data that is relevant. Does that seem correct?

Then, should I put the view into the PostgreSQL database and have the
MySQL database access only that?

Should I put the view in the MySQL database so that it has to hit the
PostgreSQL database every time it wants data? (seems risky)

Maybe I should build another PostgreSQL db to hold the view. Then the
MySQL db could grab the view from the second Postgres.

Maybe I should put the view in the PostgreSQL database and have the
application directly query that view rather than passing the view
through the MySQL database.

Any thoughts and suggestions are much appreciated. Thanks.

__________________________________________________________________________

This email message is for the sole use of the intended recipient(s) and
may contain confidential information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all copies
of the original message.

david at kineticode

Dec 15, 2008, 3:17 PM

Post #2 of 2 (1054 views)
Permalink

Re: How do I connect to PostgreSQL from another MySQL database [In reply to]

On Dec 15, 2008, at 5:28 PM, Ashlee Caul wrote:

> Hi. We have another application that uses a MySQL database. It would
> be really handy for that MySQL database to have read-only access to
> some of the data in our Bricolage PostgreSQL database.
>
> I am thinking I should generate a view of the PostgreSQL/Bricolage
> data that is relevant. Does that seem correct?

It depends on what you're trying to do.

> Then, should I put the view into the PostgreSQL database and have
> the MySQL database access only that?

I know that you can use dblink to connect to a MySQL table or view
from PostgreSQL, but the other way around? Can MySQL connect to
PostgreSQL?

> Should I put the view in the MySQL database so that it has to hit
> the PostgreSQL database every time it wants data? (seems risky)
>
> Maybe I should build another PostgreSQL db to hold the view. Then
> the MySQL db could grab the view from the second Postgres.
>
> Maybe I should put the view in the PostgreSQL database and have the
> application directly query that view rather than passing the view
> through the MySQL database.
>
> Any thoughts and suggestions are much appreciated. Thanks.

It really depends on the data involved, and what you're trying to do.
What *are* you trying to do?

Best,

David

--
David Wheeler
President, Kineticode, Inc.
http://www.kineticode.com/
Kineticode. Setting knowledge in motion.[sm]

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads