In perspective, is there a way to deal with the below?
I got a requirement, to display "page error, retry" popup, when, for some reason,
connectivity to database/historian is loss, thus on page, data are not completely loaded and show Null.
In this age where application is driven by data source that are stored remotely.
I hope there is a way to check that something when wrong, and will raise popup: "something went wrong, please refresh".
Of course, but the how of the answer is a bit vague based on the information you have provided.
Is this specifically for the entire project or is it for a specific view or component?
There are various way that a lack of connectivity to a data source will present itself and depending on how you are accessing that, the way you can detect it can vary.
For instance you could use a Gateway Scheduled or Timer Event in conjunction with system.db.getConnectionInfo() to show a global popup.
It is a way. The way would depend on your exact needs.
This terminology is quite possibly mixed.
The historian is not always a separate database connection. In fact I would say in most circumstances they are the same "connection"*. It doesn't have to be, by any means, but most often is.
*Ignition actually used a connection pool, so they wouldn't have the exact same connection but rather be connected to the same endpoint.