SteemSQL Wrapper works again (and it is still FREE!)

in #utopian-io6 years ago (edited)

Recently SteemSQL has moved to a monthly subscription model and the default free account/password «steemit/steemit» has been disabled. It means that SteemSQL Wrapper has been disabled too. But I updated it and now you can again use it. Moreover, you can use it for free!

https://sql.steemhelpers.com

image.png

New SteemSQL account

I bought the SteemSQL subscription and moved all private data to ENV variables.

New infrastructure

I also changed an infrastructure. Initially, I just used aiohttp for API and rendering templates and hosted all this on DigitalOcean. But I have big plans to improve the project (e.g. a feature to save your SQLs, autocomplete, a complex system for creating graphs, and many others) and almost all future features will host only on frontend. For their implementation, I have plans to rewrite the whole project to VueJS. But I also almost do not have plans to change the backend code.

So I decided to split the project hosting — now the backend with API is located on DigitalOcean and the frontend is located on Netlify. Why? Because it is a great hosting for frontend which provides many out-of-the-box features that require only one click (like SSL, continuous deployment, prerendering, instant rollbacks, preview, etc), also it provides global CDN, meaning that SteemSQL Wrapper will load much faster.

I also have plans to create a reserve system for API with Netlify Lambda functions. For example, if my DigitalOcean server will get some troubles or will be under maintenance, you anyway can use SteemSQL Wrapper.

Improved the python code

Initially, all the backend code was hosted in one file but now it is split into views and main (the last has the base code for aiohttp servers, like CORS, routes, settings for templates, etc). Also, I made several changes to improve quality and readability of the code.

Disabled public API

Because of SteemSQL has moved to a monthly subscription model, I removed the public API and updated settings for CORS.

Fixed some bugs

The project had a few bugs but now I fixed them. For example, if you just enter to the website and click to «Share Query» then your URL will change to https://sql.steemhelpers.com/?sql_query=. But now this is fixed.

SteemSQL Wrapper

SteemSQL Wrapper allows use SteemSQL right in your browser without any dependencies. It even allows using the several most popular queries with one click. It means that non-tech users no longer need to install any drivers/Excel and learn programming languages. They can just go to SteemSQL Wrapper and write any SQL queries to get results right in their browser. Moreover, the project displays the database structure and users can know exactly what tables and columns they need and how to create analyses which they want.

Commit



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

Thank you for the contribution. It has been approved.

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

Hey @vladimir-simovic, I just gave you a tip for your hard work on moderation. Upvote this comment to support the utopian moderators and increase your future rewards!

Thanks a lot for your work, @emptyname.
Regards.

@emptyname, Like your contribution, upvote.

Hi Emptyname,

her the official Rules:

The linked Github repository must always contain code, a README and a license.

Please select a license and complete the Readme. md for installation and usage information.

@emptyname im so blessed with this wonderful contribution of yours
Keep it up boss

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

Coin Marketplace

STEEM 0.35
TRX 0.12
JST 0.040
BTC 70733.96
ETH 3563.16
USDT 1.00
SBD 4.76