[STEEMSQL.COM] How to create a Steem analytic report with Microsoft Excel

in steemit •  8 years ago  (edited)

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

I'm trying to use Java for the connection to the database it it wont connect. It says database not responding!

Very cool idea for a service! Having lots of different available data sources & formats like this will speed up cool developments and experimentation.

This guide is also really well presented and written, thanks for doing this @arcange!
edited: Saw the other post

Spent a lot of time to make it as SteemSQL for dummies :P
Thanks for your positive feedback !

  ·  8 years ago (edited)

It's really a great post. I didn't know that this stuff was doable from excel, and I'll certainly be experimenting.

Reblogged so more folks can see your awesome-level in action.

He he, sharing and spreading knowledge. Good move.
Thanks!

thanks for the guide. Looking forward to testing out on the HIVESQL

Thanks a lot for the tutorial. I look forward to apply it.

Enjoy :)

wow ,, your writing is very helpful to me, i am very layman with sql server .. thanks. I wait every article from you, hopefully my science in this field is increasing

I am glad I found this. A big thank you to you. I will study it and I hope to be able to use it.

Thank you for these posts @arcange. I am sure your bots will find this message ;) I just started python and sql with a bit of html experience, because of steemit, I want to dig deep into data, and I am trying your codes etc...I am learning while doing. Thanks again.

Glad you have fun digging into data ;)

got my gloves and shovel. Do you know which table.row contains steempower total?

These blogs are well set out and still relevant. Thanks!

Steen Power is not stored in the database because it is a dynamic value that has to be computed/reevaluated each time

  ·  7 years ago (edited)

Arghhh. Do you know if there is a place i can scrape recent SP from?

Its strange, because my Steem in the Steem Power Wallet is static until i power-up, or collect a reward. Do you know where this number is held if not in the DB?

Thanks for your time!

Is there a steemsql server on discord?

Support for SteemSQL is provided on https://steem.chat/channel/steemsql

I am onboard for this. Cool tutorial

Thanks

ありがとうございました。Nice work!!!

Leaving a comment since i cant seem to find the resteem button

I tried to login SteemSQL, but ' ID/PW: steemit ' isn't working, Is it changed??

Check SteemSQL website: https://steemsql.com

@callmewill, please stop downloading the full contents of tables!
This has a negative impact on the server performances and bandwidth and penalize all SteemSQL users.

oh, really? sorry for that. I just tried to download a few contents and figured out how can i do this..

Hi, top! Question: Can you extract the historical steem_per_mvests? I would use it to make calculations