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

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

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

---