How to establish the real-time communication between Shopping cart running MySQL and Internal System Running PostgreSQL [closed]
- by Andrew
I am thinking about the way of establishing some-sort of real-time connection between MySQLpowered shopping cart and internal system that is running on PostgreSQL.
Could you give me some sort of insight on this topic?
For example, I can write some sort of csv export application, then enable remote MySQL for over the internet connection and then import csv to mysql directly from PC. Or upload csv and run cron on server. But this way of import-export causing delays; so I would like to link databased (or some msort). I have never done it before and would like to hear some opinions about this.
Another way "just a thought" might to implement triggers that would initiate the update process via csv; but again, I would like to avoid csv.
Do you have any good advise? Maybe some specific examples?