Do you mind my asking what tool you're using to analyze the blockchain data? I am using SteemSQL and linking to it through SSMS. I was curious if you were doing the same, or if you were using another method.
If you're also using SSMS, I'd be interested in talking with you about the query you ran.
Thanks!
I gathered the data with SteemJS and imported it into MySQL myself.
Ok, so your logic is in MySQL? or do you use another language?
I know MySQL has some distinct differences from SQL Server, but I've worked with both sets of logic before and it's not so different that you can't match things up.
I'm running a similar analysis using SQL Server Management Studio (SSMS), which uses vanilla SQL, and was interested in the proper logic for calculation of payouts (how much goes to the author vs curator and such).
If you could point me in the right direction, or share that part of your code, I'd greatly appreciate it.
Thanks!
The SQL query depends entirely on how the database is setup. SteemSQL probably doesn't have the proper data to run the query.
SteemSQL has the entire blockchain (full node) ... At least that's my understanding of what is included..
Those services never have all data and/or aren't up-to-date.
Ok, no problem. If you don't want to share your logic, that's all you had to say rather than just try to discredit the source I'm using for my analysis. By the way, the SteemSQL DB is actually updated every few minutes.
Cheers.
There's no point in sharing my queries when it's a completely different database structure. I'm happy to help you with building the right query, but my concern when i looked at SteemSQL was that it had data missing.