bitcoin-etl
sqlchain
| bitcoin-etl | sqlchain | |
|---|---|---|
| 1 | 3 | |
| 388 | 66 | |
| 3.4% | - | |
| 0.0 | 0.0 | |
| about 1 month ago | almost 4 years ago | |
| Python | Python | |
| MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
bitcoin-etl
-
How to import bitcoin blockchain to postgres?
I am thinking about using https://github.com/blockchain-etl/bitcoin-etl project to get transactions data as JSON, maybe convert it to csv through jq and then use psql COPY to import.
sqlchain
- Bitcoin Core RPC 'getrawmempool' payload size?
- How to check the checksum of the blk_____.dat files?
-
Where to get on chain data?
I wrote a sql layer in python to run on your node called sqlChain. If you're interested in building something like these sites then you can play with this and add modules on top. It's open source and fairly efficient (can store the blockchain in less space than a node), but requires a good system with fast SSD to be viable.
What are some alternatives?
dbt-databricks - A dbt adapter for Databricks.
blockchain-certificates - Used to create, issue, revoke, or validate certificates (or any other PDF file) on the public Bitcoin blockchain.
bitcoinacceptor-python - BitcoinAcceptor: Accept Bitcoin, Bitcoin Cash, or Bitcoin SV without spending any in the process
ethereum-etl - Python scripts for ETL (extract, transform and load) jobs for Ethereum blocks, transactions, ERC20 / ERC721 tokens, transfers, receipts, logs, contracts, internal transactions. Data is available in Google BigQuery https://goo.gl/oY5BCQ
walletool - a tool for reading wallet.dat files
BigQuery-Python - Simple Python client for interacting with Google BigQuery.
autominer - Web3 project automation script. Supports Baked Beans Miner, Grinch Bucks Miner, BNB Miner and others!
TipBot - Cryptocurrency TipBot
bitcoinlib - Bitcoin and other Cryptocurrencies Library for Python. Includes a fully functional wallet, Mnemonic key generation and management and connection with various service providers to receive and send blockchain and transaction information.
blkchain - Fast import of the blockchain into PostgreSQL.
discover-cash - A global crypto merchant directory powered by OpenStreetMaps.
awesome-bigquery-views - Useful SQL queries for Blockchain ETL datasets in BigQuery.