Nice work!
> The end goal is to have an application running on terminal or raspberry 24/7 plugged into my home network, without access to internet.
As far as I understand you're using it as the primary interface for all your data, but in case you want to import some external data sources too, you might be interested in a project I started [0]. You can take periodic snapshots of you online data, and then use it as a fully offline programmatic API to integrate with other services, and potentially use in your dashboard as well. Perhaps if you glance at the diagram [1] it might become clearer how it fits :)