Summary

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.

Demo

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 ?sql_query=SELECT..., where 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.

More examples: example_1 example_2 example_3

Proof of Work

I list my username as @maxg in the Pull Request

---

Posted on Utopian.io - Rewarding Open Source Contributors

---