definitions and sql storage for the Ethereum Haskell project.
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
fastNonceFinder
src/Blockchain
.gitignore
LICENSE
README
Setup.hs
ethereum-data-sql.cabal

README

This repository is a library of common data structures for the ethereum haskell project.

Indexing recommendations:
Run psql eth while ethereumH is populating the database and

CREATE INDEX CONCURRENTLY ON block_data_ref (block_id);
CREATE INDEX CONCURRENTLY ON block_data_ref (number);
CREATE INDEX CONCURRENTLY ON block_data_ref (hash);
CREATE INDEX CONCURRENTLY ON block_data_ref (parent_hash);
CREATE INDEX CONCURRENTLY ON block_data_ref (coinbase);

CREATE INDEX CONCURRENTLY ON address_state_ref (address);

CREATE INDEX CONCURRENTLY ON raw_transaction (from_address);
CREATE INDEX CONCURRENTLY ON raw_transaction (to_address);
CREATE INDEX CONCURRENTLY ON raw_transaction (block_id);
CREATE INDEX CONCURRENTLY ON raw_transaction (block_number); 

CREATE INDEX CONCURRENTLY ON storage (key);