A Scala framework for the development of general-purpose analytics on blockchains, by Livio Pompianu, Stefano Lande, and Daniele Stefano Ferru.
Our framework allows to combine data within the blockchain with data from the outside (e.g. exchange rates and tags). The workflow consists in two steps:
- construct a view of the blockchain and save it in a database;
- analyse the view by using the query language of the database.
The blockchains currently supported are Bitcoin and Ethereum. The DBMS currently supported are MongoDB and MySQL.
The library is dicussed in A general framework for blockchain analytics.
More material is available in the project page.
The Scaladoc (uploaded on this repository in the doc folder) is also available at the following link.
Prerequisites depends on the target analyses. Generally speaking the framework needs at least one blockchain client and one DBMS.
- Blockchain clients:
- Bitcoin Core (extracts data from Bitcoin)
- Parity (extracts data from Ethereum)
- DBMS:
- MongoDB (constructs a NoSQL view of the data)
- MySQL (constructs a SQL view of the data)
- PostgreSQL (constructs a SQL view of the data)
- Either
- use an IDE for executing a Scala SBT project (we used IntelliJ IDEA) or
- use the command line in place of an IDE (Install SBT)
Before building the project, execute the following commands:
git clone https://github.com/bitbart/bitcoinj.git
cd bitcoinj
git checkout segwit
mvn install -DskipTests
cd core
mvn install -DskipTests
In order to use the ICO
class (created to retrieve ICOs data) you must require the respective API keys:
- EtherScan
- It is sufficient to sign up and then go here
- ICOBench
- Ethplorer
- There is a default, free key:
freekey
. If you need more data or highload of service, you can to get personal API key.
- There is a default, free key:
After doing these steps, do the following:
- Copy
EtherScan
key intoEtherScanAPI.apiKey
attribute - Copy
ICOBench
private key and public key intoICOBenchAPI.privateKey
andICOBenchAPI.publicKey
attributes respectively - Copy
Ethplorer
key intoEthplorerAPI.apiKey
attribute
- Execute the blockchain client in order to obtain a local copy of the target blockchain (this process may take several hours)
- Enable the client RPC calls.
- In the Bitcoin Core case
bitcoind -datadir=path/to/blockchain -server -rpcuser=user -rpcpassword=password
- In the Bitcoin Core case
- Run a localhost instance of the DBMS on the default port.
- Clone this repository.
- From your IntelliJ welcome screen: select "Import Project" and open the build.sbt file from your repository directory.
- Execute of one of the available examples. Either
- open the file from your IDE and select run or
- use the command line: from the root directory of the project, execute
sbt "runMain tcs.examples.ClassName"
Our framework will build the selected database. Then you can query it for performing your analysis. For each available Scala script, we provide some default queries along with the resulting csv files.