Well, I dont know whether it is genius. Some people would say that it is stupid.
This is how I discovered the 91 people who used to vote NO in the first sms-otp proposal, and now they changed their mind.
Code:
expr `curl -s https://demodun.github.io/mnowatch/the_results_dashd_24-02-2018.html| awk -F"\"container2" '{for(i=2;i<=NF;i++){{print $i}}}'|cut -f1-3 -d"/"|grep freedash| awk -F"\"container3" '{for(i=2;i<=NF;i++){{print $i}}}'|grep using-sms|wc -l` - `curl -s https://demodun.github.io/mnowatch/the_results_dashd_24-02-2018.html| awk -F"\"container3" '{for(i=2;i<=NF;i++){{print $i}}}'|cut -f1 -d"/"|cut -f1- -d"v"|grep freedash|grep using-sms|wc -l`My site is hosted in github.io where they do not allow databases or sql queries. This difficulty made me angry, and as long as I would not like the proverb "the bad workman blames his tools" to characterize me, the above code is an alternative way to simulate the below (simplified) sql query:
Code:
select count(voters) from votes_table where voted_for_getgreedash=yes and voted_for_sms-otp=no;In my method the data are stored in pure html table format. They are pure html tables, they are not obscure JSON or unreadable sqlite.db data. They can be displayed directly into a browser without using any code, thus they can be readed by ordinary humans. Additionaly I do not execute queries in my site, you should do it by yourself in your computer by using the appropriate combination of curl, grep, sed, wc, sort, uniq and awk commands. So you dont have to trust me that I execute the queries correctly. You also dont have to trust any javascript that I may download into your browser in order to execute queries. By constructing your own query (using the appropriate combination of curl, grep, sed, wc, sort, uniq and awk commands) you trust only yourself. Finnaly, on what it concerns the data integrity and accuracy, you can certainly trust the integrity and accuracy of the html data I provide, because the html file can be reproduced, replicated and tested by anyone who executes my script in his own system. So my method is trustless....and in that sense, Satoshi would be proud of me.
Last edited:
