How to sort information from different data sources by time?

Question

PHP

The question is.
I am making a feed in which communication with the client will be shown - entries made manually, calls and maybe even sms, emails and so on.
So, let's say manually entered entries are on one server, and calls are on another. moreover, the databases are different (mysql, mssql), data on sms can generally be in json format.
But in the end, you need to show such a kind of timeline with contact points. And now I'm thinking how it would be to combine and sort everything? Push into an array with some key and sort by it? Or are there other clever ways?

Answer 1

Write a daemon that collects data from external services into a local database
When querying data, already work with a local database