Last week I submitted a feature idea for @emptyname's SteemSQL Wrapper project. I reached out to him on Discord and asked about implementing it myself, and he gave me the green light! My PR has been merged and deployed, so here's a summary of what I did.
New Feature: Make Queries Shareable
If you click on this link, it will take you to the SQL query shown in the video above. Queries can now be represented as URL links, which can be shared, bookmarked, etc. This makes it easy to share reports or show other people data - instead of giving them a link to the wrapper and a query to paste in, you can just give them a link!
This was done by encoding the query as a URL parameter. You can see in the video or in your browser that when the user clicks the
Share Query link, the URL changes. We add on
SELECT... is the URL-encoded query. Then, when the page is reloaded, we parse the querystring to get the original SQL statement and input it into the browser.
Proof of Work
Posted on Utopian.io - Rewarding Open Source Contributors