From: | "Brandon Metcalf" <bmetcalf(at)nortel(dot)com> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: syncing with a MySQL DB |
Date: | 2008-10-21 14:00:25 |
Message-ID: | Pine.LNX.4.58L.0810210859370.4497@cash.us.nortel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
m == mmoncure(at)gmail(dot)com writes:
m> On Tue, Oct 21, 2008 at 9:54 AM, Brandon Metcalf <bmetcalf(at)nortel(dot)com> wrote:
m> > m == mmoncure(at)gmail(dot)com writes:
m> >
m> > m> On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <bmetcalf(at)nortel(dot)com> wrote:
m> > m> > I have a need to keep a PostgreSQL and MySQL table synchronized. My
m> > m> > thoughts are to use triggers on the pgsql side to manipulate the MySQL
m> > m> > table when data in the pgsql table is changed. I also plan on using
m> > m> > PL/Perl to write the functions.
m> > m> >
m> > m> > Are there better ways to achieve this?
m> >
m> > m> have you looked at dbi-link?
m> >
m> >
m> > No, but just did and it looks very cool. Have you used it before? If
m> > so, would you mind if I ask you some questions? We could take it off
m> > the list if that's more appropriate.
m> i'm not a perl guy...hop on postgresql irc and ping 'davidfetter' :-)
OK. I'll dig in and can probably figure everything out. I'll contact
David if I can't.
Thanks.
--
Brandon
From | Date | Subject | |
---|---|---|---|
Next Message | Ivan Sergio Borgonovo | 2008-10-21 14:03:05 | Re: exposing more parse was: Re: tsearch2: setting weights on tsquery |
Previous Message | Merlin Moncure | 2008-10-21 13:58:24 | Re: syncing with a MySQL DB |