validitylabs / Ethereumdb
Licence: mit
Stars: ✭ 21
Programming Languages
python
139335 projects - #7 most used programming language
Projects that are alternatives of or similar to Ethereumdb
Etherscan Ml
Python Data Science and Machine Learning Library for the Ethereum and ERC-20 Blockchain
Stars: ✭ 55 (+161.9%)
Mutual labels: blockchain, ethereum, data-science
Eth Indexer
An Ethereum project to crawl blockchain states into database
Stars: ✭ 98 (+366.67%)
Mutual labels: blockchain, ethereum, database
Ethereum Development With Go Book
📖 A little book on Ethereum Development with Go (golang)
Stars: ✭ 754 (+3490.48%)
Mutual labels: blockchain, ethereum, open-source
Etgate
Ethereum-Tendermint token sending gateway
Stars: ✭ 23 (+9.52%)
Mutual labels: blockchain, ethereum
Emerald Vault Archive
ARCHIVE. CODE MOVED TO:
Stars: ✭ 18 (-14.29%)
Mutual labels: blockchain, ethereum
Awesome Decentralized Finance
A curated list of awesome decentralized finance projects
Stars: ✭ 793 (+3676.19%)
Mutual labels: blockchain, ethereum
Gdai.io
gDAI - Gas less DAI transfers by using GSN, Fulcrum and KyberNetwork
Stars: ✭ 26 (+23.81%)
Mutual labels: blockchain, ethereum
Node
Stampery API for NodeJS. Notarize all your data using the blockchain
Stars: ✭ 23 (+9.52%)
Mutual labels: blockchain, ethereum
Multy Back
Back-end of the Multy - mobile multy-blockchain wallet.
Stars: ✭ 26 (+23.81%)
Mutual labels: blockchain, ethereum
Token Core Ios
a blockchain private key management library on iOS
Stars: ✭ 850 (+3947.62%)
Mutual labels: blockchain, ethereum
Blockchain Reading List
Blockchain Manchester Meetups, Talks and Reading List
Stars: ✭ 17 (-19.05%)
Mutual labels: blockchain, ethereum
Graph Node
Graph Node indexes data from blockchains such as Ethereum and serves it over GraphQL
Stars: ✭ 884 (+4109.52%)
Mutual labels: blockchain, ethereum
Oyente
An Analysis Tool for Smart Contracts
Stars: ✭ 820 (+3804.76%)
Mutual labels: blockchain, ethereum
Aeternity
æternity: solving scalability problems by making sense of state-channels
Stars: ✭ 923 (+4295.24%)
Mutual labels: blockchain, ethereum
Awesome Blockchain
⚡️Curated list of resources for the development and applications of blockchain.
Stars: ✭ 937 (+4361.9%)
Mutual labels: blockchain, ethereum
Weiwallet Android
Wei Wallet is an open source Ethereum wallet for Android
Stars: ✭ 20 (-4.76%)
Mutual labels: blockchain, ethereum
Stromdao Businessobject
Abstract BusinessObject for StromDAO Energy Blockchain. Abstraction layer between blockchain technology and business logic providing energy market related entities and use cases.
Stars: ✭ 10 (-52.38%)
Mutual labels: blockchain, ethereum
Typechain
🔌 TypeScript bindings for Ethereum smart contracts
Stars: ✭ 769 (+3561.9%)
Mutual labels: blockchain, ethereum
EthereumDB (Python and SQL)
Create the EthereumDB containing data residing on the Ethereum blockchain. Database management system: SQLite.
Create a database
- Connect to Infura (or run a local node).
- Uncomment and specify the path in
database.py:
#uncomment one of the options below
# 1. connection via Infura
#web3 = Web3(Web3.HTTPProvider("https://mainnet.infura.io/your-personal-number"))
# 2. or connection via local node
#web3 = Web3(Web3.IPCProvider('/your-path-to/geth.ipc'))
- execute:
python database.py
More on database design
Database consists of 3 tables:
- Quick: most relevant transaction info for quick access & analysis
- TX: all remainder transaction info
- Block: block-specific info
| Quick | TX | Block |
|---|---|---|
| 'from'/'sender', 'to'/'recipient', 'value', 'nonce', 'blockNumber', 'txHash', 'balanceTo', 'balanceFrom' | 'blockNumber', 'gas', 'gasPrice', 'input', 'transactionIndex', 'v', 'r', 's', 'contractAddress', 'cumulativeGasUsed', 'gasUsed', 'logs', 'logsBloom', 'status', 'transactionHash' | 'difficulty', 'extraData', 'gasLimit', 'blockGasUsed', 'blockHash', 'blockLogsBloom', 'miner', 'mixHash', 'blockNonce', 'blockNumber', 'parentHash', 'receiptsRoot', 'sha3Uncles', 'size', 'stateRoot', 'timestamp', 'totalDifficulty', 'transactions', 'transactionsRoot', 'uncles' |
Meaning of the variables in the EthereumDB
Quick
| Variable | Meaning |
|---|---|
| sender | 160-bit address of a sender of a transaction |
| recipient | address of the recipient or null for a contract creation transaction |
| value | number of wei to be transfered to the recipient or newly created account (case of contract creation) |
| nonce | number of transactions/contract creations sent by the sender prior to this one |
| blockNumber | number of the block the transaction belongs to (PRIMARY KEY) |
| txHash | transaction hash (unique identifier) |
| balanceTo | balance of the recipient after that transaction (note: different than balance from web3 which is after all tx-s in the block) |
| balanceFrom | balance of the sender after that particular transaction (note: different than balance from web3 which is after all tx-s in the block) |
TX
| Variable | Meaning |
|---|---|
| blockNumber | number of the block the transaction belongs to |
| gas | gas consumed by the transaction |
| gasPrice | number of Wei to be paid per unit of gas for all computatioon costs of this transaction |
| input | the data sent along with the transaction |
| transactionIndex | index of the transaction in the block |
| v, r, s | used to identify the sender; the signature values of the transaction |
| contractAddress | the contract address created, if the transaction was a contract creation, otherwise null |
| cumulativeGasUsed | the sum of gasUsed by this transaction and all preceding transactions in the same block |
| gasUsed | the total amount of gas used when this transaction was executed in the block |
| logs | array of log objects, which the transaction has generated |
| logsBloom | the Bloom filter from indexable info (logger address and log topics) contained in each log entry from the receipt of each transaction in the transaction list |
| status | boolean whether the transaction was successfull; false if the EVM (Ethereum Virtual Machine) reverted the transaction |
| txHash | transaction hash (unique identifier) (PRIMARY KEY) |
Block
| Variable | Meaning |
|---|---|
| difficulty | scalar value corresponding to the difficulty level of the block |
| extraData | extra data in byte array |
| gasLimit | maximum gas expenditure allowed in this block |
| blockGasUsed | total gas used by all transactions in this block |
| blockHash | hash of the block |
| blockLogsBloom | the Bloom filter from indexable info (logger address and log topics) |
| miner | 160-bit address for fees collected from successful mining |
| mixHash | 256-bit hash, which is combined with the nonce and used to prove that sufficient amount of computation has been carried out on this block |
| blockNonce | hash of the generated proof-of-work; null when its a pending block |
| blockNumber | scalar value equal to the number of ancestor blocks (genesis block=0) |
| parentHash | Keccak256 hash of the parent block's header |
| receiptsRoot | Keccak 256-bit hash of the root node of the tree structure populated with receipts of all transactions in this block |
| sha3Uncles | SHA3 of the uncles data in the block. |
| size | size of the block in bytes |
| stateRoot | Keccak256 hash of the root node if the state trie, after all transactions are executed and finalisations applied |
| timestamp | Unix's time() at this block's inception |
| totalDifficulty | integer of the total difficulty of the chain until this block |
| transactions | list of transaction hashes included in the block |
| transactionsRoot | Keccak256 hash of the root node of the trie structure populated with the receipts of each transaction in the transactions list |
| uncles | list of uncle hashes |
source1 source 2 source 3 source 4 source5
How to use the database
import sqlite3 as sq3
conn = sq3.connect("blockchain.db")
cur = conn.cursor()
# some SQL code, e.g. select first five entries of the table Quick
cur.execute("SELECT * FROM Quick LIMIT 5")
a = cur.fetchall() #list of tuples containing all elements of the row
print(a)
conn.close()
Warning: the full database is large. You might not be able to open everything in one go.
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].