Shouldn't the STEEM blockchain already be indexed? This seems like if it is not it should be a part of HF20 or at least HF20.1 if it cannot included in the primary fork. This actually leaves me a bit dismayed.
While witness servers are looking at an ever increasing RAM allocation one would think that indexing is something that could reduce the need for RAM. What I am hoping is that the indexing is only missing from the SteemSQL interface and not the actual STEEM BC.
I like your proposal and I hope it gets serious consideration. Your proof of concept will go a long way in getting that added to the upcoming HardForks. All I know is that something has to be done.
Return Of The Flag Wars ...
... was the name of one of my more recent post about a war most of us are familiar with.
Reward Pool Rape, be it deliberate or unintentional is a problem. The Flaggers are filled with hate and vitriol and it is directed at the ones on the receiving end of the rewards and more unfortunately, their followers. It is directed at both parties with extreme vitriol and what appears to be malice.
The language is abusive and demeaning, and this for a flaw that is entirely system based and was only uncovered when a particular user became famous over night for what in my opinion are in fact not only valid post but generally post that have great value.
Looking forward to seeing you get this proof of concept launched.
I want to see a civilized STEEMtopia going forward.
I don't really know much about how the blockchain and steem software operates behind the scenes, I imagine it is indexed in useful ways to allow nodes to run efficiently. Steemsql, by it's nature is a third party service and SQL is not inherently part of the BC structure - so it seems Steemsql might be a bit limited in comparison to what a full relational database version of the BC could be.
The index I am creating is more of an index in the sense that google indexes pages on the web, rather than in the context of a database index for performance - I'm just running a test of my script now on one of my servers - I might even get a full index kicked off tonight, but it depends on how much time and resources it's going to take as to whether i attempt that without any optimisations made.
fingers and toes crossed! thanks for your witness vote :)