See Also
Bitcoin Blockchain to MySQL ETL Tool
Crypto.BI Toolbox comes with an ETL tool that allows you to extract data from the block DAT files and import the blockchain into MySQL. If you got the blocks directory configuration set up correctly, then you can run the ETL tool. Go to the Crypto.BI Toolbox installation directory and run: $ ./toolbox/db/blocks_to_sql > <output_file.sql> This […]
ELI5 Bitcoin Puzzle Transactions
As the name implies, Bitcoin puzzle transactions are created as a challenge and not for the usual purpose of monetary transfer. Puzzles can be published for several reasons, including software test bounties, marketing campaigns or just for fun. Early Puzzles In the early days of Bitcoin, when $BTC coins could be found for free on […]
ELI5 Proof of Stake (PoS) – How does PoS work?
In the cryptocurrency universe, Proof of Stake (PoS) is one of the most popular alternatives to the Proof of Work (PoW) family of consensus mechanisms. While PoW systems invest large amounts of energy to make sure transactions are legit, PoS does not require mining hardware. Proof of Stake “miners” (stakers) must lock a financial stake […]
Bitcoin Blockchain to MySQL Insertion Tool
Crypto.BI Toolbox comes with a raw .dat block file to MySQL insertion tool called blocks_inserter. To use it, first you’ll need to generate the MySQL schema on your local server by importing scripts/sql/mysql/cryptobitoolbox_bitcoin.sql into your MySQL server. Then you will need to configure Toolbox with the appropriate username, password, host and database so that Toolbox […]