If someone is able to output every block/info to mysql (in realtime too) and configure on my VPS - probably similar to what BGB has done, i will create all the dashboards possible, and upload to tableau public so people can see all the stats in real time - I can also combine this data with crypto-exchange data (tableau's webconnector works with most exchanges with an api that i have tried).
what information did you need to be dumped?
what's your VPS configuration?
I can build something in .Net Core (works on linux) if this can help the community
just something as simple as an RCP wrapper around huntercore, to get some data and save it on mysql or wherever, of course it would need a reachable huntercore on your VPS or another location
that would be useful, probably for other cryptos as well.
there is some posts etc about doing it with bitcoin, but i've not researched it properly..
to start i'd just install ubuntu 16.04 server on a VM, install current mysql server, huntercore etc..
not sure what you will need - i can give ssh access or tell me what you want installing.. is it just an exe and i use mono to run it?
will it also update the mysql table(s) realtime when i a new block comes in?
-
for data -
probably 1 table with all the variable info for each block (if you can process gamestate as well, that would be a bonus)..
probably fields such as > blockhieght, algo (0 or 1), difficulty, unix time, median time, size, weight(i should google this i guess), and anything else you can think of
If you can do gamestate stuff as well > Total generals and total hunters, and anything else if it is easy for each block.. (can do that later if that's more of a pain)
only need the raw values (no need to calculate unix time, or put the difficulty type etc).
all that can go in one table..
Could also output getchaintips into another table, although it would be more of a live table with no historical data for ach block .. not sure how i would visualize it but could use to see if there is any forking going on.
let me know what you need me to do..
(would of course need to parse all the blocks from block 1 till now too)