Re:PostgreSQL Accessing MySQL as a Data Source Using mysqsl_fdw
by jobinau on Friday August 24, 2018 @12:31PM
(#17835967)
Suppose we want to run a complex reporting query on tables in Sales database (running MySQL) and Finance database (running PostgreSQL). What is the good option without duplicating data from one system to another?
[ Parent
| on HN ]
Re:PostgreSQL Accessing MySQL as a Data Source Using mysqsl_fdw
by logophobia on Friday August 24, 2018 @01:12PM
(#17836235)
ETL, that way you can also ensure your data gets put in a format that'd make it easy to report on.
Granted, it's not quite as quick as this, and not suited for "one-off" reporting, but it's a lot more flexible. Put things in a nice star schema and you have a good way to do analytics on your data.
Re:PostgreSQL Accessing MySQL as a Data Source Using mysqsl_fdw
by gav on Friday August 24, 2018 @12:53PM
(#17836107)
Duplicating data isn't a bad thing.
Having a process that copies data into a reporting system solves the problem that otherwise it would be brittle (changes to either system might break things) and performance (any reporting queries affect realtime ones). Also, as it's decoupled, pulling in data from a 3rd system, e.g. CRM is possible.