I have been making some improvements to the hbdstats.com page, mainly on the backend side.
Up until recently the web page was a client only, meaning there was no backend server or database for it.
The line charts for the debt and the hbd in savings were with hardcoded values and manually updated from time to time.
From a week ago this is not the case and now there is a MySQL database on the server with a express node app to get the data, create API endpoints and serve it to the web page.
API endpoints:
https://www.hbdstats.com/debt-data
https://www.hbdstats.com/savings-chart-data
The daily values for the debt are calculated and stored daily from the web page. The data for the hbd in savings is extracted from the hivesql database and then stored on the local database daily.
Both of the line charts now have a longterm data in them.
Some screenshots.
Debt table:
Savings table:
I have also fixed some bugs and UI improvements.
There was a bug for the gauge for the hbd in savings. Occasionally it was not loading due to not properly ordered execution steps. Calculate the share first then generate the chart. It was happening that the value was not calculated and the page was trying to generate the chart. Some small UI improvements with the viewports etc.
This is a totally passionate project for me. I have built it and maintain it for free for Hivers to use it. But most of all it has been a learning experience. As most Hivers probably know I have mainly been in the data analysis side of things, this is a step further to try and build web dashboards with a full tech stack implemented.
From here on, I can easily add more features. Also, at some point I will probably upload all the code on Github/Gitlab as open source.
It’s a simple small project but works. I have intentionally tried to make it with minimalistic design, not sure how other users receive it and like it.
Please provide some feedback in the comments.