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).
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.
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
Thank you for the contribution. It has been approved.
You can contact us on Discord.
[utopian-moderator]
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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).
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
good post @bijoy123
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
interesting
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hey @emptyname I am @utopian-io. I have just upvoted you!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
great idea! very useful app. thanks.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit