[SteemSQL Wrapper] Custom limit of rows

in utopian-io •  7 years ago  (edited)

I did not indicate this in the previous posts but SteemSQL Wrapper has a limit for records to return, meaning that you cannot write something like SELECT * FROM Comments and get 21,166,246 rows (but please, even do not try doing it, especially on your own SteemSQL connection).

out.gif

Initially, SteemSQL Wrapper had a hardcoded limit in 5k rows but today I published changes which allow you to change it. By default, it is set up on 500 rows. But you can easily change it — just move the slider or enter your number in the input field. Right now it still has constraints — you can set up a limit only up to 5k.

I am still not sure which max constraint will be the best because in many cases users can hurt SteemSQL or even themselves. For example, if a user will forget to write TOP in a base query (like in my above example) then their browser in the most cases will be freeze or even will collapse.

Also, my project is more for small data because right now you cannot do a serious analysis with dozens of thousands of rows — SteemSQL Wrapper just does not have any tools for this. Anyway, I would like to hear your feedback and any suggestions about this constraint.

My commit

image

P.S. Also, I think that anyone who has an interest in SteemSQL Wrapper or SteemSQL should read (and upvote/resteem) the recent post of @arcange.



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:  

Thank you for the contribution. It has been approved.

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

SteemSQL Wrapper is an amazing tool and I'm so grateful you put a limit on the number of returned rows.

Thanks for pointing out that issuing queries like SELECT * FROM table is definitely not a good idea!

People who want do download or parse the whole blockchain content should not use SteemSQL but use a steemd node.

Thank you for so valuable project!
Also, you are the first who got my witness vote ;)

I am just curious, what do you think about advertising supporters? In theory, you can get a payment of your hosting fees from some advertisers (e.g. from database hostings, startups to monitor/analyze data, or maybe crypto-related). Something like http://httpbin.org or the most open source projects.
And I think you need also add your BTC/ETH wallets (or maybe even PayPal).

good post @bijoy123

interesting

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

great idea! very useful app. thanks.