[STEEM BOUNTY] European Commission EFTG Project – Integrating ElasticSearch on a Private STEEM Blockchain

Utopian for European Commission (EC):

Utopian.io is running this task request on behalf of the EC Blockchain Competence Center (BLKCC).

GitHub Repository:

https://github.com/scr53005/eftg-steem

Project Background:

The EFTG Project's background and scope are described here:
European Financial Transparency Gateway (EFTG) EC Initiative

Estimated Task Complexity:

Medium

Task Specifications:

We need script(s) for reading records from the blockchain and pushing the records to a database.

Goal(s)

Develop the script needed for reading and retrieving records from the ledger, a full RPC node. After retrieving the records, push the results to the Elasticsearch database, in real time.

The script should query the ledger, every 3 seconds:

• for new posts
• each time a new post is validated

The script should extract the JSON metadata (records) and push these records to the Elasticsearch database.

Ideally, the script should be triggered automatically whenever a new RPC node is created.

Deliverables

• A full guide on how to install and setup the Elasticsearch and Kibana (Logstash optional)
• The script (with clear comments) and the instruction on how to run the script
• The structure of the database, schema, and relevant indices
• Demo for Kibana dashboard and queries

Deadline:

Three (3) weeks, set to start once the candidate selection is made.

How to Register Interest and Gather Further Information:

Please contact us on https://discord.gg/pV5hgDA

Rewards Information:

Rewards generated by this task request will be sent as liquid STEEM to the task solver once the task is completed, as decided by the Project owner.

The task will be considered complete after it has been tested and accepted on our private STEEM blockchain (https://explorer.blkcc.xyz/#/) and when the solvers publish a Utopian post, explaining what they did in order to solve the task.