Search Postgresql Archives

Re: syncing with a MySQL DB

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



m == mmoncure@xxxxxxxxx writes:

 m> On Tue, Oct 21, 2008 at 9:54 AM, Brandon Metcalf <bmetcalf@xxxxxxxxxx> wrote:
 m> > m == mmoncure@xxxxxxxxx writes:
 m> >
 m> >  m> On Tue, Oct 21, 2008 at 9:07 AM, Brandon Metcalf <bmetcalf@xxxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux