[SteemSQL Wrapper] Added the export to Markdown

in utopian-io •  7 years ago  (edited)

While I was working on various analyses for Steemit, I started hating the Markdown tables. Why? Because if you want to include tables in your analysis then you need to manually copy/paste and format all rows. And if you have many rows then you also will start to hate this process.

But it is easy to automate.

image.png

And now SteemSQL Wrapper gives a possibility to you convert any table with Steemit data to Markdown with one click. You need to write a SQL query, get results, and then you will see the Export button. If you will click the button for exporting to Markdown then SteemSQL Wrapper will open a new window (or a tab, it depends on your browser settings) with a clear Markdown table. The export to Excel right now is not available but I will add it in the near future.

Important note: sometimes your browser can block the opening of a window, in this case, you should allow it (see the below GIF) and click the export button again.

out.gif

In the GIF I used the next query:

SELECT TOP 30 author, pending_payout_value, net_votes, children, title, url
FROM Comments
WHERE
    parent_author='' AND
    created >= '2017/12/12' AND
    created < '2017/12/19' AND
    category='utopian-io'
ORDER BY pending_payout_value DESC

Commit #1
Commit #2

image



Posted on Utopian.io - Rewarding Open Source Contributors

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:  

Good to see export to markdown that is something people will want to use often and will help in making posts more informative.

Beside mark down it would maybe also be nice to add a direct link option, that links to just only the result/raw data, without styling. this way people can use the data as a web-api.

Thanks! API already is created — it returns JSON with all headers and rows :)

This post has received a 0.24 % upvote from @drotto thanks to: @banjo.

Thank you for the contribution. It has been approved.

You can contact us on Discord.
[utopian-moderator]

Thanks!

Hey @emptyname I am @utopian-io. I have just upvoted you!

Achievements

  • You have less than 500 followers. Just gave you a gift to help you succeed!
  • Seems like you contribute quite often. AMAZING!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x