Here is my understanding of the problem.


There are multiple databases on different physical machines and it is 
desired to create data visualizations that combine them. 


Cat skin 1.

A central visualization process that can access the remote data sources.


Cat skin 2.

Replicate the databases “asis” to a central location and run the 
visualization off these replicas.


Cat skin 3.

Replicate the data of interest into a central database and run the 
visualization off this central database


Cat skin n.

I am sure there are many more options.


My gut, the first decision is whether to try to access the remote data 
sources from a central location  (cat skin 1) or replicate the required 
data to the central location (cat skin 2 and 3). Then proceed from there.


Then layered on top of (or underneath, since we have skinned the cat?), the 
various technology that can be used.....

On Saturday, 21 February 2026 at 19:00:24 UTC-5 Graham Eddy wrote:

> the question, as i understood it, was to present from single copy of data 
> already existing, rather than to store multiple copies of the same data in 
> multiple databases.
> i use mqtt extensively for data acquisition, creating single truths in 
> databases. then i have a presentation layer over the top of all to create a 
> single (complex) portal (which has more than just weewx data).
> as vince and others point out, there is more than one way to ’skin a cat’ 
> and it depends on your requirements
> *⊣GE⊢*
>
> On 22 Feb 2026, at 5:30 am, Vince Skahan <[email protected]> wrote:
>
> For just a few readings from just a few stations, MQTT is the simplest way:
>
>    
>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion visit 
https://groups.google.com/d/msgid/weewx-user/d99ee199-de1e-445d-8023-ccafc03bfff9n%40googlegroups.com.

Reply via email to