Sort:  

No, it's taking on some of the role that steemd currently has. But steemd will always continue to provide a focus on blockchain consensus.

Guess there would be more development that could join hivemind later on

No, Hivemind is not meant to replace steemd but work on top of it. Hivemind is a godsend for those who do not want to rely on SteemSQL, a paid service, for pulling up information from the blockchain to run analytics on the blockchain. Hivemind is also meant to operate not too far behind the latest block so the information will be quite up to date.

Being able to pull this data into a sql database will have massive use implications we can run on steemit. We could see better curation programs, ways to enhance our feeds and find relevant content faster. Hivemind looks very cool, gave you a follow @inertia and look forward to learning more about this initiative.

Saw this comment below from @chekohler and I wonder:

What would it take to be able to make queries like these to hivemind straight from script.js file like we currently get to do with steem.api.getDiscussionsByBlog as an example.